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.

What We Offer

A collaborative teamwork environment where learning is constant, and performance is rewarded.
The opportunity to be part of the team that is revolutionizing the treatment of some of the world's most devastating diseases.
A generous benefits package for eligible employees that includes medical, dental, vision, life, AD&D, short and long-term disability insurance, 401(k) with employer match, paid parental leave, eleven paid company holidays per year, a minimum of fifteen days of accrued vacation per year, which increases with tenure, and paid sick time in compliance with applicable law(s).

Penumbra, Inc., headquartered in Alameda, California, is a global healthcare company focused on innovative therapies. Penumbra designs, develops, manufactures, and markets novel products and has a broad portfolio that addresses challenging medical conditions in markets with significant unmet need. Penumbra sells its products to hospitals and healthcare providers primarily through its direct sales organization in the United States, most of Europe, Canada, and Australia, and through distributors in select international markets. The Penumbra logo is a trademark of Penumbra, Inc.

Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, age, disability, military or veteran status, or any other characteristic protected by federal, state, or local laws.

If you reside in the State of California, please also refer to Penumbra's Privacy Notice for California Residents.

For additional information on Penumbra’s commitment to being an equal opportunity employer, please see Penumbra's AAP Policy Statement.