Data Engineer

Accion Labs Europe; Greater London; On-site; GBP 70,000 - 100,000; Full time

Job summary

Accion Labs Europe is seeking an experienced Azure Data Engineer in London to design, develop, and maintain scalable data solutions supporting BI, analytics, and data-driven decisions.

You will model data, develop pipelines with Azure Data Factory, manage data warehouses, and build Python scripts for automation and Power BI dashboards for insights.

Qualifications

• 5–7 years of experience in data engineering, analytics, or BI.
• Hands-on Azure data services, including Synapse, ADF, Data Lake.
• Strong SQL (advanced) and Python is a plus.
• Experience building scalable data models and ETL pipelines.
• Proficient in Power BI dashboards and data visualization.

Responsibilities

• Design and develop scalable, efficient data models for BI and analytics.
• Implement data storage, processing, and retrieval using Azure services.
• Develop ETL processes to ingest, transform, and load data into Azure data services.
• Build data pipelines with Azure Data Factory for system integration.
• Create and manage data warehouse/data lakehouse solutions on Azure.
• Leverage Azure Synapse Analytics for large-scale data analytics.
• Develop Python scripts to automate data tasks and workflows.
• Create interactive Power BI dashboards and reports for decision-making.
• Provide end-user training and support for data visualization tools.
• Write and optimize complex SQL queries for data operations.
• Administer Azure SQL databases ensuring security and performance.
• Monitor data systems, resolve issues, and implement enhancements.
• Collaborate with stakeholders to translate requirements into technical specs.
• Work with data scientists, analysts, and engineers on end-to-end solutions.
• Maintain documentation for models, pipelines, and processes.
• Ensure compliance with organizational policies and regulatory standards.

Skills

Azure Data Services

Azure Synapse

SQL

Power BI

Azure DevOps

MySQL

MariaDB

Data Modeling

ETL

Data Warehousing

Data Pipelines

Data Security

Performance Tuning

Monitoring

Troubleshooting

Collaboration

Job description

Location: London (Onsite – 5 Days/Week) – UK based candidates

Experience: 5–7 Years

About the Role

We are looking for an experienced Azure Data Engineer to design, develop, and maintain scalable data solutions supporting business intelligence, analytics, and data-driven decision-making.

The role will focus on data modeling, data pipeline development, Azure data services, data warehousing, SQL, Python, and Power BI. You will work closely with business stakeholders, data analysts, data scientists, and engineering teams to translate business requirements into reliable and efficient data solutions.

The ideal candidate has strong hands-on experience with Azure Synapse, Azure Data Factory, Azure Data Lake, Azure SQL, advanced SQL, and Python, together with a good understanding of data architecture, ETL processes, and data management.

What You’ll Do

• Design and develop scalable, efficient, and reliable data models to support business intelligence and analytics needs.
• Develop and implement architectural strategies for data storage, processing, and retrieval using Azure cloud services.
• Design, develop, and maintain ETL processes to ingest, transform, and load data from various sources into Azure data services.
• Build robust data pipelines using Azure Data Factory (ADF) to ensure smooth data flow and integration between different systems.
• Design, implement, and manage data warehouse / data lakehouse solutions on Azure, ensuring optimal performance, scalability, and cost efficiency.
• Utilize Azure Synapse Analytics to develop, optimize, and manage data warehousing solutions for large-scale data analytics.
• Develop and maintain Python scripts to automate data processing tasks and workflows.
• Design and create interactive Power BI dashboards and reports to enable data-driven decision-making.
• Provide support and training to end users for the effective utilization of data visualization tools.
• Write and optimize complex SQL queries for data extraction, transformation, and loading operations.
• Manage and administer Azure SQL databases, ensuring data integrity, security, and performance.
• Monitor data systems for performance, security, and reliability issues and implement enhancements as required.
• Identify and resolve data-related issues promptly to ensure the smooth operation of data processes.
• Collaborate with business stakeholders to understand data requirements and translate them into technical specifications.
• Work closely with data scientists, analysts, and other engineering teams to deliver comprehensive data solutions.
• Maintain comprehensive documentation for data models, pipelines, and processes to ensure knowledge sharing and continuity.
• Ensure all data solutions comply with organizational policies, industry standards, and regulatory requirements.

Mandatory Skills

• Strong hands-on experience with Azure Data Services, including:
• Azure Synapse Dedicated SQL Pool / Data Warehouse
• Strong experience with Azure DevOps, including understanding of DevOps project flows.
• Advanced SQL skills.
• Hands-on experience with Power BI.
• Experience with relational databases such as:
• MySQL
• MariaDB
• Strong understanding of data modeling, ETL processes, data warehousing, and data pipelines.
• Good understanding of data security, performance optimization, monitoring, and troubleshooting.
• Strong collaboration and communication skills.

Nice to Have

• Experience with CI/CD pipelines.
• Experience implementing CI/CD for data engineering solutions using Azure DevOps.
• Experience with automated testing and deployment of data engineering solutions.