Data Conversion Specialist

Work set-up: 
Full Remote
Contract: 
Full time
Experience: 
Senior (5-10 years)
Work from: 
United States

Offer summary

Qualifications:

Minimum of four years of experience in authoring and monitoring data pipelines., Bachelor's or higher degree in computer science, engineering, or related fields; substitutions possible with relevant experience., At least seven years of experience in planning and executing data migration for IT projects, including legacy systems and Salesforce., Experience with data validation post-migration and working with ALM tools..

Key responsibilities:

  • Gather and document project requirements and assess current legacy systems.
  • Design and implement data migration, integration, and transitional architecture.
  • Lead project management activities, including stakeholder communication and team guidance.
  • Provide training, support, and post-implementation review to ensure successful system transition.

Capio Group logo
Capio Group Information Technology & Services TPE https://capiogroup.com/
11 - 50 Employees
See all jobs

Job description

Capio Group is looking for an experienced Data Conversion Specialist!

Fulltime employee Remote
Salary: $125,000 $140,000

About Us:
Capio Group is a Californiabased 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 the bigger companies, with the added bonus of a flexible workplace and a great worklife balance.

Scope of Work:
Capio Group is looking for an experienced and qualified Data Conversion Specialist to support and provide services for project management, data cleansing, conversion, migration, service architecture, service solution, and service integration using client’s Salesforce Platform, and MuleSoft Integration Platform to support the project requirements and with data exchange tasks. The solution must integrate with the clients current system and provide electronic communication between the systems. The services include data profiling, modeling, and readying the data foundation according to the current state of clients data in the context of clients transition data state for the implementation.

