ETL Delivery- Associate Director

Axtria; Pune District; On-site; INR 3,500,000 - 6,500,000; Full time

Job summary

Axtria in India is seeking a seasoned Cloud Data Management architect with 13+ years of experience to deliver enterprise data solutions. You will design data warehouses, data marts, and data integrations on Snowflake hosted on AWS or Azure, and guide client engagements across pharmaceutical data domains.

Responsibilities include requirements gathering, technical design, and leading delivery with a strong emphasis on data governance and modeling concepts.

Qualifications

• 13+ years of end-to-end experience delivering Cloud Data Management solutions in Life Sciences.
• Hands-on AWS, Snowflake, Redshift, and ETL tools such as Informatica/Matillion.
• Experience across Pharma Commercial data domains including Retail, Patient data, and Digital Marketing.

Responsibilities

• Design and deliver complex Data Warehousing, Data Mart, and Data Integration solutions on Snowflake on AWS or Azure.
• Lead requirements gathering from clients and project teams across pharmaceutical data domains.
• Architect and develop ETL/ELT pipelines on cloud platforms (AWS/Azure).
• Provide delivery leadership, manage risks, ensure quality, and coordinate with clients and onshore teams.
• Apply analytical thinking to assess data, troubleshoot, and resolve issues; communicate clearly with stakeholders.
• Understand Axtria's product and service portfolio to align Cloud Data Management solutions for Life Sciences.

Skills

AWS Cloud services

Snowflake

Redshift

Python

Data governance

Data modeling

Enterprise data management

Data warehousing

Cloud data management

Tools

Informatica

Matillion

IICS

DBT

Job description

Job Description:

Candidate should have 13+ years of prior experience in delivering customer focused Cloud Data Management solution(s): Enterprise Data Warehouse, Enterprise Data Lake, Master Data Management System, Business Intelligence & Reporting solutions, IT Architecture Consulting, Cloud Platforms ( AWS/AZURE), SaaS/PaaS based solutions in the Life Science industry.

Candidate must have prior hands-on working experience in technologies such as AWS Cloud services, Snowflake, Redshift, ETL tools like Informatica/Matillion, Python with strong fundamentals in Enterprise Data Management, Data Warehousing, Data Governance and Data Modelling concepts.

Should have prior experience in driving Cloud Data Management solutions across Pharma Commercial data domains like Retail and Non-Retail Sales, Patient data, Digital Marketing Data.

Must have a very good understanding of end-to-end pharma commercial landscape covering both enterprise and syndicated data sets.

Responsibilities:

• Technology: Independently design, implement, and deliver complex Data Warehousing, Data Mart, and Data Integration solutions on Snowflake, hosted on either AWS or Azure.


• Requirements Gathering: Effectively understand and interpret requirements directly from clients or from project teams, particularly across pharmaceutical commercial data domains.


• Technical Design & Development: Architect and develop simple to highly complex ETL/ELT pipelines on AWS or Azure cloud platforms.


• Delivery Leadership: Oversee day-to-day delivery of major engagements, providing hands-on technical leadership to the team. Manage risks, ensure quality, and coordinate closely with clients and onshore counterparts.


• Analytical Thinking: Apply strong analytical and logical reasoning to assess data, troubleshoot issues, and evaluate complex situations.


• Client Relationship Management: Independently or collaboratively manage client communications and expectations. Ensure timely delivery of planned outcomes and demonstrate excellent communication skills.


• Business Development: Understand Axtrias broader product and service portfolio to align solutions that best support client needs. Contribute to large cloud data management opportunities within the Life Sciences domain.


• Communication: Clearly and accurately articulate ideas and information in both written and verbal formats.

Desirable Qualities:

• Technical Expertise:
  Proven hands-on experience with AWS cloud services, Snowflake, Redshift, and ETL tools such as IICS or DBT. Strong proficiency in Python and solid fundamentals in Enterprise Data Management, Data Warehousing, Data Governance, and Data Modeling.


• Domain Knowledge:
  Prior experience implementing Cloud Data Management solutions within pharmaceutical commercial data domains, including Retail and Non-Retail Sales, Patient Data, and Digital Marketing Data.


• Industry Understanding:
  Deep understanding of the end-to-end pharma commercial ecosystem, spanning both enterprise datasets and syndicated data sources.


• Results-Driven:
  Highly self-motivated with the ability to take initiative, set priorities effectively, and pursue tasks with determination and a strong sense of ownership.


• Customer Focus:
  Committed to meeting and exceeding expectations of both internal and external stakeholders.


• Strong Problem-Solving Skills:
  Able to apply structured thinking, rigorous logic, and analytical methods to develop effective solutions for complex challenges.


• Continuous Learner:
  Learns quickly when confronted with new problems and demonstrates versatility and persistence in acquiring new knowledge and skills.