Senior Data Engineer

Companybp

LocationUnited Kingdom

Posted At1/29/2026

UK Visa Sponsorship Analytics

Occupation Type

IT business analysts, architects and systems designers

Occupation Code Skill LevelHigher Skilled

Sponsorship Salary Threshold

£54,900 (£28.15 per hour)

Occupation rate applies

Above analytics are generated algorithmically based on job titles and may not always be the same as the company's job classification. You can also check detailed occupation eligibility, and salary criteria on our UK Visa Eligible Occupations & Salary Thresholds page.

Disclaimer: Hunt UK Visa Sponsors aggregates job listings from publicly available sources, such as search engines, to assist with your job hunting. We do not claim affiliation with bp. For the most up-to-date job details, please visit the official website by clicking "Apply Now."

Description

Job Title: CDI Senior Analytics Engineer

Job Location: Remote (UK)

Contract Length: 3 Months Contract

Industry: Oil and Energy, Tech

Working Hours: 8 hours per day/ 40 per week

Role Overview:

We are looking for a hands-on engineering heavy-hitter to join our Customer Data & Intelligence (CDI) function immediately. We have a rich dataset covering multiple global markets, but our legacy codebase (monolithic SQL and Python scripts) is fragile.

Your immediate mission is to triage, refactor, and stabilize our critical data pipelines. You will take "God Queries" and break them down into modular, testable, and performant dbt models.

Immediate Deliverables (First 30-60 Days):

The "Code Rescue": Audit and patch critical queries currently causing data corruptions. Fix logic errors.
Modularization Pilot: Implement dbt (Data Build Tool) within our AWS/Databricks environment. Migrate the most critical reporting tables from stored procedures/scripts into dbt models.

Automated Quality Gates: Deploy automated tests (using dbt tests or Great Expectations) to check for identity uniqueness and any data errors on critical columns. Stop bad data before it hits the dashboard.

What you will do:

Refactoring: Rewrite inefficient legacy SQL to improve performance and readability.
Pipeline Repair: Fix error handling in existing AWS Glue/PySpark jobs .
Standardization: Establish the "Gold Standard" for what good code looks like. Create the Pull Request template and SQL linting rules that the rest of the team must follow.
Mentorship: Act as the "Bar Raiser" in code reviews, establishing standards and teaching the existing team how to write modular, defensive code.

What you will have:

Expert SQL: You can read a multi thousand-line spaghetti query, understand the intent, and rewrite it into 5 clean, modular steps without losing logic.
dbt (Data Build Tool): Proven experience setting up dbt from scratch. You know how to structure a project (Staging -> Intermediate -> Marts).

Python & Spark: Ability to read and fix PySpark syntax errors and optimize Spark execution plans (Databricks/AWS Glue).

AWS Ecosystem: Comfortable with S3, Athena, and IAM permissions.

CI/CD: Experience setting up and running tests automatically on commit.

Why You?:

You hate "Toil." You refuse to check data manually; you write scripts to check it for you.
You are not afraid of legacy codes. You see a messy codebase as a puzzle to be solved, not a reason to run away.
You care about Truth. You understand that "mostly correct" data is useless to a business.

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, colour, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status.