Business Intelligence Developer​/Data Warehouse Architect

Company Overview & Culture

Machine Solutions is the premier provider of advanced equipment and services for the medical device, biopharmaceutical, and blood‑ and plasma‑collection industries. We support our customers’ needs and growth by delivering quality and value through a wide breadth of products. Machine Solutions provides proprietary mechanical solutions to a variety of complex process, testing and device design challenges. Our equipment has become the industry standard for stent crimping, balloon catheter pleating and folding, catheter braiding, and other medical device manufacturing applications.

As a pioneer in radio‑frequency technology, we continue to develop advancing technology for thermal forming, molding and welding plastics for medical manufacturing, biopharmaceutical, and blood‑ and plasma‑processing applications. Our experienced team of engineers automates manual processes that enable increased production volumes and profit margins, and we believe in providing a superior customer experience through a dedicated aftermarket team that is always ready to provide technical service and process support.

• Medical, Dental, Vision Insurance
• 401(k) 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

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 with BI development skills to create scalable data insight solutions.

• Creates self‑service interactive dashboards and paginates reports using tools such as Domo or Power BI.
• Architects data warehouse/data lake solutions to support legacy and next‑generation ERP business intelligence.
• Supports legacy reports and dashboards using SSRS and Power BI.
• Works with business leaders to identify and deliver KPIs and other metrics.
• Develops and maintains ETL (extract, transform, 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 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 system architecture.
• Maintains legacy on‑premises SQL databases.
• Supports BI activity related 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 that 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 of 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…