You will lead the design, development, and optimization of ETL workflows.
Responsibilities
Lead the design, development, and optimization of ETL workflows using Informatica PowerCenter and IICS to build scalable solutions on Snowflake Data Warehouse.
Design robust data models, focusing on facts and dimensions, and optimize performance via modeling, partitioning, and indexing.
Act as a strategic advisor to stakeholders, translating unstructured problems into structured, scalable data solutions to drive business outcomes.
Lead data migration and integration projects, moving legacy data systems into Snowflake.
Collaborate with business analysts and stakeholders to define requirements and deliver high-quality data solutions and documentation.
Required Skills
8+ years of experience in data engineering and ETL.
Expertise with Informatica (PowerCenter and IICS).
Advanced SQL skills with proven experience in performance tuning.
Strong experience designing and optimizing solutions in Snowflake.
Deep understanding of data warehouse design, specifically dimensional modeling.
Proven experience in the pharma domain, ideally with IQVIA, Komodo, and VEEVA datasets.
Demonstrated consultative mindset capable of influencing cross-functional discussions.
Strong project management and team leadership skills.
Ability to work effectively with ambiguity and shifting priorities.