ABOUT THE ROLE
Accela is seeking a Data Conversion Consultant to support the successful implementation of the Accela Civic Platform. This role is responsible for the end-to-end data migration lifecycle, including data analysis, mapping, transformation, validation, and load execution.
The Data Conversion Consultant partners 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 that requires strong analytical skills, attention to detail, and the ability to translate complex data structures into scalable, high-quality solutions.
SPECIFIC 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 in a clear and actionable way
- Develop and maintain detailed source-to-target data mapping specifications aligned to Accela data models (e.g., 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 work collaboratively with functional consultants and client 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 and continuous improvement
- Demonstrate curiosity and initiative in leveraging AI-assisted tools and automation to improve data migration processes, including mapping, validation, documentation, and 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 working w