Datawarehouse Developer Manufacturing

Specific Duties and Responsibilities

• Design, develop, and maintain SQL databases, stored procedures, views, functions, and complex queries.
• Partner with Data Warehouse Architects to design scalable data models, define technical architecture, and develop enterprise analytics solutions.
• Collaborate with offshore developers to provide technical guidance, review deliverables, and ensure adherence to development standards and best practices.
• Develop and support ETL processes that integrate data from ERP, MES, Quality, and other manufacturing systems.
• Create and maintain reporting datasets, data marts, and analytical models supporting manufacturing operations and business intelligence initiatives.
• Develop reports, dashboards, and KPIs to monitor production performance, yield, inventory, downtime, quality, and operational efficiency.
• Analyze manufacturing data to identify trends, root causes, and opportunities for process improvement.
• Optimize database performance through query tuning, indexing strategies, and database design enhancements.
• Validate data accuracy, consistency, and integrity across manufacturing and analytics platforms.
• Work closely with business stakeholders to gather requirements and translate them into technical solutions.
• Support system enhancements, production issue resolution, testing, and deployment activities.
• Prepare and maintain technical documentation, data mappings, business rules, and solution designs.
• Ensure compliance with data governance, security, and regulatory requirements.
• Support continuous improvement initiatives through automation, process optimization, and advanced analytics capabilities.
• Adhere to the Company's Quality Management System (QMS) as well as domestic and global quality system regulations, standards, and procedures.

Position Qualifications - Required

• Bachelor's degree in Computer Science, Information Systems, Engineering, Data Analytics, or a related field with 3+ years of experience in SQL development and database programming, or equivalent combination of education and experience.
• Strong proficiency in Microsoft SQL Server and Azure SQL Database/Azure SQL Server, including T-SQL, stored procedures, views, functions, and query optimization.
• Experience developing and supporting ETL processes and data integration solutions.
• Experience working with data warehouse architectures, dimensional data modeling, and reporting solutions.
• Strong analytical, troubleshooting, and problem-solving skills.
• Experience collaborating with Data Warehouse Architects, business stakeholders, and offshore development teams.
• Experience developing reports, dashboards, and data-driven solutions using business intelligence tools.
• Knowledge of ERP systems such as SAP, Oracle, or Microsoft Dynamics.
• Experience with Manufacturing Execution Systems (MES) and production data integration.
• Excellent communication, documentation, and stakeholder management skills.
• Experience with Power BI, Tableau, or other business intelligence platforms.
• Experience with Azure Databricks for data engineering, data transformation, and analytics workloads.
• Understanding manufacturing metrics including OEE, yield, throughput, scrap, cycle time, and downtime.
• Experience working in cloud-based data and analytics platforms within the Microsoft Azure ecosystem.
• Experience working in regulated manufacturing environments such as medical devices, life sciences, or pharmaceuticals.
• Familiarity with Agile development methodologies and software development lifecycle practices.
• Strong oral, written, and interpersonal communication skills.
• High degree of accuracy and attention to detail.
• Proficiency with MS Word, Excel, and PowerPoint.
• Excellent organizational skills with ability to prioritize assignments while handling various projects simultaneously.

Position Qualifications - Preferred

• Medical device, pharmaceutical, biotech, or other regulated industry experience desired.

Working Conditions

• General office environment.
• Willingness and ability to work on site.
• May have business travel from 0% - 5%.
• Requires some lifting and moving of up to 20 pounds.
• Must be able to move between buildings and floors.
• Must be able to remain stationary and use a computer or other standard office equipment for an extensive period of time each day.
• Must be able to read, prepare emails, and produce documents and spreadsheets.
• Must be able to move within the office and access file cabinets or supplies, as needed.
• Must be able to communicate and exchange accurate information with employees at all levels daily.