Job Description

The Opportunity: Avantor is searching for a talented and passionate experienced ELT/snowflake and dbt developer to join our growing data team! In this role, you will play a critical role in leading the teams build and maintain efficient and scalable data pipelines using dbt. You will work closely with data engineers, analysts, and other stakeholders to ensure our data is transformed and delivered in a reliable and timely manner. About the Role: Design, develop, and maintain dbt models and transformations to create efficient data pipelines for analytics and reporting. Collaborate with data engineers to ensure seamless integration of dbt with our existing data infrastructure. Implement and enforce data quality checks and best practices within dbt to ensure data accuracy and consistency. Write and optimize complex SQL queries within dbt to transform raw data into meaningful insights. Document data models and transformation logic for clear understanding and maintainability. Stay up-to-date on the latest features and functionalities of dbt and advocate for continuous improvement. Participate in code reviews and lead other developers to maintain a high-quality codebase. Partner with business stakeholders to understand their data needs and translate them into actionable dbt models. This role will be a full-time position based out of our Pune/Coimbatore office. If you are passionate about solving complex challenges and driving innovation lets talk! Our organization is an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. Our Team: The AVANTOR data team partners with AVANTOR leadership teams to drive data-driven decision making. We enable leadership by providing timely, accurate, and actionable insights through efficient data pipelines. What We're Looking For: Education : Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience). Experience: 10+ years of experience developing data pipelines with experience in SQL (preferably Snowflake). 3+ years of experience working with dbt. Qualifications: Strong understanding of data warehousing concepts (dimensional modeling, data transformation). Familiarity with cloud data platforms (AWS Redshift, Google BigQuery, Snowflake). Experience with version control systems (Git). Excellent problem-solving and analytical skills. Effective communication and collaboration skills. Strong attention to detail and a commitment to high-quality code. Preferred Qualifications: Experience with CI/CD pipelines for dbt. Experience with data testing frameworks like Great Expectations or dbt-expectations. Experience with cloud-based data platforms, particularly Snowflake. Experience working in an Agile development environment. How to thrive and create an impact: Data Transformation Expertise: Design and develop robust dbt models to transform raw data into valuable insights for analytics and reporting. Collaboration and Communication: Work closely with data engineers, analysts, and business stakeholders to understand data needs and translate them into technical solutions. Continuous Learning: Stay up-to-date on the latest trends and innovations in dbt and data transformation methodologies. Code Quality Champion: Advocate for best practices and write clean, maintainable, and well-documented dbt code. Problem-Solving Prowess: Analyze data transformation challenges and develop creative solutions using dbt.