Data Integration/Migration Consultant

Capio Group; California; Remote; USD 125,000 - 135,000; Full time

Benefits offered by this job

Flexible workplace

Great work‑life balance

Job summary

Capio Group is looking for an experienced Data Integration/Migration Consultant. This is a full-time remote position with a competitive salary ranging from $125,000 to $135,000. The ideal candidate will have significant experience in data migration and integration for complex IT systems.

You will work to enhance clients' existing systems, providing robust solutions and improving data management practices. Candidates must possess relevant degrees and certifications, with a strong background in data governance.

Qualifications

• 5+ years supporting data migration and integration for complex IT systems.
• 4+ years of relevant experience in authoring data pipelines.
• Familiarity with data validation and audit readiness.

Responsibilities

• Evaluate current data policies and practices.
• Establish procedures for data requirements and analysis.
• Document and assess the as-is data environment.

Skills

Data migration

Data integration

Data quality

Data cleansing

Data pipeline authoring

Education

Bachelor’s or advanced degree in relevant fields

Data Management or Architecture certification

Cloud data certifications (Google Cloud preferred)

Tools

Accela Civic Platform

Data modeling tools

Job description

Capio Group is looking for an experienced Data Integration/Migration Consultant.

Full-time employee – Remote Salary: $125,000 – $135,000

About Us

Capio Group is a California-based Information Technology Consulting firm serving the public sector since 2010. We assist the Government in delivering large, complex systems and solutions. Capio Group is a small, but quickly growing firm that mixes good ideas with great people to achieve extraordinary results for our clients. We offer the salary and benefits of larger companies, with the added bonus of a flexible workplace and a great work‑life balance.

Scope of Work

As a Data Integration/Migration Consultant, you will enhance the client’s existing systems into a single solution by integrating a centralized database system. This solution will eliminate duplicate and redundant data systems and improve tracking, licensing regulation, compliance, and laboratory activities. A centralized system will streamline services for consumers, support robust reporting, enable real-time tracking of applicant, licensee, and compliance performance measures, facilitate trend analysis to inform policy development, and provide data‑driven adjustments to business processes that increase efficiency and accountability. It will also strengthen client oversight, accelerate regulatory responsiveness, and support evidence‑based decision‑making.

Responsibilities

• Research, evaluate, and critique the current data policies, practices, and procedures.
• Engage key stakeholders from selected departments to understand their data sources and needs.
• Establish a procedure to determine data requirements, assess business implications, analyze risks, evaluate feasibility, and identify short‑term and long‑term opportunities for improvement.
• Provide a plan detailing the data flow and the tools necessary to maintain data quality standards and synchronicity with the systems.
• Participate in developing plans and in data synchronization work.
• Identify and execute tasks in preparation for data conversion and migration to reduce conversion and migration issues and risks.
• Work with client’s business and technical staff to continue data profiling.
• Recommend preferred methods to document and develop data cleansing methods and rules.
• Coordinate and implement data cleansing rules.
• Collaborate with various stakeholders to achieve objectives for data management.
• Document and assess the as‑is data environment.
• Identify, collect, and classify client data.
• Organize data and create data models for all client applications.
• Build a repository of data sources, data flows, data owners, data custodians, and data users.
• Administer mapping of all data sources and its movement to ensure data quality.
• Analyze information flow and recommend appropriate technologies to support business processes.

Mandatory Experience

• Within the last ten (10) years, a minimum of five (5)+ years supporting data migration, conversion, and integration for complex IT systems.
• Within the last ten (10) years, a minimum of four (4) years of relevant experience in authoring and monitoring data pipelines.
• Must possess a bachelor’s or advanced degree (master’s or PhD) in computer science, engineering, information systems, math, or technology‑related fields. Additional qualifying experience may substitute for the required education on a year‑for‑year basis; a copy of the degree must be provided upon request.
• Must possess a Data Management or Architecture certification. May not be substituted with additional experience; a copy of the certification must be provided upon request.
• Within the last ten (10) years, a minimum of one (1) year of experience with Accela Civic Platform or Accela licensing and enforcement modules.
• Within the last ten (10) years, experience with regulatory data, licensing records, enforcement actions, or compliance datasets.
• Within the last ten (10) years, familiarity with data quality, validation, and audit readiness.
• Possession of cloud data certifications (Google Cloud preferred). May not be substituted with additional experience; a copy of the certification must be provided upon request.

E&E&I Statement

At Capio Group, our employees are our greatest asset and diversity, equity, and inclusion are at the core of who we are. Our commitment to these values is unyielding and is central to our mission and to our impact. We know that having diverse perspectives helps to generate better ideas to solve the complex problems of our diverse clients and the communities they serve.

Are you a legal resident of United States? This is a mandatory requirement for this job.