Data Engineer

Are you a data professional who wants to make a difference in the public sector? If your answer is yes, then here is the opportunity for you!

Join Oxfordshire County Council (OCC) as a Data Engineer and help turn data into products and services that make a real difference. You'll develop and build data products and integrate them into the systems and business processes the council relies on every day.

Working as part of a varied data team, you'll help fulfil OCC's ambition to be data driven, supporting the flow of data from acquisition through to assessment, analysis and consumption. The data you work with will be wide-ranging, drawn from across the council, and what you create will drive direct operational and strategic impacts.

Key responsibilities will include, but are not limited to:

• Enable OCC to be truly data driven by ensuring robust, reliable data is available for insight generation, management information, and business intelligence.
• Design and build scalable data flows that connect operational systems with analytics platforms, data warehouses, and business intelligence tools, replacing manual processes with repeatable, automated solutions.
• Develop and optimise data pipelines by writing high-quality extract, transform and load (ETL) code that performs efficiently and reliably at scale, applying core data engineering principles and technical best practices.
• Locate, understand and analyse source data, creating accessible, analysis-ready datasets and reusable data products to support further analysis.
• Maintain and evolve data models that meet OCC's organisational needs and support consistent, high-quality reporting.
• Work closely with stakeholders to understand reporting and insight needs, translating technical concepts into clear, non-technical language and shaping practical data solutions.
• Deliver resilient, scalable and future-proof data solutions that align with OCC standards, ensuring data products are well-documented, accurate and kept up to date.

Do you have experience in Talend?, * Strong experience developing data solutions using one or more ETL platforms, such as Talend, SSIS, FME, or Azure Data Factory.

• In-depth working knowledge of SQL, with the ability to write and optimise queries and stored procedures.
• Experience building data pipelines using Python or other programming languages.
• Strong data discovery skills, including locating, understanding and analysing source data.
• Good experience in working with stakeholders to capture reporting and insight requirements and translate them into practical solutions.
• Experience using reporting and visualisation tools, such as Power BI, Business objects.
• Experience turning data into insight, creating reports and outputs for both technical and non-technical audiences. Relevant professional qualifications or equivalent experience in a similar role and/or sector.

Pulled from the full job description

• Annual leave

• Employee discount

• Company pension, * Hybrid working - Flexibility is important to deliver the service and to suit individual lifestyles, we encourage discussion at interviews as we acknowledge there isn't a one size fits all approach

• Culture of flexible working

• Great learning and development opportunities to support your growth

• Technology to support agile working- with unlimited access to Copilot for smarter productivity

• Employee Assistance Programme with health and wellbeing support

• 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, 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.

Data and analytics are key enablers for strong strategic and operational decision-making, supporting design of policy, delivery of services and improving outcomes for residents. An exciting opportunity has arisen to join the council's central Data Office. This service is a key enabler in delivering our ambitions as part of our Digital, Data and Technology strategies (DDaT) and consists of multi-disciplinary teams across Data Architecture & Engineering, Spatial Data & Systems, and Data & Analytics functions. You'll be part of an always-learning culture, working alongside colleagues across the functions of the Data Office and the wider organisation to support diverse services and help embed data-led decision-making at the heart of the council. This is an exciting time to join the team as we continue to shape and embed new ways of working, using data and analytics to support the delivery of high-quality, impactful public services., 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.