7 days ago
Alameda, CA, USAMid Level
H1B sponsor
Base Salary
$95k - $145k/yr
Responsibilities
- Design, develop, maintain, and optimize SQL databases, stored procedures, views, functions, complex queries, indexes, and database designs.
- Develop and support ETL and data integration processes connecting ERP, MES, quality, and manufacturing systems.
- Partner with Data Warehouse Architects to design scalable data models, technical architectures, data marts, reporting datasets, and enterprise analytics solutions.
- Create reports, dashboards, KPIs, and analytical models covering production performance, yield, inventory, downtime, quality, and operational efficiency.
- Analyze manufacturing data to identify trends, root causes, and process improvement opportunities.
- Collaborate with offshore developers, business stakeholders, manufacturing, supply chain, quality, and engineering teams to gather requirements and deliver technical solutions.
- Validate data accuracy, consistency, and integrity and support data governance, security, privacy, regulatory compliance, testing, deployments, and production issue resolution.
- Prepare technical documentation, data mappings, business rules, and solution designs and support continuous improvement through automation and process optimization.
- Adhere to the Company's Quality Management System and applicable domestic and global quality regulations, standards, and procedures.
Requirements
- Bachelor's degree in Computer Science, Information Systems, Engineering, Data Analytics, or a related field with 3+ years of SQL development and database programming experience, or an equivalent combination of education and experience.
- Strong proficiency with Microsoft SQL Server, Azure SQL Database/Azure SQL Server, T-SQL, stored procedures, views, functions, and query optimization.
- Experience developing and supporting ETL processes, data integration solutions, data warehouse architectures, dimensional data models, and reporting solutions.
- Experience developing reports, dashboards, and data-driven solutions with Power BI, Tableau, or other business intelligence platforms.
- Experience with Azure Databricks for data engineering, data transformation, and analytics workloads and with cloud-based data and analytics platforms in the Microsoft Azure ecosystem.
- Knowledge of ERP systems such as SAP, Oracle, or Microsoft Dynamics and experience with Manufacturing Execution Systems and production data integration.
- Experience collaborating with Data Warehouse Architects, business stakeholders, and offshore development teams.
- Understanding of manufacturing metrics including OEE, yield, throughput, scrap, cycle time, and downtime.
- Experience in regulated manufacturing environments such as medical devices, life sciences, pharmaceuticals, biotech, or related industries is preferred.
- Strong analytical, troubleshooting, problem-solving, communication, documentation, stakeholder management, organizational, and attention-to-detail skills.
- Familiarity with Agile development methodologies and software development lifecycle practices and proficiency with Microsoft Word, Excel, and PowerPoint.
Benefits
- Competitive compensation package with benefits and equity program when applicable; annual base salary is listed separately.
- Eligible employees may receive medical, dental, vision, life, AD&D, short- and long-term disability insurance, 401(k) with employer match, paid parental leave, eleven paid company holidays, at least fifteen days of accrued vacation increasing with tenure, and paid sick time as required by applicable law.
- The position requires willingness and ability to work on site in a general office environment.
- Business travel may range from 0% to 5%.
- The role may require lifting and moving up to 20 pounds, moving between buildings and floors, and remaining stationary while using office equipment for extended periods.
About Penumbra
Penumbra, Inc. builds minimally invasive medical devices for neurovascular and peripheral vascular conditions—such as aspiration thrombectomy and embolization systems—and rehabilitation technologies. It designs, manufactures, and sells to hospitals and healthcare providers via direct sales in the U.S., EU, Canada, and Australia and through distributors elsewhere. Founded in 2004 and headquartered in Alameda, California, Penumbra is a public company listed on the NYSE.