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
SAP Functional Architect designing solutions for Nutrien's agriculture business. Overseeing SAP implementation to meet specific project requirements in Acquire to Retire process domain.
Architecte Applicatif piloting application strategy for a key banking client in the finance sector. Collaborating on technology innovations and architecture design to meet business needs.
Principal Applications Architect at Good Sam shaping technology landscape and driving strategic initiatives. Leading the architecture, design, and implementation of scalable solutions.
Software Architect responsible for software solutions and enterprise architectures at Assecor. Collaborating with teams and stakeholders for technical quality.
Oracle Cloud HCM Solution Architect designing and implementing Oracle Cloud HCM solutions for clients. Collaborating with stakeholders to align solutions with business objectives in HR.
Architect responsible for architectural design and project coordination at BC2 Architecture. Engaging with clients and multidisciplinary teams to ensure project quality and adherence to standards.
Lead Data Analyst & Architecture professional overseeing enterprise - scale data environments for federal health and defense missions. Ensuring compliance and security in data governance and architecture.
Landscape Architect responsible for project design and coordination under senior supervision at AtkinsRéalis. Engaging in Landscape and Urban Design projects across Property, Infrastructure & Transportation sectors globally.
Architect working on execution planning for various large - scale projects in Münster, Germany. Collaboration with a dynamic team to enhance architectural designs and meet regulatory standards.
Architect and Project Manager responsible for leading complex projects in Germany. Engaging with diverse tasks from concept design to project execution in a collaborative environment.