Datawarehouse Developer Manufacturing
penumbraAlameda (CA)
Datawarehouse Developer Manufacturing
Posted today
penumbraAlameda (CA)
SENIORITY
Lead
About the role
Overview:
In this role you design, build, and sustain data solutions that power reporting and analytics across manufacturing and related functions. You will work with cross-functional teams to create scalable data models, ETL processes, and dashboards that drive production efficiency and quality. You’ll partner with architects and offshore teams to ensure robust, compliant analytics platforms. The role offers meaningful impact in a regulated manufacturing setting and exposure to modern data tooling. Compensation / Benefits medical, dental, vision, life insurance AD&D and disability insurance 401(k) with employer match paid parental leave eleven paid holidays per year minimum fifteen days of vacation per year, increasing with tenure
Responsibilities:
Design, develop, and maintain SQL databases, stored procedures, views, functions, and complex queries Support analytics for manufacturing, supply chain, quality, and operations Collaborate with Data Warehouse Architects to define architecture and scalable data models Guide offshore development teams to ensure standards and best practices Develop and support ETL processes integrating ERP, MES, Quality, and other systems Create reporting datasets, data marts, and analytical models for BI initiatives Develop reports, dashboards, and KPIs to monitor production performance and operational metrics Analyze data to identify trends, root causes, and process improvement opportunities Optimize database performance via tuning, indexing, and design enhancements Validate data accuracy and integrity across platforms Gather requirements from business stakeholders and translate them into technical solutions Support system enhancements, testing, deployment, and issue resolution Prepare technical documentation, data mappings, and solution designs Ensure data governance, security, and regulatory compliance Support continuous improvement through automation and advanced analytics Adhere to QMS and regulatory standards Understand security, privacy, and compliance relevant to the company Ensure colleagues follow QMS and regulations Perform other duties as assigned
Key requirements:
Bachelor's degree and 3+ years of SQL development and database programming Proficiency with Microsoft SQL Server and Azure SQL databases (T-SQL, stored procedures, views, functions, query optimization) Experience ETL development and data integration Experience with data warehouse architectures, dimensional modeling, and reporting solutions Strong analytical and problem-solving abilities Experience collaborating with DW Architects, stakeholders, and offshore teams Experience developing reports and dashboards using BI tools Knowledge of ERP systems (SAP, Oracle, or Microsoft Dynamics) Experience with MES and production data integration Excellent communication, documentation, and stakeholder management Experience with Power BI, Tableau, or other BI platforms Experience with Azure Databricks for data engineering and analytics workloads Understanding of manufacturing metrics (OEE, yield, downtime, etc.) Experience in Microsoft Azure cloud data/analytics platforms Experience in regulated manufacturing environments (medical devices, life sciences, or pharmaceuticals) Familiarity with Agile and SDLC practices Strong written and verbal communication and attention to detail Proficiency with MS Word, Excel, PowerPoint Strong organizational skills and multi-project prioritization communication stakeholder management problem-solving SQL Server Azure SQL Database T-SQL
Before you apply
Applying takes about a minute. These four things decide how fast it moves after that.
Your profile is current
It's what we read first. Occupations, seniority and locations matter more than a long history.
Two examples you can talk through
Not a portfolio — just two pieces of work where you can explain the decisions and what you'd change.
A number in mind
What you're on now and what would make you move. We negotiate better when we know both.
Your notice period
Employers plan around it, and it's the question that stalls offers most often.
Once you apply, someone reads it and calls you before anything reaches the employer — usually within two working days.