Job Summary

Avantor is looking for a dynamic, forward-thinking, and experienced Senior Data Engineer , delivering results against some of the most complex business and technology initiatives.

This role will be a full time position based out of our Pune or Coimbatore office.

If you are passionate about solving complex challenges and driving innovation - lets talk!

Our organization is an Equal Opportunity EmployerWe celebrate diversity and are committed to creating an inclusive environment for all employees.

Role Overview The Senior Data Engineer drives data-driven strategies and delivers impactful insights to optimize data platforms, analytics enablement, and business decision-makingThis role requires strong engineering depth across modern ELT tooling, analytical expertise, strategic thinking, and the ability to mentor and lead within a cross-functional team.

What We're Looking For

Certifications

Preferred SnowPro Core and/or SnowPro Advanced certificationsdbt Certification (Analytics Engineer) is a plus.

Experience

- 10-12 years of overall experience in IT, with a strong focus on data engineering and cloud data platforms.
- 6+ years of architecture or engineering experience in data modeling, building data pipelines, ELT/ETL frameworks, data products, and distributed data systems.
- 6+ years of experience within Data Warehousing management (star schemas, snowflake schemas, dimensional modeling) within Snowflake .
- 4+ years of hands-on experience with dbt (data build tool) - building and maintaining modular transformation layers, testing frameworks, macros, and documentation (dbt docs/lineage).
- 3+ years of hands-on experience with Fivetran (or similar managed ELT/connector tools) for automated data ingestion from SaaS, ERP, and database sources.
- 3+ years of experience enabling or supporting BI/reporting layers using Power BI - including semantic modeling, DAX, and performance optimization of datasets feeding dashboards.
- Exposure to or working knowledge of Generative AI concepts and tools (LLM-based data documentation/cataloging, natural-language-to-SQL tools, AI-assisted data quality or anomaly detection, Copilot-style dev tooling) - hands-on production experience is a plus, not mandatory.

Nice to have

- 5+ years of experience with Python for data engineering (scripting, automation,



orchestration).
- Experience with PySpark for large-scale data processing.
- Experience processing semi-structured data (JSON, Parquet, Avro).
- Exposure to orchestration tools (Airflow, Dagster, or Snowflake Tasks/Streams).
- Familiarity with using LLMs/GenAI APIs (OpenAI, Azure OpenAI, AWS Bedrock) to accelerate data engineering workflows - e.g., auto-generating dbt documentation, AI-assisted SQL/data quality checks, or building lightweight natural-language query interfaces over Snowflake. Those Necessary to Perform the Job Competently

- Thorough knowledge of Snowflake architecture (virtual warehouses, micro-partitioning, clustering, cost/performance optimization).
- Strong hands-on experience building and maintaining dbt projects - models, tests, snapshots, incremental strategies, and CI/CD integration for dbt deployments.

- Strong hands-on experience configuring and managing Fivetran connectors, sync schedules, transformations, and troubleshooting ingestion failures.
- Expertise in designing data models (dimensional modeling, star/snowflake schemas) for both operational reporting and self-service analytics.

- Should have worked on preparation of Technical Specification documents and data pipeline design documentation.
- Working knowledge of SAP systems as a source system (SAP ECC/S4HANA extraction patterns), integrated via Fivetran or custom pipelines into Snowflake.

- Experience enabling Power BI consumption layers - building/optimizing Snowflake views or dbt marts specifically for BI performance.
- Very good analytical skills to independently analyze and resolve ELT, SQL, and pipeline issues.

- Ability to provide effort estimation for data engineering initiatives.
- Ability to engage directly with business stakeholders, gather requirements, and work independently to translate them into scalable pipeline/data model designs.





- Advanced knowledge of data warehousing concepts and schema design trade-offs.
- Curiosity and practical interest in applying GenAI/LLM capabilities to modernize data engineering workflows (e.g., automated documentation, natural-language interfaces, intelligent data quality monitoring).

- SAP functional knowledge is good to have.

Preferred Qualifications

Bachelors degree in Engineering (Computer Science or other equivalent majors). How You Will Thrive and Create an Impact

- Collaborate with the Analytics and BI teams to prototype and prove the viability of new data solutions, including GenAI-assisted approaches where applicable.
- Own the end-to-end data pipeline lifecycle ingestion (Fivetran) transformation (dbt) storage/modeling (Snowflake) consumption (Power BI).
- Lead development and execution of data engineering initiatives across specific projects, mentoring junior engineers on best practices.
- Be hands-on in Snowflake development, dbt model design, and Fivetran pipeline configuration/administration.
- Explore and pilot GenAI use cases that improve data engineering productivity - e.g., AI-assisted documentation, automated test generation, or natural-language querying over the Snowflake warehouse.
- Ability to work independently with minimal supervision while collaborating cross-functionally with product owners, business stakeholders, and management.
- Provide technical leadership in the development of engineering standards (dbt style guides, naming conventions, testing coverage expectations).
- Comfortable with rapid prototyping and disciplined software development practices (version control, CI/CD, code review for dbt/SQL).
- Perform other duties as assigned. Disclaimer

The above statements are intended to describe the general nature and level of work being performed by employees assigned to this classificationThey are not intended to be construed as an exhaustive list of all responsibilities, duties and skills required of employees assigned to this positionAvantor is proud to be an equal opportunity employer. Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.

📌 Sr. Data Engineer (Pune)
🏢 VWR International
📍 Pune