At a Glance
- Tasks: Join us in transforming public services through data engineering and cloud technologies.
- Company: 31ten, a certified B Corp consultancy making a real impact in the public sector.
- Benefits: Enjoy flexible working, private healthcare, and generous leave options.
- Other info: Be part of a supportive team culture with endless learning opportunities.
- Why this job: Develop your skills while contributing to meaningful social change in local communities.
- Qualifications: A degree in a relevant field or strong technical aptitude is preferred.
The predicted salary is between 30000 - 40000 £ per year.
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.
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)
Data Engineer (Public Sector Consulting) in London employer: 31ten Consulting
At 31ten, we pride ourselves on being an excellent employer that values work-life balance and employee well-being. Our supportive and collaborative work culture fosters personal and professional growth, with opportunities for continuous development and involvement in meaningful social initiatives. Located in a central area with modern facilities, we offer flexible working arrangements and a range of benefits, including private healthcare and enhanced parental leave, making us an attractive choice for those seeking a rewarding career in consultancy.
StudySmarter Expert Advice🤫
We think this is how you could land Data Engineer (Public Sector Consulting) in London
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like 31ten Consulting!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Data Engineer (Public Sector Consulting) at 31ten Consulting.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like 31ten Consulting.
✨Apply Directly through Our Website
When you find a suitable opening like Data Engineer (Public Sector Consulting) at 31ten Consulting, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Data Engineer (Public Sector Consulting) in London
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at 31ten Consulting, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at 31ten Consulting. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at 31ten Consulting
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at 31ten Consulting!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.