Job Title

Direct message the job poster from Idox plc About the role At Idox, data migration is mission critical. Our software solutions power digital transformation across UK Local Government, and the quality of our customer implementations relies on accurate, efficient and robust data extraction and transformation. We are seeking an experienced Data Consultant based in the UK, with a strong background in ETL scripting, data transformation, and hands-on data engineering to support onboarding projects for our Idox Cloud customers. This is not a Business Intelligence or reporting role – we’re looking for professionals who have delivered complex data migration projects and worked directly with raw source data. Experience of working with Local Government datasets would be a distinct advantage. This is a hands-on technical consulting role where you'll collaborate directly with Idox customers and colleagues to extract, manipulate, transform, validate and migrate legacy data into our cloud platform using bespoke tools and scripts. Key Responsibilities CUSTOMER DATA MIGRATION PROJECTS • Skilled in data restructuring, normalisation/denormalisation, error handling, and transformation logic. • Lead technical discovery and planning sessions with clients to understand legacy data structures, scope and risks. Explain complex data structures to non-technical audiences. • Analyse source systems and legacy database schemas (e.g., Oracle, SQL Server, Postgres), and design appropriate data mapping strategies. • Extract raw data from back-office software systems (often with incomplete documentation), validating completeness and consistency. • Build and execute data pipelines using scripting and/or ETL tools – SQL, Python or proprietary tools. • Create and apply transformation rules to map legacy data into the Idox target model. • Produce transformation reports, reconciliation outputs, and validation summaries to support successful migrations. • Troubleshoot data issues in collaboration with project teams and support post-migration validation and issue resolution. To be successful, you should bring: ESSENTIAL SKILLS AND EXPERIENCE: • Strong ETL project experience: Direct involvement in extracting, transforming and loading complex datasets as part of software implementations or system transitions / merges. • Scripting proficiency: Strong, demonstrable, practical experience in SQL for data manipulation and transformation. • Database expertise: Proven hands-on experience working with relational databases (Oracle, SQL Server, PostgreSQL). • Consulting mindset: Ability to work independently and collaboratively with both internal and external stakeholders. • Problem-solving ability: Comfortable working with semi-structured or inconsistent legacy datasets and finding creative, reliable solutions. • Communication: Strong written and spoken English, capable of documenting technical processes and actively collaborating with delivery teams and customers. We are looking for professionals with a background in hands-on ETL development, data architecture, and complex data migration tasks—ideally in a consulting capacity. Important note: This role is not suitable for candidates whose primary experience is in data visualisation, Power BI, or business intelligence reporting. DESIRABLE EXPERIENCE: • Experience with UK Local Government systems or public sector datasets. • Familiarity with cloud-hosted environments (AWS, Azure, Google Cloud). • Experience with document management systems and/or spatial data tools (ArcGIS, QGIS). • Knowledge of data reconciliation, validation, and audit processes. Shortlisted candidates will be invited to a technical interview and will be expected to evidence experience and qualifications, as well as undertake a practical data transformation task to demonstrate real-world skills. About Idox Our specialist software solutions power the performance of government and industry, driving productivity and a better experience for everyone. Built around the user and designed in collaboration with experts who have worked through every detail of every process from end-to-end, our hard-working process engines deliver exceptional functionality and embed workflows that drive efficiency and best practice with a long-term focus for regulated environments. Through the automation of tasks, the simplification of complex operations, finding scalability as operations evolve, and more effective management of information, we help our customers harness the power of Digital, so they can do more. Our Values D.R.I.V.E – The core values taking us forward. R – Responsibility – We are accountable for our actions. I – Integrity – We do the right thing. V – Valued – We value each other. E – Excellence – We set the benchmark for quality. Our Culture We are ambitious in working together to promote a more inclusive environment, which attracts all candidates and signals our commitment to celebrate and promote diversity. Idox is a company where we can all be ourselves and succeed on merit, where we respect all our employees, customers and communities in which we live, work and are a part of. We recruit and reward employees based on capability and performance – regardless of race, gender, sexual orientation, gender identity or expression, lifestyle, educational background, origin, religion or physical ability. Each office location worldwide, is free to respond to local needs to create a culturally sensitive workplace for everyone. In doing so, we want every employee to feel our commitment to showing respect for all and encouraging open collaboration and communication. Flex to Fit We recognise that for individuals, the opportunity to work flexibly can enable them to achieve a better work-life balance along with a greater sense of responsibility, ownership and control of their working life. During the pandemic, all our employees successfully transitioned to remote working, and we are open to conversations on work patterns to suit our employees needs such as change to working times; part time working; term time working; 9-day fortnight. We are proud to be a flexible employer enabling effective hybrid working for our employees. Family Friendly We understand how important family is to our employees and provide support through difficult times such as bereavement as well as offering excellent pay and leave benefits for parents and carers welcoming a child. Health and Wellbeing Our Workplace Wellbeing team provide support and resources on mental health and lifestyle. We also provide 24/7 confidential help via our employee assistance programme. Be Heard You will have the chance to impact change within Idox by having your voice heard via our CEO live broadcasts; making suggestions to Idox Voice forum or sharing your ideas in our company newsletter, Inside Idox. Community You will have the opportunity to participate in community and social activities, as well as group wide fundraising ventures. We prioritise sustainability and ethical impact on our communities, and we pledge to allow our employees to carry out volunteer work. Your Development Our mentor scheme will help you to achieve personal and professional growth through learning from experienced colleagues and you will also have access to online and face to face learning modules including our Leadership Development Programme. We offer full company sick pay plus income protection for long term illness and our life assurance cover is provided up to four times annual salary. Our Pension Scheme operates on a salary Exchange Contribution Basis so you will receive relief from NI contributions. You are also invited to join our Idox Xtra Share Scheme where every share bought will receive an extra one free from the company. How to apply Please submit a CV, and a short cover letter (maximum 500 words - including salary expectation, and current remuneration) explaining why you feel you would be suited to this role to join.us@ Please note successful applicants will need to satisfy the BPSS guidelines (Baseline Personnel Security Standards) which consist of the receipt of satisfactory references covering the last 3 years of employment; an identity check; verification of eligibility to work in the UK; and a Basic Disclosure Check. This is in order to help us make safer recruitment decisions. Privacy Notice As part of the recruitment process, we will collect data about you in a variety of ways including the information you would normally include in a CV or a job application cover letter, or notes made by our recruiting officers during a recruitment interview. Please read our Recruitment Data Privacy Policy here: Seniority levelSeniority level Mid-Senior level Employment typeEmployment type Full-time Job functionJob function Business Development Industries Software Development Referrals increase your chances of interviewing at Idox plc by 2x Sign in to set job alerts for “Data Consultant” roles.Farnborough, England, United Kingdom 2 weeks ago Milton Keynes, England, United Kingdom 1 week ago Bletchley, England, United Kingdom 1 day ago London, England, United Kingdom 1 week ago Greater London, England, United Kingdom 4 days ago Graduate Research Assistant - Data Analyst: MigrationLaw, Scotland, United Kingdom 1 month ago Systems Administrator & Data Analyst (6 months)London, England, United Kingdom 1 week ago Senior Data Governance Consultant (Collibra & Ataccama)London, England, United Kingdom 1 week ago London, England, United Kingdom 3 months ago London, England, United Kingdom 1 day ago London, England, United Kingdom 3 days ago London, England, United Kingdom 1 week ago Data Architect – SAP (BTP, BW/4HANA, SAC)Preston, England, United Kingdom 5 days ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.#J-18808-Ljbffr