At a Glance
- Tasks: Lead the migration to a modern AWS Lakehouse architecture and design scalable dbt projects.
- Company: GlobalLogic, a forward-thinking digital engineering partner with a collaborative culture.
- Benefits: Competitive salary, remote work options, and opportunities for professional growth.
- Other info: Join a dynamic team and mentor others while shaping the future of data engineering.
- 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 70000 - 90000 £ per year.
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.
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.
- 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.
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 have 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.
DBT Architect/Lead Analytics Engineer in Westminster employer: GlobalLogic Inc.
GlobalLogic is an exceptional employer that fosters a culture of innovation and collaboration, making it an ideal place for professionals looking to make a significant impact in the field of data engineering. With a strong focus on employee growth, we offer extensive training opportunities and mentorship from industry experts, ensuring that our team members are equipped to lead transformative projects like the migration to a modern AWS Lakehouse architecture. Located in a dynamic environment, we provide a supportive atmosphere that values creativity and encourages the development of cutting-edge solutions.
StudySmarter Expert Advice🤫
We think this is how you could land DBT Architect/Lead Analytics Engineer in Westminster
✨Tip Number 1
Network like a pro! Reach out to folks in your industry on LinkedIn or at meetups. We all know that sometimes it’s not just what you know, but who you know that can get you in the door.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your dbt projects and any cool data transformations you've done. We love seeing real examples of your work, so make sure to highlight your best stuff!
✨Tip Number 3
Prepare for those interviews! Brush up on your technical skills and be ready to discuss your experience with AWS, Databricks, and dbt. We want to see how you think and solve problems, so practice explaining your thought process.
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we’re always on the lookout for passionate candidates who are eager to join our team.
We think you need these skills to ace DBT Architect/Lead Analytics Engineer in Westminster
Some tips for your application 🫡
Tailor Your CV:Make sure your CV speaks directly to the job description. Highlight your experience with dbt, Databricks, and any relevant projects that showcase your skills in migrating from legacy systems. We want to see how you can bring value to our team!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're the perfect fit for the DBT Architect role. Share specific examples of your past work, especially around complex SQL and cloud migrations. Let us know what excites you about this opportunity!
Showcase Your Technical Skills:Don’t hold back on your technical prowess! Be sure to mention your expertise in Jinja, macro development, and CI/CD practices. We’re looking for someone who can hit the ground running, so make those skills pop in your application.
Apply Through Our Website:We encourage you to apply through our website for a smoother process. It helps us keep track of your application and ensures you don’t miss out on any important updates. Plus, it’s super easy—just a few clicks and you’re done!
How to prepare for a job interview at GlobalLogic Inc.
✨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 these will be crucial for the role. Being able to discuss your past experiences with dbt confidently will show that you’re the right fit.
✨Showcase Your SQL Skills
Prepare to demonstrate your ability to reverse-engineer Legacy Teradata/BTEQ scripts and write optimised SQL for Databricks. Have examples ready that highlight your problem-solving skills and how you’ve tackled complex SQL challenges in previous projects.
✨Familiarise Yourself with AWS and Databricks
Since the role involves migrating to an AWS Lakehouse architecture, it’s essential to understand how Databricks works, particularly with Unity Catalog and SparkSQL. Be ready to discuss how you’ve used these technologies in past projects and how they can benefit the migration process.
✨Emphasise CI/CD and IaC Knowledge
Highlight your experience with CI/CD for data and Infrastructure as Code principles. Discuss any hands-on experience you have with Apache Airflow or Astronomer, as this will be key in managing complex dependency trees. Showing that you can establish robust deployment pipelines will set you apart.
