Technical Consultant (Data Migration Focus)

Civica; Dudley; On-site; GBP 45,000 - 60,000; Full time

Job summary

A leading software company in the UK is seeking a Technical Consultant to deliver consultancy services on various projects. The role includes responsibilities like data migration, SQL scripting, and engaging with customers to ensure successful implementations. Candidates should have strong communication skills and at least 5 years of experience with Microsoft SQL. This position offers 25 days of annual leave and a supportive workplace culture.

Benefits

25 Days Annual Leave + bank holidays

Pension Contributions - 5% employer match

Private Medical Insurance

Income Protection - Up to 75% salary cover

Qualifications

• 5 or more years Microsoft SQL experience.
• Prepared to travel throughout the UK and Ireland.
• Time management skills with the ability to work with minimum supervision.
• Ability to manage change of priorities at short notice.
• Ability to deal with demanding product and project development plans.

Responsibilities

• Provide data-related activity for Technical Consultancy Services.
• Develop and deliver new approaches to enhance service delivery.
• Deliver data migration and consultancy following guidelines.
• Act as lead point of contact for Data and Technical delivery.
• Manage customer issues to a successful resolution.

Skills

Good commercial awareness

Ability to gather and define requirements

Good presentation skills

Excellent communication skills

Problem ownership

Time management

Customer service skills

5+ years of Microsoft SQL experience

Tools

Python

JSON

CSS

HTML

C#

APIs

Job description

Responsibilities

• Provide all data related activity of Technical Consultancy Services across several Products to Civica customers
• Develop and deliver new approaches to Technical delivery to continuously enhance the level of service provided
• Deliver data migration and data consultancy for Civica software following Civica project documentation, implementation guidelines and quality standards
• Act as the lead point of contact for Projects for the areas of Data, interfacing and Technical delivery
• Define and document data conversion and Load scope and perform data loading in line with agreed process
• Testing and due diligence during migrations and Implementations
• Produce and maintain documentation to high standards for internal and customer use, including user literature, configuration documentation and technical specifications
• Communicate effectively with customers in advance of agreed tasks, provide progress updates during and upon completion, highlight issues, and recommend follow-on actions
• Develop ad-hoc reports via a range of industry standard reporting tools
• Promote Civica, its products and practices in a professional manner
• Create SQL scripts to view and report on data
• Creation of SQL Stored Procedures, Functions and Triggers
• Development of back office tools and data pipelines
• Migration of SSIS packages and legacy SQL approaches to Azure environments
• Provide workshops and consultancy services in remote or in person format with groups from 1-8 people
• Work with Customers to support User Acceptance Testing (UAT) of solutions delivered in projects, providing triage and issue resolution where possible and raising enhancements and defects with Product Teams
• Liaise with the Civica Project and Account managers
• Provide quotations for non-standard small work packages
• Provide regular internal progress reports as required
• Manage customer issues to a successful resolution ensuring that appropriate customer and internal communication is maintained
• Commercial acumen to manage deliverables to agreed scope and identify any activities/services over & over that contracted for

Requirements

• Good commercial awareness
• Ability to gather and define requirements, including documentation and appropriate customer sign-off
• Good presentation skills
• Excellent communication skills, both written and verbal
• Ability to take ownership of problems and see them to resolution
• Ability to manage change of priorities at short notice
• Ability to deal with demanding product and project development plans
• Prepared to travel throughout the UK and Ireland
• Positive, Proactive & self-motivated
• A clean driving license
• SC & NPPV3 holder or ability to become a holder
• Good customer service skills and ability to deal with customer queries and complaints
• Time management skills with the ability to work with minimum supervision
• Experienced in Microsoft Office products
• 5 or more years Microsoft SQL experience

Desirable skills

• Python
• JSON
• CSS
• HTML
• C#
• APIs

About Civica

We're Civica, and we create software that helps deliver critical services for citizens all around the world.

From local government, to education, health, and care, over 5,000 public bodies across the globe use our software to provide essential services to over 100 million citizens. Our aspiration is to be a GovTech champion everywhere we work, supporting the needs of citizens and those who serve them every day. Building on 21 years of continuous growth and success, we are at a pivotal point in our journey.

Why you will love this opportunity

Technical Consultant at Civica is an essential role in the Civica LG Division Services Team, working across a range of products and customers in the portfolio to deliver professional services consultancy on several concurrent projects. You will develop an in-depth working knowledge of the complete suite of Local Government solutions. The successful candidate will play a pivotal part in ensuring implementations are delivered successfully, on time and budget, and to a high level of customer satisfaction. You will help ensure that Civica is recognised as the leading GovTech Software supplier in the market place. The Technical Consultant will achieve this through positivity, action, professionalism, customer service and industry knowledge.

Benefits

Time Off & Work-Life Balance 25 Days Annual Leave + bank holidays - plus the option to buy up to 10 extra days. Days of Difference - Up to 3 extra days off for volunteering. Financial Well-being & Security Pension Contributions - 5% employer match to support your future. Income Protection - Up to 75% salary cover for long-term illness. Life Assurance - 4x salary tax-free lump sum. Critical Illness Cover - £25,000 lump sum (extendable to dependents). Health & Perks Private Medical Insurance - Fast access to private healthcare. Health Cash Plan - Claim back physio, therapies & more. Dental Insurance - Cover for routine & emergency care. Affinity Groups - Join employee-led communities. Bounty Bonus - Refer a friend & get rewarded.

At Civica, we are committed to building an inclusive and diverse workplace where everyone feels valued and supported. We believe that a variety of perspectives drives innovation and excellence, and we welcome applicants from all backgrounds, cultures, and experiences. We are an equal opportunity employer. We do not discriminate based on race, ethnicity, religion, gender, sexual orientation, disability, age, or any other legally protected characteristic. Our recruitment process is designed to ensure fairness and transparency, so every candidate has an equal chance to contribute to our mission. If you need any adjustments or accommodations to participate in our recruitment process, please let us know. We are here to support you.