Data and Reconciliation consultant

At Idox, data powers everything we do. We are a forward-thinking organisation that uses data to drive innovation, inform decision-making, and create value for customers. With our commitment to excellence, we continuously push the boundaries of data integration, ETL process and issue resolution. We are currently seeking a Data Consultant / Engineer with strong technical expertise and consultancy experience to help deliver high-quality data solutions for Local Government clients. If you are passionate about data, driven by innovation and eager to make an impact, join us on our journey to shape the future of data transformation at Idox. As a Data Consultant, you will engage frequently and directly with Local Government clients to provide expert consultancy throughout the data migration lifecycle, ensuring clarity, accuracy and efficiency. Discovery & Planning Lead introductory sessions to outline end-to-end data migration processes, overall approach and potential risk Conduct in-depth discovery workshops to analyse customer data, define transformation specifications and scope project requirements Data Mapping and Transformation Facilitate guided mapping sessions, working at granular level to align customer data with target system requirements Undertake ETLs with accuracy and integrity, within scope, timescale and budget parameters as advised by Project Managers Provide validation reporting to verify successful transformation and assist issue resolution Provide support to customers post-migration, assisting with reconciliation and issue resolution Undertake database extractions from back-office software solutions commonly used in Local Government regulatory services, ensuring completeness and accuracy. Lead and execute upon a portfolio of complex ETL project deliveries (transformations and merges) using a combination of internal and industry-standard ETL tools and scripting languages. Contribute to the ongoing development and evolution of innovative and efficient processes that improve delivery quality, scalability and consistency across our data consulting services. Develop and maintain documentation for ETL processes, including data mappings, transformations, technical specifications, and workflows for reference and compliance. Stay informed of industry trends, best practices and advancements in ETL and data management. A Bachelor’s degree in Computer Science, Information Technology, or similar; equivalent work experience in a data consulting or ETL engineering is also valued. Local GovernmentExperience : Familiarity with back-office software databases used in Council Regulatory Services, such as Development Control, Housing, Environmental Services or Licensing. Proven experience delivering large scale, complex data migration projects. Expert in the development and automation of ETL processes utilising industry standard scripting languages as well as common ETL tools. Demonstrated ability to engage with customers, lead discovery sessions, undertake requirements analysis, extract objectives and translate into technical deliverables. Database Proficiency: Strong hands-on experience with Oracle, SQL Server, and PostGres SQL databases. SQL, PSQL, C#, Python and Pandas for data manipulation and analysis. Process Improvement: Willingness to contribute to development of new processes and tools to streamline service quality and enhance delivery speed. Familiarity with cloud-based data platforms (e.g., AWS, Azure, Google Cloud) Understanding of DMS (Document Management Systems) and ability to extract and manipulate documents and associated data Understanding of spatial data and use of spatial tools such as ESRI ArcGIS or QGIS