Data Conversion Consultant

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 with relational databases (e.g., Oracle, SQL Server)
• Hands-on experience with data mapping, transformation, and validation processes
• Experience designing and executing ETL workflows, including extraction, transformation, and loading of large datasets
• Demonstrated ability to lead client-facing discussions, workshops, or working sessions and effectively engage with stakeholders
• Strong communication and interpersonal skills, with the ability to explain technical data concepts to non-technical audiences and drive decisions with customers
• Proven ability to analyze complex data structures and translate business requirements into technical solutions
• Strong experience with data validation and reconciliation techniques to ensure data accuracy and integrity
• Excellent attention to detail and problem-solving skills, with the ability to identify and resolve data quality issues
• Experience collaborating with cross-functional teams and managing multiple priorities