About the role

  • 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.

Requirements

  • 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 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

Job title

Architect

Job type

Experience level

SeniorLead

Salary

Not specified

Degree requirement

Bachelor's Degree

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job