Senior Data Engineer -dbt

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 – let’s 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.

Join our team and help us build a foundation for data-driven decision making!

Disclaimer:
The above statements are intended to describe the general nature and level of work being performed by employees assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties and skills required of employees assigned to this position. Avantor is proud to be an equal opportunity employer.

Why Avantor?

Dare to go further in your career. Join our global team of 14,000+ associates whose passion for discovery and determination to overcome challenges relentlessly advances life-changing science.
 
The work we do changes people's lives for the better. It brings new patient treatments and therapies to market, giving a cancer survivor the chance to walk his daughter down the aisle. It enables medical devices that help a little boy hear his mom's voice for the first time. Outcomes such as these create unlimited opportunities for you to contribute your talents, learn new skills and grow your career at Avantor.
 
We are committed to helping you on this journey through our diverse, equitable and inclusive culture which includes learning experiences to support your career growth and success. At Avantor, dare to go further and see how the impact of your contributions set science in motion to create a better world. Apply today!

EEO Statement:

We are an Equal Employment/Affirmative Action employer and VEVRAA Federal Contractor. We do not discriminate in hiring on the basis of sex, gender identity, sexual orientation, race, color, religious creed, national origin, physical or mental disability, protected Veteran status, or any other characteristic protected by federal, state/province, or local law.

If you need a reasonable accommodation for any part of the employment process, please contact us by email at [email protected] and let us know the nature of your request and your contact information. Requests for accommodation will be considered on a case-by-case basis. Please note that only inquiries concerning a request for reasonable accommodation will be responded to from this email address.

3rd party non-solicitation policy:

By submitting candidates without having been formally assigned on and contracted for a specific job requisition by Avantor, or by failing to comply with the Avantor recruitment process, you forfeit any fee on the submitted candidates, regardless of your usual terms and conditions. Avantor works with a preferred supplier list and will take the initiative to engage with recruitment agencies based on its needs and will not be accepting any form of solicitation