Datawarehouse Developer Manufacturing

Alameda, CAfull timeOn Site

Apply on Employer Site

mid

$95k–$145k

H1B: no

Penumbrainc Datawarehouse Developer at Penumbrainc responsible for designing and supporting data solutions for manufacturing analytics. Collaborates with multiple teams to optimize data processes and deliver insights.

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.

Qualification

Experience developing reportsKnowledge of ERP systems such as SAPExcellent communicationExperience with Power BIStrong oral

Required

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

Benefits

Equity/RSU

Company

Penumbrainc

View company page

Source: lever

Active within the past hour

More roles at Penumbrainc

Calibration and Equipment Systems Engineer I

Alameda, CA

Fitness Center Attendant T - Swing

Alameda, CA

Quality Engineer II - Catheters

Roseville, CA

Manager, Market Access

Alameda, CA

Boost Your Interview Chances

Improve Resume Match Score

Free

Your Score

9.0

Strong Applicant

Must-Have Skills for This Role

SQLETLData WarehouseReportingDashboardsData Models

Optimize my Resume

Apply Faster with Autofill

Free

Save your profile once. LumiJobs pre-fills the employer's application form so you stop re-typing the same answers on every site.

Apply With Autofill

Or skip LumiJobs's tools and submit directly on the employer's career site.

Apply on Employer Site

Datawarehouse Developer Manufacturing at Penumbrainc · LumiJobs