Key Responsibilities:
- Lead the design, development, and optimization of ETL workflows using Informatica PowerCenter and IICS
- Architect high-performance, scalable solutions on Snowflake Data Warehouse
- Design robust data models with strong understanding of facts and dimensions
- Act as a strategic advisor to business stakeholders, using data to drive insights and business outcomes
- Partner with line-of-business leaders to identify and prioritize opportunities where data engineering can deliver measurable value
- Lead a team of data engineers through complex integration efforts with a problem-solving attitude
- Translate unstructured problems into structured, scalable data solutions
- Deliver high-quality business presentations and solution documentation tailored to technical and executive audiences
- Ensure alignment between technical delivery and business value realization
- Optimize performance through effective data modeling, partitioning, and indexing.
- Lead data migration and integration projects to move legacy data systems to Snowflake.
- Collaborate with business analysts, data engineers, and stakeholders to define requirements and deliver data solutions.
Required Skills & Qualifications:
- 8+ years of experience in data engineering and ETL, with hands-on expertise in Informatica (PowerCenter and IICS)
- Advanced SQL skills and experience with performance tuning
- Proven experience designing and optimizing solutions in Snowflake
- Strong foundation in data warehouse design, with a focus on dimensional modeling
- Prior experience in pharma domain with exposure to IQVIA, Komodo, and VEEVA datasets – strongly preferred
- Exceptional communication and stakeholder engagement skills
- Demonstrated consultative mindset, capable of influencing and leading cross-functional discussions on data-driven value generation
- Experience writing business process and technical documentation
- Strong project management, organization, and team leadership skills
- Ability to work in fast-paced environments with ambiguity and shifting priorities