Data Conversion Specialist

We are seeking a Data Conversion Specialist who will lead the migration of legacy data into a modern SaaS platform. This role requires a unique blend of technical proficiency and business acumen. You will not only execute data conversion tasks but also engage directly with clients to understand their data structures, business processes, and ensure accurate mapping into the new system., Data Analysis & Conversion

• Assess legacy data sources and design conversion strategies for SaaS implementation
• Perform data extraction, transformation, and loading (ETL) using appropriate tools
• Validate data integrity and accuracy post-migration
• Secure handling of client data, e.g. managing Personal Identifiable Information (PII)

Client Engagement & Leadership

• Lead client meetings to gather requirements, clarify business processes, and identify data dependencies
• Translate business workflows into data mapping for the new platform
• Serve as a trusted advisor, guiding clients through conversion best practices

Collaboration

• Work closely with project managers, developers, and QA teams to ensure seamless integration
• Document conversion processes and provide training or support as needed

Documentation & Methodology

• Create and implement Data Management strategies, aligned with project and organizational objectives
• Refine, maintain, and update data management methodology documents and supporting artifacts, ensuring they remain current, consistent, and reusable across projects
• Contribute to the development of data management training materials and knowledge transfer documentation for internal teams and client stakeholders.
• Support and execute data governance use cases, including documentation of standards, processes, and controls related to data quality, lineage, and stewardship, Leads end-to-end migration of federal HR data from legacy systems into Oracle Fusion Cloud HCM. Develops ETL pipelines, transformation rules, cleansing routines, validation scripts, reconciliation reports, and migration runbooks. Performs profiling, anomaly detection, mock conversions, payroll validation, and production cutovers. Partners with HR policy, integration, and data governance teams to ensure accurate, compliant data supporting payroll, benefits, and downstream interfaces. Works independently within Agile and SAFe delivery environments. Top Skills: AgileEhriEltEopfETLFbdiHdlHsdlInformaticaOdiOracle Bi PublisherOracle Cloud InfrastructureOracle Data IntegratorOracle EbsOracle Fusion Cloud HcmOracle Integration CloudOracle Oci Data IntegrationPeoplesoft HcmPythonRSafeSQLTalend CACI International Inc, Lead end-to-end migration of federal HR data from legacy systems into Oracle Fusion Cloud HCM. Develop ETL/ELT pipelines, mapping and transformation logic; profile, cleanse, validate, and reconcile large datasets; execute mock migrations, payroll validation, rehearsals, and production cutovers. Create migration documentation and automated validation scripts, support data governance and issue triage, collaborate with HR and integration teams, and mentor technical staff across complex federal modernization workstreams. Top Skills: AgileBi PublisherEltETLFbdiHdlHsdlInformaticaOci Data IntegrationOdiOracle Cloud InfrastructureOracle Data IntegratorOracle EbsOracle Erp CloudOracle Fusion Cloud HcmOracle Integration CloudPeoplesoft HcmPythonRSafeSQLTalend PNC Bank

• Bachelor’s degree or 5 years’ experience required and Master’s degree (MPA or government focused MBA) preferred
• 5+ years of hands-on experience with data conversion, data migration, and ETL processes, including extracting data from legacy systems, transforming data to meet target model requirements, and loading data into new platforms.
• 5+ years of experience designing, building, and executing ETL or data integration workflows, using custom scripts, integration tools, or database-driven approaches.
• Ability to understand both the service delivery system for programs which are administered by states and monitored by federal regulators.
• Ability to understand and be an expert in complex federal regulations and requirements.
• Strong Microsoft Office applications skills, especially data analytics (i.e. ACCESS, SQL, SPSS)
• Ability to use sound judgment in completing tasks and to seek guidance when needed.
• Attention to detail and ability to work with large data sets with accurate results.

Additional Preferred Qualifications:

• Proficient with ETL, SQL/MySQL, XML, Data Bricks, Microsoft Excel, stored procedures, or other data tooling
• Basic coding experience in languages such as Python and JavaScript
• Experience with relational databases (tables, view, queries, T-SQL and stored procedures)
• Experience working with customers and/or team members and leading data requirements sessions
• Participation in a minimum of 1 full life cycle software implementation
• Understanding of the complete software implementation lifecycle - including data requirements gathering, dataset migration, data reconciliation, and move to production
• 3+ years of experience coordinating and collaborating with cross-organizational partners to define requirements and resolve data issues
• 3+ years of experience mapping, transforming, and loading data from source to target software systems
• Experience in a Data Conversion work stream on a software implementation

• Office Setting
• Some travel required

This position is hybrid with travel/onsite requirements. To be successful at PCG, you must:

• be available during your set working hours
• have a safe, private, and distraction-free environment in which to complete your work, and
• be able to give your full attention to the completion of your PCG job duties

Some travel to the office or elsewhere may be required for team meetings, client meetings, etc. We are accepting applications on an ongoing basis until filled., Compensation for roles at Public Consulting Group varies depending on a wide array of factors including, but not limited to, the specific office location, role, skill set, and level of experience. As required by applicable law, PCG provides a reasonable range of compensation for this role. In addition, PCG provides a range of benefits for this role, including medical and dental care benefits, 401k, PTO, parental leave, bereavement leave

Range: $75,000 - $125,000

PCG does not sponsor newly hired foreign national workers for work authorization, including H-1B sponsorship., 38K-75K Annually Mid level 38K-75K Annually Mid level Machine Learning * Payments * Security * Software * Financial Services Provide high-volume, phone-based technical support and first-line resolution for hardware, software, networking and access issues. Log and track incidents in ServiceNow/ITSM, escalate complex problems, suggest process improvements, and maintain security and confidentiality while working from an approved remote workspace on a set evening/weekend schedule. Top Skills: Call Center TechnologiesItsmPhone SystemsServicenowTicketing Systems

What you need to know about the Colorado Tech Scene

With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.

Key Facts About Colorado Tech

• Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
• Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
• Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
• Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
• Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
• Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute

Senior level Leads legacy data migration into SaaS platforms by assessing sources, designing conversion strategies, executing ETL workflows, mapping and transforming data, validating integrity, and managing PII. Engages clients to gather requirements, document business processes, support governance and data quality, coordinate implementation teams, and develop reusable methodologies and training materials. The summary above was generated by AI

Public Consulting Group LLC (PCG) is a leading public sector solutions implementation and operations improvement firm that partners with health, education, and human services agencies to improve lives. Founded in 1986, PCG employs approximately 2,000 professionals throughout the U.S.-all committed to delivering solutions that change lives for the better. The firm is a member of a family of companies with experience in all 50 states, and clients in three Canadian provinces and Europe. PCG offers clients a multidisciplinary approach to meet challenges, pursue opportunities, and serve constituents across the public sector. To learn more, visit www.publicconsultinggroup.com.

Collaborating with our Technology Consulting team, you will help organizations streamline operations and achieve strategic goals to serve the public better. We provide the full spectrum of technology consulting services to help state and local agencies meet operational and program needs that enhance the lives of their user base.

Services:

• Strategy, Architecture, Planning, and Procurement
• Business Enablement
• Business Solutions
• Project Assurance