Data Engineer (Public Sector Consulting)
Sitting within our Digital, Data and Technology practice, this role is ideal for a values-driven, collaborative individual with a strong interest in data engineering, cloud technologies, and analytics platforms.
This role would suit an early-career data professional who is keen to develop technical data engineering skills while also gaining experience of consulting, client delivery and public sector transformation.
About us:
31ten is an agile, independent consultancy and certified B Corp. Trusted by our clients and partners, we’ve been named as one of the UK’s Leading Management Consultancies by the Financial Times every year since 2020.
We work in partnership with the public sector to make places better for the people that live, work, and learn in them.
Integrity, inclusivity, social and environmental awareness are at the heart of what we do, and we collaborate with our clients to deliver sustainable change, meaningful impact, and better outcomes.
31ten works across Local & Central Government, Housing & Development, Education, Health & Social Care and Blue Light Services.
Our services in these sectors typically take the shape of:
Customer, Digital & Technology;
Strategy & Transformation;
People & Change;
Placemaking & Regeneration;
Finance & Assets;
Procurement & Partnerships; and
Business Cases.
About the role:
We are keen to speak to candidates who are interested in supporting us to deliver services to the public sector, which:
Improve how residents, businesses and service users interact with council and public services
Help public sector organisations make better use of their data for decision-making, reporting and service improvement
Improve data quality, consistency and governance across complex operational services
Support the migration of data from legacy platforms into modern cloud-based systems
Enable automation and digital transformation across services such as planning, building control, housing, customer services and regulatory services
Help clients move from fragmented spreadsheets, manual processes and legacy databases to more reliable, scalable and secure data solutions
Key responsibilities:
Developing, maintaining and testing ETL/ELT pipelines, ingesting data from internal systems, APIs, databases and other sources
Supporting data migration from legacy systems, including cleansing, validation, reconciliation and transformation
Producing data mapping documents, translation tables and migration rules, and supporting automation of these processes
Working with relational databases, data warehouses and reporting datasets, including writing and troubleshooting SQL
Preparing high-quality datasets for analytics, dashboards and reporting, and supporting Microsoft Azure cloud platforms
Documenting technical solutions and decisions, performing data quality checks, and supporting UAT and migration testing
Working with non-technical staff to translate business requirements into technical specifications
Ensuring compliance with data security, governance and GDPR, and contributing to project documentation and client updates
In this role, we’d expect you to…
Be a clear and effective communicator, with the ability to flex style to the audience and client context
Be comfortable working with both technical and non-technical colleagues
Take responsibility for clarifying scope, planning and driving forward delivery of defined workstreams, delegating tasks as required, meeting deadlines and flagging risks
Confidently present your own work / findings as part of a wider project team, to new and familiar stakeholders
Have a growing understanding of commerciality – invoicing, margins, budgets and frameworks
Develop positive relationships with clients through project work and start to influence at a project level with key stakeholders.
Demonstrate curiosity about how public services operate and how data can improve outcomes
Be willing to learn new systems, tools and technologies quickly
Contribute to internal development activity, such as case studies, blogs, tender responses, proposals and reusable project materials
About you:
A great ‘31tenner’ is a self-starter with drive and ambition. We are looking for people who can build excellent client relationships and work collaboratively within a team environment. But above all else, you must be passionate about social impact and working with the public sector.
We hire the person first, experience second, shaping the role around the individual. We recognise that every candidate's experiences and background will be different. We value a broad, diverse range of perspectives.
We’re keen to hear from values-driven candidates, with:
A relevant degree in data, computer science, engineering, mathematics, analytics or a related subject, but we are equally interested in candidates who can demonstrate strong technical aptitude, curiosity and a willingness to learn
A minimum of 12 months relevant work experience
A growth mindset, regularly seeking feedback and continuous self-improvement
Initiative and ownership, self-managing your time, flagging your availability and clearly communicating updates with project teams, working across multiple projects in tandem
The ability to engage successfully with clients, client teams and key stakeholders and to work in a relational manner/style
An interest in improving public sector and local government services
The ability to deal with ambiguity and to navigate complex or unclear issues
The ability to think analytically, systematically, and logically, breaking down complex information to enable us and our clients to better understand them
Be comfortable receiving and delivering clear, constructive feedback (or prepared to embrace the uncomfortable!)
An active contribution to the development of our company culture, role-modelling our values and engaging with internal initiatives and knowledge-sharing
Essential Skills
Basic to intermediate SQL skills (queries, joins, aggregations)
Working knowledge of Python or a similar programming language
Understanding of databases, data structures, and ETL concepts
Familiarity with version control systems (e.g. Git, Visual Studio)
Desirable Skills
Exposure to cloud data platforms (Azure Data Factory, Synapse, Databricks, AWS Glue)
Awareness of data warehousing concepts (star and snowflake schemas)
Experience with big data tools such as Spark
Knowledge of BI tools such as Power BI or Tableau
Understanding of agile or DevOps delivery environments
Understanding of how a consulting business operates
Benefits:
25 days annual leave + bank holidays
Flexi bank holidays - the option to substitute religious holidays for a date that is meaningful to you
The option to purchase up to 5 additional annual leave days (per year)
Private healthcare package with BUPA and the ability to add family members
Matched pension up to 6% of gross salary
Enhanced maternity and shared parental leave
Annual performance-based bonus (discretionary)
Work-life balance – we recognise that everyone has interests and commitments outside of their work and so we strongly advocate for working in the way that’s best for you. Whether that’s part-time, condensed hours, from home or the office, flexible working arrangements are actively supported
A friendly and supportive working environment with regular opportunities for collaboration, team socials and modern offices with excellent facilities for staff in a central location
Annual team away day and Christmas party
Opportunities to get involved in our social value programme of volunteering and pro-bono support to causes that align with our mission
Continuous opportunities for career development and training, including support to pursue professional qualifications (that align to our work)
Unlimited access to our online learning platform, You Can Now
Salary sacrifice cycle-to-work, tech at home and electric vehicle scheme
Access to our Payroll Giving scheme, enabling tax‑efficient donations to charities of your choice
Our interview process:
1st stage - Initial call with our People Lead (30mins, virtual via Teams)
2nd stage - Technical interview (90mins, virtual via Teams) with two members of the hiring team
3rd stage - Values & behaviours interview - Final meeting with two members of our Senior Leadership Team (1hr, in-person)
- Department
- Consulting
- Locations
- London
- Remote status
- Hybrid
- Employment type
- Full-time
- Salary
- £35-50k
About 31ten Consulting
31ten is an agile, independent consultancy and certified B Corp. Trusted by our clients and partners, we’ve been named as one of the UK’s Leading Management Consultancies by the Financial Times every year since 2020.
We work in partnership with the public sector to make places better for the people that live, work, and learn in them.