Senior Data Engineer

• Designing and delivering scalable, reliable and reusable data engineering solutions.
• Building ETL/ELT pipelines and integrations using ETL tools, Microsoft Fabric, SQL, Python and other appropriate technologies.
• Designing and configuring Microsoft Fabric pipelines, lakehouses, data warehouses and data models.
• Supporting the migration of on-premises data workloads to Microsoft Fabric.
• Implementing data quality controls, testing, monitoring and technical documentation.
• Applying data architecture standards and engineering best practices.
• Translating complex business requirements into practical, maintainable data solutions.
• Creating and maintaining data catalogue, metadata management and data lineage.
• Working collaboratively with technical teams, analysts and business stakeholders., At OCC, you’ll be part of a team that’s not only passionate about what we do, but also about how we do it. We foster a culture of inclusion, respect, and continuous improvement, and we’re proud to offer flexible working arrangements, professional development opportunities, and a strong sense of purpose in everything we do.
• Hybrid working - Benefit from a flexible mix of home and office working, with typically around one day a week in the office for collaboration.
• Culture of flexible working - Flexibility is important to deliver the service and to suit individual lifestyles. We encourage discussion at interview as we acknowledge there isn’t a one-size-fits-all approach.
• Great learning and development opportunities to support your growth
• Technology to support agile working - with unlimited access to Copilot for smarter productivity

• Significant experience of developing data integration, migration and data warehousing solutions using one or more ETL platforms, such as Talend, Microsoft Fabric, FME or SSIS.
• In-depth working knowledge of SQL, with the ability to write and optimise queries and stored procedures.
• Experience building robust data pipelines using Python, PySpark or other relevant programming languages.
• Solid hands-on experience of designing and developing Microsoft Fabric solutions across pipelines, lakehouses, warehouses and data layers.
• Strong data modelling skills, with experience designing scalable and maintainable models for data integration, warehousing, analytics and reporting.
• Strong data discovery skills, including locating, understanding and analysing source data.
• Experience of implementing testing and data quality controls to identify, prevent and resolve data anomalies.
• Experience of creating and maintaining data catalogues, technical metadata and data lineage using Microsoft Purview or another metadata management platform would be advantageous.

• Generous annual leave - up to 30 days plus bank holidays, and an option to ‘buy’ additional time off
• Enhanced family-friendly policies
• Local Government Pension Scheme - employer contributions up to 19.9%
• Discounts - local and national offers for shopping and travel

Your office base may be subject to change as we are currently transitioning between temporary and permanent office locations due to the closure of County Hall. If this is applicable to you, you will be notified, but no reimbursement will apply in respect of travel., We are open to discussions about flexible working, which can include flexi-time, part time working, job sharing, nine-day fortnights and annualised hours, depending on the requirements of the role and the service.