Technical Consultant Local Government - Data Migration Focus

Technical Consultant - (Local Government - Data Migration Focus)

5 days ago Be among the first 25 applicants

Get AI-powered advice on this job and more exclusive features.

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 Gov Tech 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're at a pivotal point in our journey to realise that aspiration.

Its 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 Gov Tech Software supplier in the market place. The Technical Consultant will achieve this through positivity, action, professionalism, customer service and industry knowledge.

• 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, providing progress updates, highlighting issues and recommending 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
• Create SQL Stored Procedures, Functions and Triggers
• Develop 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 no 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 & above that contracted for

Candidates must have experience in Software Implementations, specifically Data Migrations, ideally using Microsoft SQL. They should also have experience within at least one of the following areas of local government either as a supplier or a customer:
Housing, Revenues, Asset management, Regulatory data (e.g. licensing, Food Standards), Fire Safety, Transport or Police.

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