Data Conversion Consultant

About the Role

Accela is seeking a Data Conversion Consultant to support successful implementation of the Accela Civic Platform. This role manages the end-to-end data migration lifecycle, including data analysis, mapping, transformation, validation, and load execution.

You will partner with functional consultants, technical teams, and client stakeholders to ensure legacy data is accurately transformed and loaded into the Accela platform in alignment with business requirements. This is a hands-on, delivery-focused role requiring strong analytical skills, attention to detail, and the ability to translate complex data structures into scalable, high-quality solutions.

Key Responsibilities

• Analyze legacy system data structures and perform data profiling to identify data quality issues, gaps, and transformation requirements
• Lead data-focused work sessions and workshops with client stakeholders to gather requirements, review mappings, and resolve data-related decisions
• Engage directly with customers to explain data structures, transformation logic, and migration outcomes clearly
• Develop and maintain detailed source-to-target data mapping specifications aligned to Accela data models (records, contacts, parcels, ASI)
• Design and execute data extraction, transformation, and load (ETL) processes to migrate data into the Accela Civic Platform
• Perform data cleansing, normalization, and enrichment activities to ensure consistency and accuracy prior to migration
• Execute mock conversions and support iterative migration cycles, including testing, validation, and issue resolution
• Develop and execute data validation and reconciliation processes to confirm completeness, accuracy, and integrity of migrated data
• Troubleshoot data-related issues and collaborate with functional consultants and stakeholders to resolve discrepancies
• Support User Acceptance Testing (UAT) activities related to migrated data and ensure readiness for go-live
• Participate in go-live cutover activities, including final data loads and post-migration validation
• Document migration processes, mapping logic, validation results, and lessons learned to support repeatability
• Leverage AI-assisted tools and automation to improve data migration processes and develop repeatable frameworks
• Contribute to the development of data migration best practices, tools, and templates across the Professional Services organization

Required Qualifications

• 3+ years of experience in data migration, data conversion, or ETL-related roles in enterprise software implementations
• Strong SQL skills and experience with relational databases (Oracle, SQL Server, or equivalent)
• Hands-on experience with data mapping, transformation, and validation processes

Salary Disclosure: The advertised salary range of $80,000–$130,000 USD annually is an editorial market estimate based on industry standards for this role and experience level, not an employer-provided figure. Actual compensation may vary based on your experience, qualifications, and location.