- 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
#J-18808-Ljbffr
Energy Analytics Engineer in London employer: Jobtailor
As a Client Services Coordinator at our dynamic company, you will thrive in a supportive work culture that prioritises employee growth and development. We offer comprehensive training, opportunities for advancement, and a collaborative environment where your contributions are valued. Located in a vibrant area, our team enjoys a healthy work-life balance and the chance to engage with diverse clients, making every day rewarding and meaningful.
