Data Conversion Consultant
Job Description:
- 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
Requirements:
- 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, including functional consultants, developers, and client stakeholders
- Experience working on SaaS or enterprise application implementations (government/public sector experience preferred)
- Demonstrated willingness to adopt and leverage AI-assisted tools, automation, or modern data technologies to improve delivery efficiency and scalability.
Benefits:
- Flexible time off
- Comprehensive medical, dental, and vision plans
- Family planning benefits
- 401(k) retirement savings plan with company match
- Health savings account with company contributions
- Flexible spending account
- Life, accident, and disability coverage
- Business travel insurance
- Employee assistance programs
- Other well-being benefits