Datawarehouse Developer Manufacturing

Location: Alameda, California, United States; on-site work required

Annual base salary: $95,000–$145,000 per year

Company

hirify.global is a global healthcare company that designs, develops, manufactures, and markets innovative medical products and therapies for challenging medical conditions.

What you will do

• Design, develop, and maintain SQL databases, stored procedures, views, functions, complex queries, data marts, and analytical models.
• Develop and support ETL and data integration processes connecting ERP, MES, quality, and other manufacturing systems.
• Build reports, dashboards, KPIs, and reporting datasets covering production, yield, inventory, downtime, quality, and operational efficiency.
• Partner with Data Warehouse Architects, Manufacturing, Supply Chain, Quality, Engineering, business stakeholders, and offshore developers to deliver scalable analytics solutions.
• Analyze manufacturing data, validate data integrity, optimize database performance, and identify root causes and process-improvement opportunities.
• Support testing, deployments, production issue resolution, documentation, automation, data governance, security, QMS, and regulatory compliance.

Requirements

• Bachelor’s degree in Computer Science, Information Systems, Engineering, Data Analytics, or a related field with 3+ years of SQL development and database programming experience, or an 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 with ETL, data integration, data warehouse architectures, dimensional data modeling, reporting solutions, and cloud-based analytics platforms in Microsoft Azure.
• Experience with business intelligence tools such as Power BI, Tableau, or equivalent platforms, including reports, dashboards, and data-driven solutions.
• Experience with Azure Databricks for data engineering, data transformation, and analytics workloads.
• Knowledge of ERP systems such as SAP, Oracle, or Microsoft Dynamics, plus experience with Manufacturing Execution Systems and production data integration.
• Understanding of manufacturing metrics including OEE, yield, throughput, scrap, cycle time, and downtime.
• Experience in regulated manufacturing environments such as medical devices, life sciences, or pharmaceuticals; familiarity with Agile and software development lifecycle practices.
• Strong analytical, troubleshooting, problem-solving, communication, documentation, stakeholder-management, organizational, and prioritization skills, with accuracy and attention to detail.
• Proficiency with Microsoft Word, Excel, and PowerPoint.

Nice to have

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

Culture & Benefits

• Collaborative teamwork environment with continuous learning and performance recognition.
• On-site general office environment; occasional business travel may be required at 0%–5%.
• Benefits for eligible employees include medical, dental, vision, life, AD&D, short- and long-term disability insurance, and a 401(k) with employer match.
• Paid parental leave, eleven company holidays, at least fifteen days of accrued vacation increasing with tenure, and paid sick time are provided in accordance with applicable laws.
• The role requires moving between buildings and floors, lifting or moving up to 20 pounds, and remaining stationary while using office equipment for extended periods.