Datawarehouse Developer Manufacturing

penumbrainc

Alameda (CA)

On-site

USD 100,000 - 150,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

penumbrainc is seeking a Datawarehouse Developer to design, develop, and support data solutions for reporting, analytics, and operations across manufacturing and related functions.

You will collaborate with Manufacturing, Supply Chain, Quality, Engineering, and offshore teams to create scalable data models, optimize data processes, and deliver insights for production efficiency and quality.

Qualifications

  • Bachelor's degree in Computer Science, Information Systems, Engineering, Data Analytics, or related field with 3+ years of SQL development and database programming.
  • 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 MES and production data integration.

Responsibilities

  • Design, develop, and maintain SQL databases, stored procedures, views, functions, and complex queries.
  • 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.
  • Prepare and maintain technical documentation, data mappings, business rules, and solution designs.

Skills

SQL development
MS SQL Server
Azure SQL
ETL processes
Data warehousing
Power BI
Tableau
Analytics
Communication

Education

Bachelor's degree in Computer Science or related field

Tools

MS SQL Server
Azure SQL Database
Power BI
Tableau
Azure Databricks

Job description

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.
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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Warehouse & BI Engineer
Data Warehouse & BI Engineer

Compunnel Inc. • Charlotte (NC)

On-site
USD 95,000 - 140,000
Data Warehouse & BI Engineer — Flexible Hours
Data Warehouse & BI Engineer — Flexible Hours

Compunnel Inc. • Charlotte (NC)

Hybrid
USD 95,000 - 140,000
Manufacturing Business Analyst
Manufacturing Business Analyst

The Panther Group • New Haven (CT)

On-site
USD 85,000 - 110,000
Data Warehouse Developer
Data Warehouse Developer

Adtran Networks • United States

On-site
USD 100,000 - 150,000
Sr. Data Engineer
Sr. Data Engineer

iSpace Inc. • Anaheim (CA)

Hybrid
USD 120,000 - 160,000
Director, Data Engineering
Director, Data Engineering

Dwyer Instruments, PTY • Michigan City (IN)

On-site
USD 180,000 - 240,000
Data Warehouse Engineer
Data Warehouse Engineer

ExpertsHub.ai • Chicago (IL)

On-site
USD 90,000 - 120,000
Data Engineer
Data Engineer

Aquent • Foster City (CA)

On-site
USD 180,000 - 240,000
Senior Manufacturing Operations & Digitalization Analyst
Senior Manufacturing Operations & Digitalization Analyst

Yanfeng Global Automotive Interiors • Novi (MI)

On-site
USD 90,000 - 120,000
Data Analytics Engineer
Data Analytics Engineer

Joy Baking Group • Lamonts Corners (PA)

On-site
USD 80,000 - 110,000