The businesses of Merck KGaA, Darmstadt, Germany

Data Analyst

The businesses of Merck KGaA, Darmstadt, Germany Bangalore, Karnataka, India

Pharmaceutical Manufacturing · 10,001+ employees

3 d ago
data-analyst Senior (5-10 yrs) Full-time India
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

Develop and optimize Snowflake data pipelines, ETL processes, SQL queries, and DBT transformations, ensuring data quality, integrity, and compliance. Build and maintain Azure DevOps CI/CD workflows, tune performance, document data models and processes, and collaborate with architects, analysts, and stakeholders on scalable data solutions.

What they look for

Snowflake SQL Python DBT Azure DevOps CI/CD Data Modeling ETL Data Pipelines Performance Tuning Git Data Governance Data Security OLTP OLAP Data Vault 2.0

Requirements

Requires at least five years of experience as a Snowflake Developer or in a similar data engineering role, with strong hands-on SQL and Python skills and significant DBT experience. Candidates should understand data modeling, CI/CD, Snowflake performance tuning, and data governance; a bachelor's or master's degree in computer science, information technology, or a related field is specified.

Full description

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 unimageable with us.

 

Who you are:

  • Develop and maintain complex data pipelines and ETL processes in Snowflake.
  • Write efficient and optimized SQL queries for data extraction, transformation, and loading.
  • Utilize Python for advanced data processing, automation tasks, and integration with other systems.
  • Implement and oversee data modelling techniques, including OLTP, OLAP, and Data Vault 2.0 methodologies.
  • Collaborate with data architects, analysts, and stakeholders to design optimal and scalable data solutions.
  • Manage and optimize CI/CD pipelines using Azure DevOps for seamless deployment of data solutions.
  • Ensure data quality, integrity, and compliance throughout the data lifecycle.
  • Troubleshoot, optimize, and enhance existing data processes and queries for performance improvements.
  • Document data models, processes, and workflows clearly for future reference and knowledge sharing.
  • Performance Tuning: Implement advanced techniques for performance tuning methodologies in Snowflake to optimize query performance and reduce data processing time.
  • DBT Development: Develop and maintain DBT models, macros, and tests for managing data transformations in Snowflake.
  • Version Control Management: Manage version control using Git repositories, enabling seamless code management and collaboration.
  • CI/CD Pipeline Development & Automation: Design, implement, and maintain automated CI/CD pipelines using Azure DevOps for Snowflake and DBT deployment processes.
  • Impacts the effectiveness of own work team through the quality and timeliness of the work produced.
  • Largely works within standardized procedures and practices to achieve objectives and meet deadlines and gains some discretion in problem solving.
  • Bachelor's/master's degree in computer science, Information Technology, or a related field.

Your Role:

  • Minimum of 5 years of proven experience as a Snowflake Developer or in a similar data engineering role.
  • Extensive hands-on experience with SQL and Python, demonstrating proficiency in data manipulation and analysis.
  • Significant industry experience working with DBT (Data Build Tool) for data transformation.
  • Strong familiarity with CI/CD pipelines, preferably in Azure DevOps.
  • Deep understanding of data modelling techniques ( OLTP, OLAP ) and best practices.
  • Minimum of 5 years of proven experience as a Snowflake Developer or in a similar data engineering role.
  • Extensive hands-on experience with SQL and Python, demonstrating proficiency in data manipulation and analysis.
  • Significant industry experience working with DBT ( Data Build Tool ) for data transformation.
  • Strong familiarity with CI/CD pipelines, preferably in Azure DevOps.
  • Deep understanding of data modelling techniques (OLTP, OLAP, DBT) and best practices.
  • Experience in working with large datasets and performance tuning in Snowflake.
  • Familiarity with data governance, data security best practices, and compliance standards.
  • Knowledge of additional data technologies ( e.g., AWS, Azure ) is a plus.
  • Experience in leading projects or mentoring junior developers is advantageous.

What we offer: We are curious minds that come from a broad range of backgrounds, perspectives, and life experiences. We celebrate all dimensions of diversity and believe that it 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 our diverse team!

Similar roles