Description
As the DBT Architect/Lead Analytics Engineer, you will be 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.
Requirements
- 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.
- Architect a robust testing framework (dbt-expectations/custom macros) to ensure attribute-level parity between Legacy and target systems.
- Establish CI/CD deployment pipelines, code review standards, and environment separation to ensure zero-defect releases.
- Serve as the program’s dbt SME, mentoring the engineering team on advanced modelling and Jinja templating.
Job responsibilities
- 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.
#LI-LW1
What we offer
Why work at GlobalLogic
Our goal is to build an inclusive positive culture where everyone can feel comfortable being themselves, empowering our people to create their own high standards and therefore more value. We work together to promote fairness while recognising, valuing and embracing differences – providing a transparent support structure and generous training budget to help our people develop skills to progress their career. Our region also supports a hybrid model which can flex across a wide spectrum of working options determined by our business, customer and individual needs.
You’ll benefit from a comprehensive health and wellness plan, private healthcare (clinical and mental wellbeing), and discounted gym memberships. We offer a fantastic benefits package including a competitive pension scheme and recognition schemes through bonus/reward initiatives. Colleagues are entitled to an annual volunteering day – so you can take time to support a cause close to your heart. We also love to stay social at our trips to the zoo, quiz nights, sports events, theatre trips and much more.
We are an equal opportunities employer. It is our policy to promote an environment free from discrimination, harassment and victimisation.
About GlobalLogic
GlobalLogic, a Hitachi Group Company, is a trusted digital engineering partner to the world’s largest and most forward-thinking companies. Since 2000, we’ve been at the forefront of the digital revolution – helping create some of the most innovative and widely used digital products and experiences. Today we continue to collaborate with clients in transforming businesses and redefining industries through intelligent products, platforms, and services.
