31ten Consulting
Data Engineer (Public Sector Consulting)
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
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
- 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
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
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
Get help with your application
Your very own career expert that helps elevate your application to the next level.
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)
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location