Data Engineer (AWS, DBT, Trino/Databricks)

We are looking for an experiencedData Engineerto support the migration and integration of data from multiple enterprise and laboratory systems. The project is primarily focused ondbt, advanced SQL, and data modellingrather than Databricks or large-scale PySpark processing.

The successful candidate will design new data models, develop complex transformations, and consolidate data from several source databases into a unified AWS-based data platform.

• Design logical and physicaldata modelsbased on technical and business requirements.
• Develop, test, and maintain complex data transformations usingdbt and SQL.
• Migrate and consolidate data from multiple databases and source systems.
• UseTrino/Prestoto query, join, and transform data distributed across different sources.
• Integrate data from enterprise and laboratory systems such asSAP, GLIMS, and Veeva.
• Build reusable, maintainable, and well-documented transformation models.
• Validate migrated data and investigate data-quality or consistency issues.
• Optimize complex SQL queries and transformation processes.
• Support data lineage, traceability, integrity, and documentation.
• Work with data stored or processed within AWS, particularlyAmazon S3 and Athena.
• Participate in Agile delivery, code reviews, testing, and CI/CD activities.
• Collaborate with data architects, analysts, engineers, and pharmaceutical business stakeholders.
• Develop new solutions rather than only maintaining existing pipelines.

• Strong hands-on experience withdbt.
• Advanced proficiency inSQL, including:
  • Complex joins and transformations
  • CTEs and window functions
  • Query optimization
  • Data reconciliation and validation
• Practical experience withdata modelling, including the ability to design a model from business or technical requirements.
• Experience migrating and consolidating data from multiple databases.
• Experience with distributed query engines such as:
  • Trino
  • Presto
• Working knowledge of AWS data services, particularly:
  • Amazon S3
  • Amazon Athena
  • AWS Glue
• Experience building reliable, production-ready data transformation pipelines.
• Understanding of relational databases and data warehousing concepts.

• Python, Scala, or PySpark for scripting, automation, or supplementary data transformation.
• Experience withPostgreSQLor another relational target database.
• Familiarity with Git and CI/CD deployment pipelines.
• Experience working in an Agile delivery environment.
• Knowledge of data quality, lineage, governance, and integrity principles.

Experience integrating data from any of the following is valuable:

• SAP ERP
• GLIMS or other LIMS platforms
• Veeva
• Pharmaceutical manufacturing or laboratory systems

Experience withGxP regulations and pharmaceutical data-integrity requirementsis preferred but not necessarily essential.

Candidates should meet one of the following:

• Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related discipline, with at least4 years of relevant technical experience; or
• At least8 years of equivalent experiencein data engineering, data modelling, data integration, or cloud analytics without a degree.

The ideal candidate is a SQL-focused Data Engineer with strong practical experience indbt and data modelling. They should be comfortable combining data from several databases, designing new data structures, and implementing complex transformations with Trino/Presto in an AWS environment.

• Location:European Union
• Contract Type:Freelance / Contract
• Start date:Summer, 2026
• Time Allocation:40 hours/week
• Global Pharmaceutical Company in Prague​

Originally posted on Himalayas