The Datawarehouse Developer is responsible for designing, developing, and supporting data solutions that enable reporting, analytics, and operational decision-making across manufacturing and related functions. This role collaborates with Manufacturing, Supply Chain, Quality, Engineering, Data Warehouse Architects, and offshore development teams to design scalable data solutions, optimize data processes, and deliver actionable insights that improve production efficiency, product quality, and operational performance. Specific Duties and Responsibilities Design, develop, and maintain SQL databases, stored procedures, views, functions, and complex queries. Experience supporting manufacturing, supply chain, quality, or operations analytics 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. Understand relevant security, privacy, and compliance principles and adhere to the regulations, standards, and procedures that are applicable to the Company. Ensure other members of the department to follow the QMS, regulations, standards, and procedures. Perform other work-related duties as assigned. 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.
Show the full description
- 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, such as a printer or copy machine, 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.
