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.
- May have business travel from 0% - 5%
- Requires some lifting and moving of up to 20 pounds
- Must be able to move between buildings and floors.
- Must be able to remain stationary and use a computer or other standard office equipment, such as a printer or copy machine, for an extensive period of time each day.
- Must be able to read, prepare emails, and produce documents and spreadsheets.
- Must be able to move within the office and access file cabinets or supplies, as needed.
- Must be able to communicate and exchange accurate information with employees at all levels daily.
Annual Base Salary Range: $95,000 - $145,000/ year We offer a competitive compensation package plus a benefits and equity program, when applicable. Individual total compensation will vary based on factors such as qualifications, skill level, competencies, and work location.
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.
