Job
Description
We are seeking an experienced ETL Architect to design, develop, and optimize data extraction, transformation, and loading (ETL) solutions and to work closely with multi-disciplinary and multi-cultural teams to build structured, high-quality data solutions. The person may be leading technical squads. These solutions will be leveraged across Enterprise , Pharma and Diagnostics solutions to help our teams fulfill our mission: to do now what patients need next. This role requires deep expertise in Python, AWS Cloud, and ETL tools to build and maintain scalable data pipelines and architectures. The ETL Architect will work closely with cross-functional teams to ensure efficient data integration, storage, and accessibility for business intelligence and analytics. Key Responsibilities ETL Design Development: Architect and implement high-performance ETL pipelines using AWS cloud services, Snowflake, and ETL tools such as Talend, Dbt, Informatica, ADF etc Data Architecture: Design and implement scalable, efficient, and cloud-native data architectures. Data Integration Flow: Ensure seamless data integration across multiple source systems, leveraging AWS Glue, Snowflake, and other ETL tools. Performance Optimization: Monitor and tune ETL processes for performance, scalability, and cost-effectiveness. Governance Security: Establish and enforce data quality, governance, and security standards for ETL processes. Collaboration: Work with data engineers, analysts, and business stakeholders to define data requirements and ensure effective solutions. Documentation Best Practices: Maintain comprehensive documentation and promote best practices for ETL development and data transformation. Troubleshooting Support: Diagnose and resolve performance issues, failures, and bottlenecks in ETL processes. Required Qualifications Education : Bachelors or masters degree in Computer Science, Information Technology, Data Engineering, or related field. Experience : 6+ years of experience in ETL development, with 3+ years in an ETL architecture role . Expertise in Snowflake or any MPP data warehouse (including Snowflake data modeling, optimization, and security best practices). Strong experience with AWS Cloud services, especially AWS Glue, AWS Lambda, S3, Redshift, and IAM or Azure/GCP cloud services. Proficiency in ETL tools such as Informatica, Talend, Apache NiFi, SSIS, or DataStage . Strong SQL skills and experience with relational and NoSQL databases. Experience in API integrations Proficiency in scripting languages ( Python, Shell, PowerShell ) for automation. Prior experience in Pharmaceutical or Diagnostics or healthcare domain is a plus. Soft Skills Strong analytical and problem-solving abilities. Excellent communication and documentation skills. Ability to work collaboratively in a fast-paced, cloud-first environment . Preferred Qualifications Certifications in AWS, Snowflake, or ETL tools . Experience in real-time data streaming, microservices-based architectures, and DevOps for data pipelines . Knowledge of data governance, compliance (GDPR, HIPAA), and security best practices .
