We’re Civica and we make software that helps deliver critical services for citizens all around the world. From local to state government, to education, to health and care, over 5,000 public bodies across the globe use our software to help provide critical services to over 100 million citizens.Our aspiration is to be a GovTech champion everywhere we work around the globe, supporting the needs of citizens and those that serve them every day. Building on 21 years of continuous growth and success, we're at a pivotal point on our journey to realise that aspiration.As a company, we’re passionate about what we do and the citizens we help to serve. If you too would like to help champion the use of technology in public services, to improve outcomes for citizens and public sector organisations, then Civica is the right place for you. We will help you unlock the best version of yourself, achieve growth in your career whilst making a real difference to people and communities.Why you will love this opportunity as Financial Data Migration Developer at CivicaAs a Financial Data Migration Developer, you will work closely with Finance, IT, Business Analysts, and Application teams to support financial data migration activities across transformation programmes. You will be responsible for analysing, cleansing, transforming, validating, and reconciling complex financial datasets, ensuring data integrity throughout the migration lifecycle. The role requires both technical expertise and the ability to understand financial processes and communicate effectively with business stakeholders.What you’ll be doing:Develop and maintain data migration solutions that support iterative data cleansing, transformation, reconciliation, and migration activities.Analyse and profile source financial data across sales orders, customer records, GL balances, AP/AR, deferred revenue, trial balance, and other key financial datasets.Write, optimise, and troubleshoot complex T-SQL queries to extract, transform, validate, and reconcile large volumes of data.Design and implement data mapping between legacy and target financial systems, including chart of accounts, cost centres, and financial dimensions.Document mapping rules, transformation logic, assumptions, and identified data quality issues. Perform detailed reconciliation processes to ensure completeness and accuracy of migrated financial data. Investigate and resolve data discrepancies, anomalies, and quality issues in partnership with Finance stakeholders.Translate complex technical concepts into clear and understandable business language.Support testing activities, including unit testing, system integration testing, and user acceptance testing. Participate in mock migrations, dress rehearsals, cutover activities, and post-migration validation.Collaborate with cross-functional teams across multiple locations and time zones to ensure successful project delivery.RequirementsWhat you will bring:Technical Skills5+ years' experience writing and optimising complex T-SQL queries in a data migration or data transformation environment.Strong experience with: JoinsCTEsWindow functionsAggregationsQuery performance tuning Experience extracting, cleansing, transforming, and validating large datasets.Familiarity with ETL tools such as SSIS, Informatica, Talend, or Azure Data Factory is desirable.Advanced Excel skills, including Pivot Tables, XLOOKUP, and financial data reconciliation techniques. Finance & Domain KnowledgeExperience supporting finance-related data migration, ERP implementation, or business transformation programmes.Strong understanding of General Ledger, Chart of Accounts, Trial Balance, Accounts Payable/Receivable, Sales Order data, and financial reporting structures.Knowledge of journal entries, reconciliation processes, and financial reporting cycles.Experience working with ERP platforms such as SAP, Oracle Financials, Workday Financials, or similar systems is highly desirable. Personal AttributesProactive, self-motivated, and results-focused.Strong analytical and problem-solving skills with exceptional attention to detail.Effective communicator who can engage confidently with both technical and non-technical stakeholders.Ability to work independently, manage competing priorities, and deliver to deadlines in a fast-paced environment.Collaborative mindset with a strong focus on quality and continuous improvement. Qualifications & Experience5+ years' experience as a SQL Developer, Data Analyst, Data Migration Specialist, or similar role.Previous exposure to finance, accounting, or ERP data environments.Professional certifications in SQL, data analytics, accounting, or finance are advantageous but not essential.We Want You to Bring Your Whole Self to WorkThere is no such thing as the perfect candidate, so if you think you have what it takes but don't necessarily meet every single point on the list above, please still get in touch. We'd love to have a chat and see if you could be a great fit.BenefitsWhy you'll love working with us We know that when our people are happy, they will work better and have greater work satisfaction. Here's what you can expect: We're all different - and we love this about us. We provide an inclusive, safe, and welcoming environment to all Civicans, new and old Focus on learning- there are heaps of opportunities to enable you to grow and be your best. Giving culture - we encourage you to "give back" with benefits such as our Days of Difference leave where you can volunteer for a charity of your choice. Flexible Work - we have comprehensive flexibility options including part-time work, adjusted hours, staggered shifts, and hybrid or remote working, supporting work–life balance based on individual needs.Apply for this job - Become part of something special Do you see yourself in this role? If so, then we would love to hear from you.
We’re Civica and we make software that helps deliver critical services for citizens all around the world. From local to state government, to education, to health and care, over 5,000 public bodies across the globe use our software to help provide critical services to over 100 million citizens.
Our aspiration is to be a GovTech champion everywhere we work around the globe, supporting the needs of citizens and those that serve them every day. Building on 21 years of continuous growth and success, we're at a pivotal point on our journey to realise that aspiration.
As a company, we’re passionate about what we do and the citizens we help to serve. If you too would like to help champion the use of technology in public services, to improve outcomes for citizens and public sector organisations, then Civica is the right place for you. We will help you unlock the best version of yourself, achieve growth in your career whilst making a real difference to people and communities.
Why you will love this opportunity as Financial Data Migration Developer at Civica
As a Financial Data Migration Developer, you will work closely with Finance, IT, Business Analysts, and Application teams to support financial data migration activities across transformation programmes.
You will be responsible for analysing, cleansing, transforming, validating, and reconciling complex financial datasets, ensuring data integrity throughout the migration lifecycle. The role requires both technical expertise and the ability to understand financial processes and communicate effectively with business stakeholders.
What you’ll be doing:
- Develop and maintain data migration solutions that support iterative data cleansing, transformation, reconciliation, and migration activities.
- Analyse and profile source financial data across sales orders, customer records, GL balances, AP/AR, deferred revenue, trial balance, and other key financial datasets.
- Write, optimise, and troubleshoot complex T-SQL queries to extract, transform, validate, and reconcile large volumes of data.
- Design and implement data mapping between legacy and target financial systems, including chart of accounts, cost centres, and financial dimensions.
- Document mapping rules, transformation logic, assumptions, and identified data quality issues.
- Perform detailed reconciliation processes to ensure completeness and accuracy of migrated financial data.
- Investigate and resolve data discrepancies, anomalies, and quality issues in partnership with Finance stakeholders.
- Translate complex technical concepts into clear and understandable business language.
- Support testing activities, including unit testing, system integration testing, and user acceptance testing.
- Participate in mock migrations, dress rehearsals, cutover activities, and post-migration validation.
- Collaborate with cross-functional teams across multiple locations and time zones to ensure successful project delivery.
Requirements
What you will bring:
Technical Skills
- 5+ years' experience writing and optimising complex T-SQL queries in a data migration or data transformation environment.
- Strong experience with:
- Joins
- CTEs
- Window functions
- Aggregations
- Query performance tuning
- Experience extracting, cleansing, transforming, and validating large datasets.
- Familiarity with ETL tools such as SSIS, Informatica, Talend, or Azure Data Factory is desirable.
- Advanced Excel skills, including Pivot Tables, XLOOKUP, and financial data reconciliation techniques.
Finance & Domain Knowledge
- Experience supporting finance-related data migration, ERP implementation, or business transformation programmes.
- Strong understanding of General Ledger, Chart of Accounts, Trial Balance, Accounts Payable/Receivable, Sales Order data, and financial reporting structures.
- Knowledge of journal entries, reconciliation processes, and financial reporting cycles.
- Experience working with ERP platforms such as SAP, Oracle Financials, Workday Financials, or similar systems is highly desirable.
Personal Attributes
- Proactive, self-motivated, and results-focused.
- Strong analytical and problem-solving skills with exceptional attention to detail.
- Effective communicator who can engage confidently with both technical and non-technical stakeholders.
- Ability to work independently, manage competing priorities, and deliver to deadlines in a fast-paced environment.
- Collaborative mindset with a strong focus on quality and continuous improvement.
Qualifications & Experience
- 5+ years' experience as a SQL Developer, Data Analyst, Data Migration Specialist, or similar role.
- Previous exposure to finance, accounting, or ERP data environments.
- Professional certifications in SQL, data analytics, accounting, or finance are advantageous but not essential.
We Want You to Bring Your Whole Self to Work
There is no such thing as the perfect candidate, so if you think you have what it takes but don't necessarily meet every single point on the list above, please still get in touch. We'd love to have a chat and see if you could be a great fit.
Benefits
Why you'll love working with us
We know that when our people are happy, they will work better and have greater work satisfaction. Here's what you can expect:
We're all different - and we love this about us.
We provide an inclusive, safe, and welcoming environment to all Civicans, new and old Focus on learning- there are heaps of opportunities to enable you to grow and be your best.
Giving culture - we encourage you to "give back" with benefits such as our Days of Difference leave where you can volunteer for a charity of your choice.
Flexible Work - we have comprehensive flexibility options including part-time work, adjusted hours, staggered shifts, and hybrid or remote working, supporting work–life balance based on individual needs.
Apply for this job - Become part of something special Do you see yourself in this role? If so, then we would love to hear from you.
Civica is a global leader in public sector software.Our software sustains and enhances public services worldwide. It’s backed by 30 years of experience and the expertise of our people, many of whom have worked in the public sector. We focus on improving outcomes and building a business that will continue to deliver for communities globally.With operations in the UK and Ireland, Australia, New Zealand, India, Singapore, Canada and North America, Civica is one of the UK’s largest software companies. We employ around 5,000 people, and we’re recognised for our culture, which has earned the Investors in People ‘Gold’ standard in the UK.
Civica is a global leader in public sector software.
Our software sustains and enhances public services worldwide. It’s backed by 30 years of experience and the expertise of our people, many of whom have worked in the public sector. We focus on improving outcomes and building a business that will continue to deliver for communities globally.
With operations in the UK and Ireland, Australia, New Zealand, India, Singapore, Canada and North America, Civica is one of the UK’s largest software companies. We employ around 5,000 people, and we’re recognised for our culture, which has earned the Investors in People ‘Gold’ standard in the UK.
