ETL Lead architecting data integration solutions with deep experience in data warehousing for pharmaceutical companies. Collaborating with stakeholders to drive insights and optimize ETL workflows.
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.
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
Platform Architect responsible for performance analysis of Cloud Gaming Hardware for NVIDIA's GeForce NOW. Engaging with design reviews and improving gaming performance across software stacks.
Global Enterprise Cybersecurity Architect managing security architecture strategies at Fiserv. Leading security design implementation across various environments including cloud and on - premises.
Senior Hardware Architect defining the architecture for Tegra System - on - Chips at NVIDIA. Leading diagnostics development for hardware failures in datacenters and autonomous vehicles.
Project Designer working on diverse projects with strong emphasis on design and detail at an award - winning architecture studio. Collaborating on core creative processes and delivering holistic design solutions.
Chief EO/IR Architect overseeing all phases of system development for EO/IR systems at CACI. Leading technical direction and project teams in various engineering disciplines.
Senior netarchitect at Alliander managing customer integration on electricity networks and addressing congestion issues. Focusing on scalable solutions and stakeholder collaboration in the energy sector.
Director of Licensing and Contracting at GE HealthCare responsible for licensing and contract standards in software solutions. Driving collaboration with product, legal, and finance teams for efficient commercial outcomes.
CPU Power Management Architect at Intel Corporation shaping CPU designs for high - performance computing. Driving end - to - end CPU power management architecture specifications and collaborating across teams.
Lead Architect overseeing strategy and technical direction of security technologies across network, server, and cloud environments. Mentor Cyber Engineers and collaborate on security architecture across platforms.