Data Consultant

Idox plc; Glasgow; On-site; GBP 40,000 - 80,000; Full time

Job summary

An innovative firm is on the lookout for a Data Consultant to help transform data processes for Local Government clients. This role offers the chance to engage directly with clients, leading data migration projects while utilizing your expertise in ETL processes and database management. You will be part of a collaborative environment that encourages curiosity and continuous learning, making a significant impact on data-driven decision-making. If you have a passion for data and are eager to contribute to meaningful projects, this position could be your next career step.

Qualifications

• Strong experience in delivering large scale data migration projects.
• Proficient in SQL, PSQL, C#, and Python for data manipulation.

Responsibilities

• Engage with Local Government clients for data migration consultancy.
• Lead data mapping sessions and ensure project requirements are met.

Skills

ETL Processes

SQL

Data Mapping

Problem Solving

Communication

Education

Bachelor's degree in Computer Science

Equivalent work experience in data consulting

Tools

Oracle

SQL Server

PostGres SQL

AWS

Azure

Job description

Idox plc Glasgow, Scotland, United Kingdom

Data Consultant

Idox plc Glasgow, Scotland, United Kingdom

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.

Idox fosters a culture that celebrates curiosity, collaboration, and continuous learning, empowering our team to explore new ideas and solve complex challenges. 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.

Key responsibilities

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. Responsibilities will include:

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
• Collaborate with stakeholders to translate complex technical issues into clear, actionable insights for non-technical users
• Contribute to regular updates & calls, communicating effectively to ensure progress transparency and address concerns proactively

Execution and validation

• Undertake ETLs with accuracy and integrity, within scope, timescale and budget parameters as advised by Project Managers
• Troubleshoot and resolve issues collaboratively with internal teams and customers
• Provide validation reporting to verify successful transformation and assist issue resolution

Post Migration support

• Provide support to customers post-migration, assisting with reconciliation and issue resolution
• Provide feedback from ongoing improvement

Technical experience

• 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.

To be successful:

Essential Qualifications and Experience:

• Educational Background: 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.
• ETL Expertise: 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.
• Client-facing Consultancy: 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.
• Technical Skills: Proficiency in at least 2 of the following: SQL, PSQL, C#, Python and Pandas for data manipulation and analysis.
• Problem Solving: Detail-oriented with exceptional problem-solving skills, capable of troubleshooting issues quickly and efficiently.
• Communication: Excellent ability to convey technical concepts to non-technical stakeholders, collaborate with customers and work cross-functionally with internal teams.
• Process Improvement: Willingness to contribute to development of new processes and tools to streamline service quality and enhance delivery speed.

Desirable Skills and Experience:

• 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

Applicants will be expected to evidence experience and qualifications as well as undertake a practical demonstration of skills as part of the interview process.

Seniority level

• Seniority level

  Associate

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Software Development

Referrals increase your chances of interviewing at Idox plc by 2x

Get notified about new Data Consultant jobs in Glasgow, Scotland, United Kingdom.

Glasgow, Scotland, United Kingdom 2 months ago

Glasgow, Scotland, United Kingdom 1 month ago

Undergraduate Data and Reporting Analyst

Glasgow City, Scotland, United Kingdom 6 days ago

Glasgow, Scotland, United Kingdom 16 hours ago

UK Retirement Data Solutions Associate Consultant

Glasgow, Scotland, United Kingdom 2 days ago

Glasgow, Scotland, United Kingdom 1 week ago

Senior Associate - Data Integration Consultant - Payroll Technology, Tax, Belfast

Glasgow, Scotland, United Kingdom 2 weeks ago

Glasgow, Scotland, United Kingdom 1 month ago

Glasgow, Scotland, United Kingdom 1 week ago

Glasgow, Scotland, United Kingdom 2 weeks ago

Glasgow, Scotland, United Kingdom 1 month ago

Glasgow, Scotland, United Kingdom 1 day ago

Glasgow, Scotland, United Kingdom 2 weeks ago

Glasgow, Scotland, United Kingdom 1 week ago

Senior D365 CE Functional Consultant - Financial Services

Glasgow, Scotland, United Kingdom 3 weeks ago

Glasgow, Scotland, United Kingdom 23 hours ago

Glasgow, Scotland, United Kingdom 4 days ago

Glasgow, Scotland, United Kingdom 1 month ago

Cyber Security Consultant - Contract Engagement - Outside IR35

Glasgow, Scotland, United Kingdom 3 months ago

Senior D365 CE Functional Consultant - Financial Services

Glasgow, Scotland, United Kingdom 2 weeks ago

Glasgow, Scotland, United Kingdom 1 month ago

Glasgow, Scotland, United Kingdom 1 day ago

Glasgow, Scotland, United Kingdom 1 day ago

Glasgow, Scotland, United Kingdom 1 week ago

Glasgow City, Scotland, United Kingdom 1 week ago

Glasgow, Scotland, United Kingdom 2 weeks ago

Glasgow, Scotland, United Kingdom 2 months ago

Graduate Research Assistant - Data Analyst: Migration

Law, Scotland, United Kingdom 2 months ago

Glasgow, Scotland, United Kingdom 1 month ago

Graduate Research Assistant - Data Analyst: Migration

Law, Scotland, United Kingdom 2 months ago

Glasgow, Scotland, United Kingdom 3 weeks ago

Glasgow, Scotland, United Kingdom 1 week ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.