PUNE · FULLTIME
Sr. Data Engineer
Avantor
Pune · onsite · Posted 13d ago
Sourced from
Undisclosed10–12 yrsfulltimePune
Your match
?
Sign in to see your match score, skill gaps & tailored resume.
Section · 01
About this role
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.
Job Description The Senior Data Engineer drives data-driven strategies and delivers impactful insights to optimize data platforms, analytics enablement, and business decision-making. This 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 certifications. dbt Certification (Analytics Engineer) is a plus.
- 1012 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.
- 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.
- 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.
- Bachelor's degree in Engineering (Computer Science or other equivalent majors).
- 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.
Sourced from naukri
Let the agent run this one for you.
Tailored resume, auto-apply, and referral lookup — in under 2 minutes.
Section · 02
Skills
AutomationBedrockCode Reviewanalytical thinkingapisaws bedrockclusteringamazon web servicesapache airflowclassificationCancerAzure OpenAIAnalyticsAnomaly DetectionCI/CD IntegrationCloud DatacloudArchitectureAdministrationMicrosoft AzureArtificial Intelligence
Section · Company
About Avantor
Avantor
Pharma
2.0k+
employees
1904
122 years old
Radnor Township, Pennsylvania
United States
About
Avantor is a leading global provider of mission-critical products and services to customers in biopharma, healthcare, education & government, and advanced technologies & applied materials.
Industries
PharmaChemicals / Agri InputsHealthcare
Employee ratings
342 reviews
3.7/ 5
Culture
3.5
Career growth
2.9
Work-life
3.8
Employees rate it well for
Work Culture38Salary33Work Life Balance30Senior Management29Job Security22
Find them on