Data Consultant (ETL Projects)

Job Description:

Department: Land, Property & Public Protection Customer Success

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 Pune, with a solid 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 were looking for professionals who have delivered complex data migration projects and worked directly with raw source data. Customer facing consultancy experience would be a distinct advantage.

This is a hands-on technical consulting role where you'll collaborate directly with UK-based colleagues and clients to extract, manipulate, transform, validate and migrate legacy data into our cloud platform using bespoke tools and scripts.





Key responsibilities

Customer Data Migration Projects
- Lead and support customer onboarding projects with a focus on data migration and transformation
- Attend discovery and planning sessions with clients to understand legacy data structures, scope and risks
- 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 run data transformations 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 confirm successful migrations
- Troubleshoot data issues in collaboration with UK-based project teams a

📌 Etl Consultant (Pune)
🏢 Idox
📍 Pune