As part of the team, the Data Conversion Specialist will be responsible for tasks including but not limited to:
1. Requirements Gathering

  • Engage in collecting and documenting new or updated requirements.
  • Evaluate business requirements and translate it into user stories or business, technical, and data requirements.
  • Take part in sessions to gather and review requirements alongside technical and business team members.
  • Conduct a comprehensive assessment of the current legacy system and transitional architecture to understand the architectures and functionalities.
  • Work with client businesses and IT SMEs to generate use case prioritization.
    • 2. Design
      • Conduct a comprehensive assessment of the current legacy system to understand its architecture, functionalities, and data model.
      • Draft transitional plan outlining the process for transitioning data, workflow, and functionalities from legacy systems to SalesforceMuleSoft.
      • Collaborate with the development team throughout the transitional process and conduct regular review and adjustments.
      • Provide data migration, Salesforce and MuleSoft architecture design and solutions in accordance with project concept, ensuring alignment with best practice, industry standards, and organization standards.
      • Collaborate to identify and group logical Project services components and dependencies for Project solution backlog.
      • Collaborate to prioritize Project solution backlog.
        • 3. Project Management
          • Participate in developing and maintaining the project plans required by the client, ensuring that all milestones and deliverables are met on time.
          • Conduct Stakeholder Communication: Act as the primary point of contact for stakeholders, including clients, team members, and vendors. Regularly update stakeholders on project progress, risks, and issues.
          • Provide Team Leadership: Lead and mentor the project team, providing guidance and support to ensure they have the resources and information needed to complete their tasks effectively.
          • Conduct Resource Assessment: Provide bottom up estimation process for staffing and hours for the Contractor to successfully meet requirements during the Base Contract period.
          • Conduct Technical Oversight: Oversee the technical aspects of the project, including data conversion and the integration of Salesforce and MuleSoft. Ensure that best practices are followed and that the solutions meet the project requirements.
          • Provide Quality Assurance: Work closely with the QA team to ensure that all deliverables are thoroughly tested and meet quality standards. This includes coordinating smoke testing, unit testing, and integration testing.
          • Collaborate with the UAT team and assist in structured testing planning and execution
          • Conduct Problem Resolution: Identify and resolve any issues that arise during the project, ensuring that they are addressed promptly and effectively.
          • Complete Documentation: Ensure that all project documentation is complete and uptodate, including technical documentation, user manuals, and project reports.
          • Coordinate Training and Support: Provide training and support to endusers and stakeholders to ensure they can effectively use the new systems and processes.
          • Conduct PostImplementation Review: Conduct a postimplementation review to evaluate the projects success and identify areas for improvement in future projects.
          • Support Continuous Improvement: Implement continuous improvement practices to enhance project delivery processes and outcomes. Provide lessons learned to the client Team Leaders.
            • 4. Data Architecture
              • Provide a plan detailing the data flow, and tools necessary to maintain data quality standards and synchronicity with two separate production systems.
              • Participate in data synchronization work.
              • Participate in developing plans to decouple data synchronization.
              • Identify and execute tasks in preparation for data conversion and migration to decrease data conversion and migration issues and risks.
              • Work with client’s business and technical staff to continue with:
                • Conduct data profiling
                • Recommend preferred ways to document and develop data cleansing method and rules
                • Coordinate and implement data cleansing rules
                    • 5. Solution Implementation, Configuration, and Integration
                      • Enhance, improve, and update transitional architecture to meet project requirements.
                      • Implement and configure Salesforce and MuleSoft solutions in accordance with the designed architecture, ensuring alignment with best practices, industry standards, and organizational standards.
                      • Configure components to seamlessly integrate with legacy systems and downstream processes.
                      • Configuremodify the application to work with project requirements and design.
                      • Perform testing and validation of the solution to verify functionality and interoperability.
                      • Collaborate with the client’s staff and contractors to contribute to building an implementation plan and roadmap.
                        • 6. Release Management and Testing
                          • Create and manage the release management process.
                          • Build and align to the client’s release process.
                          • Conduct unit testing and integration testing and assist in System, User Acceptance testing and Structured Testing.
                          • Assist with defect triage meetings and provide resolution.
                            • 7. Organizational Change Management
                              • Perform Process Assessment: Conduct ASIs and ToBe analysis for the process impacted by the implementation of the project, including business and technology support structures.
                              • Develop OCM Plan and Change Strategy: Create and document OCM plan or strategy for the project, define change resistance mitigation strategies, and develop an OCM roadmap and methodology.
                              • Support Change Readiness: Assess project readiness for implementation, develop the clients readiness plan and roadmap, and facilitate readiness communication and feedback loops.
                              • Support Prosci ADKAR Adoption for the project: Conduct ADKAR assessment, develop remediation plans and assessments, and create ADKAR progress tracking roadmap.
                              • Develop the OCM Governance Structure: Define OCM sponsorship and leadership roles, create stakeholder management and communication frameworks, develop and implement Key Performance Indicators (KPIs) for OCM effectiveness.
                              • Update Project’s Communication Management Plan and Strategy: Define communication channels and audience segmentation and implement multichannel communication strategies. Create stakeholder OCM communication strategies and update in the Project’s Communication Management Plan.
                              • Build Change Agent Capacity: Identify and train the client’s change agents needed for the scope of the project and define roles and responsibilities on change adoption.
                              • Project Persona Research and Assessment: Analyze personabased needs and training requirements for the project teams and the end user community.
                              • Continuous Improvement and Reinforcement: Develop a continuous improvement roadmap and establish reinforcement strategies for sustaining change.
                                • 8. Transition Support and Knowledge Transfer
                                  • Create and deliver a knowledge transfer plan when applicable.
                                  • Facilitate any training sessions in accordance with the knowledge transfer plan.
                                    • 9. Provide Maintenance and Operations (M&O) services.

                                      Mandatory Experience:
                                      1. Must have a minimum of four (4) years of relevant experience in authoring and monitoring data pipelines.
                                      3. Must possess a bachelor’s or advanced degree (masters or PhD) in computer science, engineering, information systems, math or technologyrelated field. A copy of the degree must be provided upon request. Additional qualifying experience may be substituted for the required education on a yearforyear basis. Successful completion of a data engineering bootcamp plus an additional year of experience may be substituted for the degree requirement.
                                      5. Must have a minimum of seven (7) years of experience within the last ten (10) years planning and executing data migrationconversion efforts for IT projects, involving Mainframe legacy system technologies, such as DB2VSAM systems, and Salesforce database.
                                      7. Must prior experience performing postmigration validation to ensure data accuracy and completeness.
                                      9. Must have a minimum of three (3) years of experience working with ALM tools.
                                      11. Must be able to provide a clientuser end reference contact information for each applicable project meeting the requirements upon request. Reference scoringsignature will be required.
                                        12. Desirable Experience:
                                          1. A minimum of seven (7) years of experience working with Salesforce data.
                                          3. A minimum of five (5) years of experience within the last ten (10) years performing data analysis and design, including developing data models and workflows for system integration.
                                          5. Prior experience with CA DMV legacy data and services.
                                          7. At least five (5) years of experience within the last ten (10) years developing and optimizing ETL processes using tools for enterprise data integration in the public sector.
                                          9. At least fifteen (15) years of experience designing and developing applications using COBOL, CICS, and JCL.
                                          11. Prior experience performing ETL on a project involving more than 900 million legacy data records to Salesforce.
                                          13. Possession of Data Architect certification, Database Administrator certification. A copy of the certification must be provided upon request.
                                          15. Possession of Salesforce Platform App Builder, Salesforce OmniStudio Developer. A copy of the certification must be provided upon request.
                                          17. Possession of MuleSoft Certified Integration Architect or Integration SpecialistProfessional. A copy of the certification must be provided upon request.
                                            18. Equal Opportunity Employer:
                                              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.

Required profile

Experience

Level of experience: Senior (5-10 years)
Industry :
Information Technology & Services
Spoken language(s):
English
Check out the description to know which languages are mandatory.

Hard Skills

Data MigrationEnterprise Service BusSalesforceData CleansingData ModelingData ConversionSystems IntegrationChange ManagementProject ManagementETL (Extract Transform Load)Internal DocumentationTechnical AuditData ProfilingData ArchitectureMicrosoft Platform Builder

Other Skills

  • Quality Assurance
  • Team Leadership
  • Communication
  • Problem Solving
Are you interested?

Related jobs

See more jobs