Data Engineer (Apache Airflow/Spark/AWS) - Full Remote Portugal

ABOUT THE OPPORTUNITY

Join a mission-driven health technology company operating at the intersection of real-world data and patient outcomes. This organization is building a global evidence network that enables healthcare organizations to access harmonized, privacy-preserving datasets — directly impacting how treatments are evaluated and improved for patients worldwide.

This is a fully remote, senior-level consulting engagement where data pipelines are not just infrastructure — they are the product. You'll work in a fast-paced, engineering-led environment alongside talented people who care deeply about the quality and impact of their work.

Language requirement: English B2 (Upper Intermediate) minimum — daily collaboration with international teams is expected.

PROJECT & CONTEXT

You will be part of a core data engineering team responsible for designing and operating the pipelines that ingest, transform, and standardize real-world health data. The work involves translating complex source data structures into recognized healthcare data standards (FHIR, OMOP-CDM), ensuring data quality, security, and scalability across the platform.

The tech stack includes: Apache Airflow, Apache Spark, AWS Redshift, Trino, ClickHouse, Dagster, and Airbyte, with heavy use of SQL and Python.

WHAT WE'RE LOOKING FOR (Required)

• Advanced SQL skills — complex transformations, performance optimization, data modeling
• Strong Python proficiency for pipeline development and automation
• Proven senior-level track record as a Data Engineer, with experience scaling data products from pilot to production
• Hands-on experience building and optimizing big data pipelines, architectures, and datasets using tools such as Apache Airflow and/or Apache Spark
• Experience with AWS technologies (Redshift, S3, or equivalent managed services)
• Strong analytical skills when working with unstructured and semi-structured datasets
• Solid understanding of data science and Big Data concepts
• Excellent written and verbal communication skills in English (B2+)
• Self-driven, ownership mentality, proactive approach to problem-solving

NICE TO HAVE (Preferred)

• Experience with health data frameworks: OMOP-CDM and/or FHIR
• Familiarity with additional stack components: Dagster, Trino, ClickHouse, Airbyte
• Experience with data quality assurance, writing test specifications and test case scenarios
• Background working in healthcare or life sciences data environments
• Experience in agile/continuous delivery engineering teams