Technical Lead Cloud Data Engineering- Snowflake/DBT 1
Merck Group.com
Office
Bangalore, Karnataka, IN, 560037
Full Time
Work Your Magic with us!
Ready to explore, break barriers, and discover more? We know you’ve got big plans – so do we! Our colleagues across the globe love innovating with science and technology to enrich people’s lives with our solutions in Healthcare, Life Science, and Electronics. Together, we dream big and are passionate about caring for our rich mix of people, customers, patients, and planet. That's why we are always looking for curious minds that see themselves imagining the unimaginable with us.
United As One for Patients, our purpose in Healthcare is to help create, improve and prolong lives. We develop medicines, intelligent devices and innovative technologies in therapeutic areas such as Oncology, Neurology and Fertility. Our teams work together across 6 continents with passion and relentless curiosity in order to help patients at every stage of life. Joining our Healthcare team is becoming part of a diverse, inclusive and flexible working culture, presenting great opportunities for personal development and career advancement across the globe.
Job Title: Technical Lead - Data Warehouse and Cloud Analytics
Your Role:
We are seeking a passionate Technical Lead to lead the end-to-end lifecycle of our cloud data products. In this pivotal role, you will utilize your expertise in Data Warehouse and Data Lake architecture to deliver innovative solutions that drive our analytics capabilities. As a Subject Matter Expert in Snowflake and DBT, you will guide the technical design and implementation of data flows, ensuring that they align with best practices and meet the needs of our stakeholders. You will design and implement advanced data modeling techniques, such as Data Vault 2.0, to create scalable solutions that enhance data interoperability. Your hands-on leadership will involve writing optimized SQL and leveraging Python for advanced data processing. You will also develop and maintain robust data pipelines, automate processes, and ensure data quality throughout the lifecycle. Collaboration with cross-functional teams will be key as you work to create scalable data solutions that support reporting, analytics, and AI initiatives. Additionally, you will mentor junior developers, fostering a culture of continuous learning and knowledge sharing. Join us in this exciting opportunity to make a significant impact on our data strategy!
Who You Are:
- Master’s degree in Computer Science, Information Technology, or a related field.
- 8+ years of experience as a Snowflake Developer and 10+ years in data modeling (OLAP, OLTP, Data Vault 2.0) and data warehousing.
- Extensive hands-on experience with complex SQL queries and advanced Python for data manipulation and analysis.
- Strong understanding of data warehousing concepts and methodologies.
- Experience building data pipelines using DBT for data transformation and running jobs.
- Familiarity with performance tuning techniques in Snowflake, including query optimization.
- Strong knowledge of CI/CD pipelines, preferably in Azure DevOps, and knowledge of Infrastructure as Code (IaC) tools like Terraform or CloudFormation is a plus.
- Excellent problem-solving, analytical, and communication skills.
What we offer: We are curious minds that come from a broad range of backgrounds, perspectives, and life experiences. We believe that this variety drives excellence and innovation, strengthening our ability to lead in science and technology. We are committed to creating access and opportunities for all to develop and grow at your own pace. Join us in building a culture of inclusion and belonging that impacts millions and empowers everyone to work their magic and champion human progress!
Apply now and become a part of a team that is dedicated to Sparking Discovery and Elevating Humanity!
