Barry-Wehmiller-posted 11 days ago
$113,000 - $129,000/Yr
Full-time • Mid Level
Onsite • Flagstaff, AZ
5,001-10,000 employees

COMPANY OVERVIEW & CULTURE: Machine Solutions is the premier provider of advanced equipment and services for the medical device industry. The unified brands of MSI, PlasticWeld Systems, Steeger USA, Intec Automation, and Vante offer a full breadth of products to support customer needs and growth. The company has been instrumental in automating manual processes within minimally invasive device manufacturing operations, as well as in the broader medical device industry. We provide engineered excellence through precision, process, and people. Our solutions support medical devices and biopharmaceutical manufacturers worldwide in advancing healthcare through reliable, scalable technologies. By focusing on delivering quality and value, and by dedicating resources to our aftermarket team for technical service and process support, Machine Solutions provides a superior customer experience. Machine Solutions is privately owned by BW Forsyth Partners, a Barry-Wehmiller Group company. For more, go to www.machinesolutions.com . In alignment with Machine Solutions' values, we have clarified our expectations and commitments for Team Members and Leaders to streamline our efforts in realizing our vision and aspirations. We expect our Team Members to care for people and perform with excellence . They demonstrate this through effective communication, customer focus, driving results, instilling trust, and optimizing work processes. We expect our Leaders to be the message, cultivate enduring relationships, bring out the best in each individual, achieve values-based results, and co-create the future . Our leaders demonstrate this through self-awareness, developing talent, driving engagement, ensuring accountability, leveraging business insight, managing complexity, planning and alignment, and valuing differences. For more, go to https://www.barrywehmiller.com/home JOB OVERVIEW: The BI Developer/Data Warehouse Architect will design, develop, and maintain the Machine Solutions business intelligence platform. This role combines technical expertise in data architecture as well as BI development skills to create scalable data insight solutions.

  • Creates self-service interactive dashboards, paginates reports using tools such as Domo or Power BI.
  • Architects data warehouse/data lake solution to support legacy and next-generation ERP business intelligence.
  • Supports legacy reports and dashboards using SSRS (SQL Server Reporting Services), Power BI.
  • Works with business leaders to identify and deliver KPI’s and other metrics.
  • Develops and maintains ETL (extract, transform, and load) processes.
  • Establishes alerting for pipeline processes and resolves issues.
  • Creates automated reporting solutions for various business stakeholders.
  • Supports bi-directional data integration between Salesforce and ERP.
  • Fields various data requests from parent companies.
  • Creates and maintains out-of-the-box ERP reporting.
  • Troubleshoots and resolves data quality issues.
  • Owns the process for various BI components of ERP implementation.
  • Documents on system architecture.
  • Maintains legacy on-premises SQL databases.
  • Supports BI activity as it relates to acquisition activity, as needed.
  • Develops a master data strategy for Machine Solutions’ next-generation ERP.
  • Collaborates with ERP consultants for data migration.
  • Develops a modern solution for real-time factory floor dashboards.
  • Uses standard or ad hoc queries/reports to extract data from disparate databases or data sources.
  • Analyzes data to produce dashboards, metrics, or insights and identify trends or anomalies.
  • Consults with users or decision makers to identify data sources, required data elements, or data validation standards.
  • Collaborates with development teams to design business intelligence solutions to facilitate data gathering, storage, and retrieval.
  • Other duties as assigned.
  • Bachelor's degree in information technology or related field from an accredited university. Industry certifications are a plus.
  • 5+ years of IT experience in a related capacity.
  • 5+ years' experience working with Microsoft SQL Server.
  • Experience designing analytics with Domo, SSRS, Power BI, Crystal Reports, Tableau.
  • ERP experience, ideally in a discrete manufacturing environment.
  • The ideal candidate will have strong collaborative skills and embrace the entrepreneurial spirit.
  • Any combination of education, training, or experience that demonstrates the ability to perform the duties of the position.
  • High-level knowledge and experience in database management and tuning.
  • Advanced skills in financial reporting.
  • Advanced skills in dimensional modeling.
  • Knowledge and experience with data marts, data warehousing tools, and data lakes.
  • Knowledge and experience with AWS (Amazon Web Services).
  • Knowledge and experience with Infor LN.
  • Knowledge and experience connecting BI systems to CRM (Salesforce, Hubspot)
  • Knowledge and experience writing moderately complex SQL queries.
  • Medical, Dental, Vision Insurance
  • 401k Retirement Plan with Company matching
  • Paid Time off and Paid Sick time
  • Health savings and spending accounts
  • Long-term & Short-term disability
  • Life & AD Insurance
  • Parental Leave
  • Adoption & Fertility Benefits
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service