Data Engineer

Insight; City Of London; On-site; GBP 70,000 - 90,000; Full time

Job summary

A leading global consulting firm is seeking a Senior Data Engineer to design and maintain Azure-based data pipelines and APIs. Candidates should possess strong Python and SQL skills, along with experiences in dbt, Azure DevOps, and CI/CD best practices. The position is full-time onsite in London, requiring close collaboration with global teams and a proactive problem-solving approach to deliver data solutions.

Qualifications

• Strong experience in data engineering.
• Expertise in Azure (cloud platform).
• Strong coding skills in Python and SQL.
• Experience with dbt for data transformation.
• Familiarity with infrastructure as code.

Responsibilities

• Develop and maintain Azure-based data pipelines.
• Build and optimize ETL workflows using SQL and dbt.
• Write Python scripts for data transformation.
• Collaborate with global teams for data quality.

Skills

Python

SQL

Data engineering

Azure

dbt

Azure DevOps

CI/CD best practices

Data warehousing principles

Problem-solving

Tools

Snowflake

Airflow

Terraform

Job description

Insight Global's client is looking for a Senior Data Engineer to join their Finance and Operations team, responsible for designing and maintaining Azure-based data pipelines and APIs, building and optimizing ETL processes, managing large datasets, troubleshooting data issues, and documenting technical solutions. The ideal candidate will have strong coding skills in Python and SQL, experience with dbt, Azure DevOps, and CI/CD best practices, and a solid understanding of data warehousing principles. Success in this role requires excellent communication, a collaborative mindset, and proactive problem-solving to mitigate blockers and deliver scalable solutions. Candidates with experience in tools like Snowflake, Airflow, or Terraform, familiarity with infrastructure as code, and exposure to financial and operational data domains will stand out. This is a full-time onsite position in our London office, working closely with global teams to ensure data quality, automation, and continuous improvement. Please note, this is a 6 month contract-to-hire position and would require you to be on-site 5 days a week out of the London office.

Day to Day:

• Develop and maintain Azure-based data pipelines for Finance and Operations.
• Build and optimize ETL workflows using SQL and dbt.
• Write Python scripts for data transformation and automation.
• Deploy infrastructure as code and manage cloud data solutions.
• Collaborate with project managers and contractors across global teams.
• Ensure data quality and compliance with best practices.
• Troubleshoot and resolve data-related issues promptly.
• Document technical solutions and maintain test scripts.

Must Haves:

• Strong experience in data engineering.
• Expertise in Azure (cloud platform)
• SQL (advanced ETL and query optimization)
• dbt (data transformation pipelines)
• Python (data transformation and automation scripts)
• Azure DevOps / GitHub (CI/CD pipelines, source control)
• Data warehousing and ETL best practices
• Experience with similar tools or technologies (e.g., Snowflake, Airflow, Terraform)
• Familiarity with infrastructure as code
• Ability to participate in architectural decisions
• Strong problem-solving and continuous improvement mindset