Financial Data Migration Developer

Civica; Vadodara; On-site; INR 1,800,000 - 2,800,000; Full time

Benefits offered by this job

Days of Difference leave

Hybrid/Remote working options

Flexible work arrangements

Job summary

Civica is seeking a Financial Data Migration Developer to join our finance and IT teams in driving data migration initiatives. You will analyze, cleanse, transform, and reconcile complex financial data across multiple ERP systems.

Ideal candidates will have 5+ years of SQL development experience in data migration, with strong T-SQL, ETL tooling, and Excel skills. Hybrid or remote work options are available to support flexible schedules.

Qualifications

• 5+ years of experience in SQL development or data migration.
• Experience in finance/ERP data environments.
• Knowledge of general ledger and financial data structures.
• Experience with ERP platforms like SAP/Oracle/Workday is desirable.

Responsibilities

• Develop and maintain data migration solutions for cleansing, transformation, reconciliation, and migration.
• Profile and validate source financial data across datasets.
• Write, optimize, and troubleshoot complex T-SQL queries.
• Design data mappings between legacy and target systems.
• Document mapping rules and data quality issues.
• Support testing and post-migration validation.

Skills

T-SQL

Joins

CTEs

Window functions

Aggregations

Query performance tuning

ETL tools

Excel (Pivot Tables)

Tools

SSIS

Informatica

Talend

Azure Data Factory

Job description

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.

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.

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.