Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead the migration to a modern AWS Lakehouse architecture and design dbt pipelines.
- Company: Join GlobalLogic, a caring and inclusive tech company focused on impactful engineering.
- Benefits: Enjoy a culture of learning, flexible work arrangements, and opportunities for career growth.
- Why this job: Make a real impact by transforming legacy systems into cutting-edge solutions.
- Qualifications: Expertise in dbt, Databricks, and SQL; strong mentoring and collaboration skills.
- Other info: Work in a high-trust environment that values integrity and personal balance.
The predicted salary is between 70000 - 90000 £ per year.
As the 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
- 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.
- 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 modeling and Jinja templating.
What we offer
- Culture of caring: At GlobalLogic, we prioritize a culture of caring. Across every region and department, at every level, we consistently put people first. From day one, you’ll experience an inclusive culture of acceptance and belonging, where you’ll have the chance to build meaningful connections with collaborative teammates, supportive managers, and compassionate leaders.
- Learning and development: We are committed to your continuous learning and development. You’ll learn and grow daily in an environment with many opportunities to try new things, sharpen your skills, and advance your career at GlobalLogic.
- Interesting & meaningful work: GlobalLogic is known for engineering impact for and with clients around the world. As part of our team, you’ll have the chance to work on projects that matter.
- Balance and flexibility: We believe in the importance of balance and flexibility. With many functional career areas, roles, and work arrangements, you can explore ways of achieving the perfect balance between your work and life.
- High‑trust organization: We are a high‑trust organization where integrity is key. By joining GlobalLogic, you’re placing your trust in a safe, reliable, and ethical global company.
Lead Analytics Engineer / dbt Architect IRC293456 employer: GlobalLogic
Contact Detail:
GlobalLogic Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Lead Analytics Engineer / dbt Architect IRC293456
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, attend meetups, and engage in online forums. The more people know you’re on the hunt for a Lead Analytics Engineer role, the better your chances of landing that dream job.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your dbt projects, SQL optimisations, and any cool data pipelines you've built. This will give potential employers a taste of what you can do and set you apart from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on your technical knowledge and soft skills. Be ready to discuss your experience with Databricks, Apache Airflow, and CI/CD practices. Practice common interview questions and have examples ready to demonstrate your expertise.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who are proactive about their job search. So, get those applications in and let’s get you on board!
We think you need these skills to ace Lead Analytics Engineer / dbt Architect IRC293456
Some tips for your application 🫡
Tailor Your Application: Make sure to customise your CV and cover letter to highlight your experience with dbt, Databricks, and AWS. We want to see how your skills align with the role of Lead Analytics Engineer, so don’t hold back on showcasing your relevant projects!
Show Off Your Technical Skills: Since this role is all about technical expertise, be sure to include specific examples of your work with SQL, Jinja, and Apache Airflow. We love seeing concrete achievements, so if you've optimised pipelines or led migrations, let us know!
Keep It Clear and Concise: While we appreciate detail, clarity is key! Make your application easy to read by using bullet points and clear headings. This helps us quickly spot your qualifications and understand your journey in analytics engineering.
Apply Through Our Website: We encourage you to apply directly through our website for a smoother process. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it shows you’re keen on joining our team!
How to prepare for a job interview at GlobalLogic
✨Know Your dbt Inside Out
Make sure you’re well-versed in dbt Core and Cloud, especially advanced Jinja and macro development. Brush up on incremental materialization strategies, as you'll need to demonstrate your expertise in transforming complex BTEQ scripts into efficient dbt models.
✨Showcase Your Databricks Skills
Be prepared to discuss your experience with Databricks, particularly Unity Catalog and SparkSQL. Have examples ready that highlight how you've optimised SQL for Databricks and how you’ve integrated it with other tools like Apache Airflow.
✨Demonstrate Your Problem-Solving Skills
Expect to tackle some real-world scenarios during the interview. Think about how you would approach reverse-engineering legacy Teradata/BTEQ scripts and converting them into modular dbt pipelines. Show your thought process and problem-solving skills.
✨Emphasise Collaboration and Mentorship
As a Lead Analytics Engineer, you’ll be mentoring others. Share your experiences of leading teams or projects, and how you’ve fostered collaboration. Highlight your understanding of CI/CD principles and how you’ve implemented them in past roles.