Energy Analytics Engineer

Jobtailor; Greater London; On-site; GBP 60,000 - 90,000; Full time

Job summary

Jobtailor is seeking a data engineer to build and maintain end-to-end data pipelines in Azure, connecting to APIs, and delivering curated datasets for BI and reporting.

You will work across departments with finance, operations and tech teams to ensure data integrity, automate analytics, and support carbon reporting.

Qualifications

• Bachelor's degree in computer science, data engineering, or a related field.
• Proven experience in data engineering and analytics.
• Expertise in Power BI, dbt, Databricks, and Azure.
• Proficiency in SQL, Python, and data manipulation libraries and frameworks.
• Strong problem-solving skills and analytical thinking.

Responsibilities

• Build, test and implement solutions for new data acquisition and end-to-end departmental data processes.
• Connect to third-party APIs using Python and return complex data from multiple endpoints.
• Implement processes to retain and refresh data within business systems.
• Generate curated datasets from raw input tables using ETL tools.
• Document dataset lineage and implement integrated testing.
• Support development and operation of databases for invoice validation, cost reconciliation and supplier portfolio management.

Skills

Power BI

dbt

Databricks

Azure

SQL

Python

Analytics

Education

Bachelor's degree in computer science or data engineering

Tools

Azure Databricks

Job description

• Build, test and implement solutions for new data acquisition and end-to-end departmental data processes
• Connect to third-party APIs using Python and return complex data from multiple endpoints
• Implement processes to retain and refresh data within business systems
• Generate curated datasets from raw input tables using preferred ETL tools
• Document dataset lineage and implement integrated testing
• Support development and operation of databases for invoice validation, cost reconciliation and supplier portfolio management
• Design, develop and maintain robust, scalable data pipelines using Azure Data Factory, Azure Databricks and other relevant tools
• Automate routine analysis and deliver business intelligence reporting
• Support migration of complex report models into materialized tables within the data platform
• Create, calculate and distribute information and reports to stakeholders
• Maintain database and third-party software governance procedures and controls
• Collaborate with front, middle and back office, DSR, Operations, Finance and senior management
• Work with internal and external customers to understand requirements and identify suitable solutions
• Build proof of concepts to demonstrate solutions
• Troubleshoot and resolve data-related issues
• Train and support non-technical users using analytics tools
• Support ecological transformation initiatives and carbon reporting for internal and external customers
• Comply with health and safety policies and procedures

Requirements

• Bachelor's degree in computer science, data engineering, or a related field
• Proven experience in data engineering and analytics
• Expertise in Power BI, dbt, Databricks, and Azure
• Proficiency in SQL, Python, and data manipulation libraries and frameworks
• Strong problem-solving skills and analytical thinking
• Excellent communication skills and ability to collaborate with technical and non-technical stakeholders
• Knowledge of cloud platforms such as Azure and big data technologies

Core Competencies

Demonstrates expertise in data engineering and analytics, with proficiency in SQL, Python, and Azure tools. Capable of building and maintaining scalable data pipelines, generating business intelligence reports, and collaborating effectively with diverse stakeholders.

Tools & Technologies

• Azure Databricks
• Power BI
• Dbt
• Azure