Lead Data Engineer
Lead Data Engineer For over 50 years, SCIEX has been developing groundbreaking technologies and solutions in mass spectrometry and capillary electrophoresis. Our products enable customers to respond quickly to environmental hazards, advance biomarker research, improve patient care, accelerate drug development, and ensure food safety. At SCIEX, you’ll find a rewarding role that amplifies your impact on the world and helps you realize life’s potential. Learn about the Danaher Business System, which makes everything possible. The Lead Data Engineer is a senior individual contributor within a global IT team responsible for delivering complete, accurate, and trusted data from multiple source systems into the Azure Data Warehouse and modern analytics platforms. This role performs advanced, hands‑on data engineering work and provides technical leadership on complex initiatives, partnering closely with business stakeholders and IT peers to enable data‑driven decision‑making. This position is part of the Global IT organization supporting SCIEX, Molecular Devices, and the Life Sciences Platform. In this role, you will have the opportunity to:
- Partner with business stakeholders to design, build, and support modern data warehouse and analytics solutions that enable informed decision‑making
- Independently lead the hands‑on development of complex data integrations using ETL/ELT technologies, migrating data from application systems and file sources into cloud data platforms
- Build, enhance, and support data pipelines and orchestration solutions using Azure Data Factory and Microsoft Fabric
- Design, develop, and optimize database objects including SQL views, stored procedures, tables, and indexes in Azure SQL Database and Snowflake
- Monitor, troubleshoot, and optimize data pipelines and data warehouse performance within production environments
- Provide advanced operational support and root‑cause analysis for data warehouse and analytics‑related issues
- Act as a technical point of escalation and provide guidance to other data engineers through design reviews, code reviews, and knowledge sharing
- Develop and support Power BI semantic models, datasets, and reports as required to support business reporting needs
- Maintain technical documentation, data models, development standards, and version control for data warehouse solutions
- Identify and implement continuous improvement opportunities across data architecture, ETL processes, performance, and development practices
- Research and evaluate emerging analytics and cloud data platform technologies to inform future improvements
Essential requirements of the job include:
- Minimal 6–8 years of experience designing, developing, and supporting enterprise data warehouse and analytics solutions
- Strong hands‑on experience building and maintaining ETL/ELT pipelines using Azure Data Factory and Microsoft Fabric
- Advanced experience with cloud data platforms such as Azure SQL Database and Snowflake, including complex SQL development and performance optimization
- Proven ability to monitor, troubleshoot, and optimize data pipelines and data warehouse solutions in production environments
- Working knowledge of Power BI data models and datasets, with experience supporting analytics platforms and business users
- Demonstrated ability to provide technical leadership on complex work while remaining a highly hands‑on individual contributor
It would be a plus if you also possess:
- Experience collaborating with offshore or distributed development teams
- Familiarity with data quality, governance, or security practices
Join our winning team today. Together, we’ll accelerate the real-life impact of tomorrow’s science and technology. We partner with customers across the globe to help them solve their most complex challenges, architecting solutions that bring the power of science to life. For more information, visit www.danaher.com.