At a Glance
- Tasks: Lead the migration to a modern AWS Lakehouse architecture and design scalable dbt projects.
- Company: Join a forward-thinking company at the forefront of cloud technology.
- Benefits: Competitive salary, flexible working options, and opportunities for professional growth.
- Other info: Dynamic team environment with a focus on cutting-edge technology.
- Why this job: Make a significant impact by transforming legacy systems into innovative solutions.
- Qualifications: Expertise in dbt, Databricks, and strong SQL skills required.
The predicted salary is between 60000 - 80000 £ per year.
As the primary technical authority for our enterprise cloud migration, you will lead the transition from a Legacy Teradata environment to a modern AWS Lakehouse architecture. Your mission is to design the foundational dbt architecture that replaces 500+ complex BTEQ scripts with modular, performant, and audit-ready pipelines supporting Risk, Finance, and Quants.
Technical Requirements
- Expert-level dbt Core/Cloud proficiency, including advanced Jinja, macro development, and incremental materialization strategies.
- Deep experience with Databricks (Unity Catalog, SparkSQL) and Apache Iceberg on AWS S3.
- Ability to reverse-engineer Legacy Teradata/BTEQ and write highly optimized SQL for Databricks.
- Hands-on experience with Apache Airflow (ideally Astronomer) for managing complex dependency trees.
- Strong mastery of Git workflows, CI/CD for data, and Infrastructure as Code (IaC) principles.
Job Responsibilities
- Design a scalable, DRY dbt project structure and materialization strategy tailored for a regulated enterprise migration.
- Lead the technical conversion of 500+ BTEQ scripts into dbt models, creating custom macros and automated translation patterns.
- Integrate dbt with Astronomer and OpenLineage to ensure end-to-end traceability for regulatory compliance.
DBT Architect/Lead Analytics Engineer employer: GlobalLogic UK&I
Join a forward-thinking company that prioritises innovation and employee development, offering a collaborative work culture where your expertise as a DBT Architect/Lead Analytics Engineer will be valued. With a focus on cloud migration and modern data architecture, you will have the opportunity to lead transformative projects while benefiting from continuous learning and growth opportunities in a dynamic environment. Located in a vibrant tech hub, our company provides a supportive atmosphere that encourages creativity and professional advancement.
