2 days ago
London, United KingdomMid Level
Responsibilities
- Monitor and support Azure Data Factory pipelines, investigate failures, and safely rerun processes.
- Build and maintain ETL/ELT processes for client data.
- Use SQL to trace data through processing stages, identify root causes, and make controlled corrections.
- Investigate data-quality issues and support routine data loads, validation, reconciliation, and cohort generation.
- Resolve support tickets and production issues in collaboration with Platform, Engineering, QA, and Customer Success teams.
- Improve monitoring, logging, and alerting to identify problems early.
- Support production releases through validation and smoke testing.
- Automate manual processes using Python, SQL, and Azure tooling, and maintain operational runbooks.
Requirements
- Around three or more years of professional experience in Data Engineering, SQL development, data operations, or a similar technical role.
- Strong SQL Server skills, including complex queries, joins, stored procedures, query troubleshooting, and database schemas and relationships.
- Experience with ETL/ELT, data pipelines, and Azure Data Factory or a comparable orchestration platform.
- Ability to investigate unfamiliar datasets and diagnose problems methodically.
- Understanding of data quality, validation, and reconciliation.
- Experience supporting production or business-critical data processes.
- Clear communication skills and the ability to explain technical findings to technical and non-technical colleagues.
- Knowledge of Azure DevOps, Git, CI/CD pipelines, or infrastructure as code is desirable.
- Experience with APIs, JSON, Power BI, or similar reporting tools is desirable.
- Experience working with the public sector, particularly local-authority data, is desirable.
Benefits
- Competitive salary reviewed annually.
- Training and development opportunities.
- 25 days of annual leave plus bank holidays.
- Company pension.
- Private medical insurance.
- Enhanced parental leave policies.
- Cycle to work scheme.
- Flu vaccinations and eye-test and VDU-glasses contributions.
- Employee Assistance Programme, mental health and wellbeing support, remote GP access, counselling and therapy, physiotherapy, and medical second opinions.
- Hybrid London role requiring office attendance at least 1–2 days per week, with occasional travel for on-site client engagements.
