Talent.com
Data Migration/Integration Quality Analyst (Remote)
Data Migration/Integration Quality Analyst (Remote)Fei.com, Inc. • Columbia, MD, US
Data Migration / Integration Quality Analyst (Remote)

Data Migration / Integration Quality Analyst (Remote)

Fei.com, Inc. • Columbia, MD, US
30+ days ago
Job type
  • Full-time
  • Remote
Job description

Job Description

Job Description

At FEI Systems, we create innovative technology solutions to improve the delivery of health and human services because we know when cumbersome administrative processes stand in the way, those who need it most are often left without access to proper care and support. From comprehensive case management software to disaster recovery services and content management information systems used in delivering foreign aid, our solutions are improving the lives of millions of people. We’re looking for a data migration / integration quality analyst who shares our commitment to leveraging technology to make a real impact in the world – a professional who knows, beyond all else, that the quality of our products and services is only as good as the company we keep.

Job Summary :

This individual will work in team of Quality Assurance Analysts and is responsible for planning and conducting a wide range of quality assurance tasks, specifically targeted at validating accuracy of data migration and integration points. This activity includes analyzing requirements, test planning and strategy, developing and executing tests, evaluating results and reporting, and promoting organizational and product integrity. Must have working knowledge of Microsoft SQL server.

Responsibilities :

Data Migration Planning

  • Develop and execute migration strategies from legacy to new systems : This requires a deep understanding of both the source and target systems. The specialist must determine the most efficient and effective method for transferring data, considering factors such as data volume, complexity, and downtime requirements. Strategies may include phased migrations, parallel runs, or big-bang approaches.
  • Identify risks, milestones, and quality checkpoints : Proactive risk management is essential for successful data migration. The specialist must identify potential challenges, such as data corruption, system outages, or compatibility issues, and develop mitigation plans. Defining clear milestones and quality checkpoints allows for progress tracking and ensures that the migration stays on schedule and within budget.

Data Analysis & Mapping

  • Analyze source and target systems for compatibility : This involves a detailed examination of the data structures, data types, and data formats of both the source and target systems. The specialist must identify any incompatibilities and develop strategies for resolving them.
  • Perform data profiling and mapping to ensure accurate transformation : Data profiling involves analyzing the data in the source system to understand its characteristics, such as data quality, completeness, and distribution. Data mapping involves defining the relationships between the source and target data elements, specifying how the data will be transformed during the migration process.
  • Resolve discrepancies and ensure data integrity : The specialist must identify and resolve any discrepancies, ensuring that the migrated data is accurate, complete, and consistent. This may involve data cleansing, data validation, and data reconciliation.
  • ETL Process Oversight

  • Validate Extract, Transform, Load (ETL) workflows : This involves validating the ETL processes that will extract data from the source system, transform it into the required format, and load it into the target system.
  • Quality Assurance & Validation

  • Develop test plans to verify data accuracy post-migration : The specialist must develop test plans that will verify the accuracy of the migrated data. These test plans should cover all critical data elements and should be designed to detect any errors or inconsistencies.
  • Conduct audits, reconciliations, and exception reporting : Audits involve reviewing the migrated data to ensure that it meets the defined quality standards. Reconciliations involve comparing the data in the source and target systems to ensure that they are consistent. Exception reporting involves identifying and reporting any errors or inconsistencies that are found during the audit or reconciliation process.
  • Benchmark pre- and post-migration data for consistency : Benchmarking involves comparing the data in the source and target systems after and after the migration. This helps to identify any changes in data quality or performance that may have occurred during the migration process.
  • Documentation & Reporting

  • Maintain detailed records of migration processes and outcomes : The specialist must maintain detailed records of all aspects of the migration process, including the migration strategy, the data mapping, the ETL processes, and the test results. This documentation will be invaluable for future reference and for troubleshooting any issues that may arise.
  • Create technical documentation for future reference : This includes documenting the data structures, data types, and data formats of both the source and target systems, as well as the transformation logic that was used during the ETL process.
  • Report progress and challenges to project stakeholders : Regular progress reports should be provided to project stakeholders, highlighting key milestones, challenges encountered, and mitigation strategies employed. This ensures that stakeholders are kept informed and can provide timely feedback and support.
  • Compliance & Security

  • Ensure adherence to data governance and privacy regulations : The specialist must ensure that the migration process complies with all relevant data governance and privacy regulations, such as GDPR, CCPA, and HIPAA.
  • Implement secure data handling and encryption protocols : Secure data handling and encryption protocols must be implemented to protect the data during the migration process. This includes encrypting the data in transit and at rest, as well as implementing access controls to prevent unauthorized access.
  • Required Skills / Experience :

  • Minimum of 3+ years of experience in a QA role, with at least 2 years specifically focused on data migration and integration projects.
  • Experience working with different data migration methodologies and tools.
  • Experience in developing and executing test plans and test cases for data migration and integration scenarios.
  • A solid grasp of the entire data migration process, from planning and extraction to transformation, loading, and validation. This includes understanding different migration strategies
  • Knowledge of various data integration methods, such as ETL (Extract, Transform, Load), ELT (Extract, Load, Transform), data virtualization, and API-based integration.
  • Expert level knowledge of SQL Server and preferred Snowflake.
  • Knowledge of Database modeling, design, ETL, and performance tuning
  • Experience in AWS RDS and EC2 database hosting.
  • Experience with the following :
  • 3+ years of experience with SQL Server and ETL tools.
  • 2+ years of experience using JAMS / PowerShell scripting.
  • 2+ years of experience working with Git, Azure DevOps, Octopus and / or similar tools for version control and build management.
  • 2+ years of experience working with AWS RDS instances
  • 2+ years of experience working with REST API based integration,
  • Bachelor’s degree or equivalent work experience
  • Ability to work in a team environment
  • Capable of designing and developing solutions for customers
  • Ability to communicate software designs to team members and monitor its progress
  • Strong attention to detail and a positive attitude.
  • Self-motivated individual with excellent written and verbal communication skills.
  • Excellent problem-solving skills.
  • A willingness to work independently or in a team-oriented environment both efficiently and courteously.
  • Location : Remote

    Status : Full time position with full company benefits

    NOTICE : EO / AA / VEVRAA / Disabled Employer – Federal Contractor. FEI Systems participates in E-Verify, a federal program that enables employers to verify the identity and employment eligibility of all persons hired to work in the United States by providing the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS), with information from each new employee’s Form I-9 to confirm work authorization. For more information on E-Verify, please contact DHS at (888) 464-4218.

    Applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, marital status, political affiliation, disability, or genetic information, except where it relates to a bona fide occupational qualification or requirement. FEI Systems creates an Affirmative Action Plan on an annual basis. Pursuant to federal law, the portions of FEI Systems’ Affirmative Action Program that relate to Section 503 (Persons with Disabilities) and / or Section 4212 (Protected Veterans), are available for inspection upon request by applicants and employees during FEI Systems’ normal business hours.

    Create a job alert for this search

    Data Quality Analyst • Columbia, MD, US

    Related jobs
    BSA / AML Quality Assurance Analyst

    BSA / AML Quality Assurance Analyst

    VirtualVocations • Baltimore, Maryland, United States
    Full-time
    BSA / AML Quality Assurance Analyst.Key Responsibilities Perform quality assurance reviews on completed SARs and No-SAR investigations Identify trends in alerts and SARs to improve detection and r...Show more
    Last updated: 30+ days ago • Promoted
    Quality Control Analyst (Remote)

    Quality Control Analyst (Remote)

    Fei.com, Inc. • Columbia, MD, US
    Remote
    Full-time
    At FEI Systems, we create innovative technology solutions to improve the delivery of health and human services because we know when cumbersome administrative processes stand in the way, those who n...Show more
    Last updated: 26 days ago • Promoted
    Remote AI Task Reviewer – Flexible Hours, No Experience Needed

    Remote AI Task Reviewer – Flexible Hours, No Experience Needed

    RLDG • Pennville, Pennsylvania, United States
    Remote
    Full-time
    Join our distributed team as a Remote AI Task Reviewer and help improve AI systems by completing short, style online tasks. This is an easy-to-learn role with full training and ongoing support.No pr...Show more
    Last updated: 30+ days ago • Promoted
    Senior QNXT Configuration Analyst

    Senior QNXT Configuration Analyst

    VirtualVocations • Baltimore, Maryland, United States
    Full-time
    A company is looking for a Sr QNXT Config Analyst to lead the configuration and optimization of QNXT systems for healthcare claims processing. Key Responsibilities Conduct requirements discovery s...Show more
    Last updated: 30+ days ago • Promoted
    Quality Assurance Analyst

    Quality Assurance Analyst

    VirtualVocations • Baltimore, Maryland, United States
    Full-time
    A company is looking for an Analyst - Quality Assurance IT responsible for supporting Quality Assurance activities within Information Technology. Key Responsibilities Collaborates with stakeholder...Show more
    Last updated: 30+ days ago • Promoted
    Virginia Licensed Integration Analyst

    Virginia Licensed Integration Analyst

    VirtualVocations • Baltimore, Maryland, United States
    Full-time
    A company is looking for an Integration Analyst.Key Responsibilities Oversee the implementation, support, and integration of Electronic Health Record (EHR) and revenue cycle applications Design,...Show more
    Last updated: 17 hours ago • Promoted • New!
    Data Analyst II

    Data Analyst II

    VirtualVocations • Baltimore, Maryland, United States
    Full-time
    A company is looking for a Data Analyst II - Store Analytics.Key Responsibilities Support analytical projects by delivering insights on store performance and staffing optimizations Conduct in-de...Show more
    Last updated: 30+ days ago • Promoted
    Data Quality & Integration Analyst

    Data Quality & Integration Analyst

    Arcadia • Washington, DC, US
    Full-time
    Arcadia is dedicated to happier, healthier days for all.We believe that there is a better healthcare world – one powered by data. Our platform transforms complex, diverse data into a unified f...Show more
    Last updated: 5 days ago • Promoted
    Remote Senior Financial Analyst - AI Trainer

    Remote Senior Financial Analyst - AI Trainer

    Data Annotation • Frederick, Maryland
    Remote
    Full-time +1
    We are looking for a finance professional to join our team to train AI models.You will measure the progress of these AI chatbots, evaluate their logic, and solve problems to improve the q...Show more
    Last updated: 30+ days ago • Promoted
    QA Analyst

    QA Analyst

    VirtualVocations • Washington, District of Columbia, United States
    Full-time
    A company is looking for a QA Analyst to join their IT Services department on a primarily remote basis.Key Responsibilities Ensure quality and integrity across all custom-developed software Crea...Show more
    Last updated: 30+ days ago • Promoted
    Healthcare Data Analyst

    Healthcare Data Analyst

    VirtualVocations • Baltimore, Maryland, United States
    Full-time
    A company is looking for a Business Analyst.Key Responsibilities Analyze business needs related to healthcare data exchange and interoperability workflows Interpret and document healthcare data ...Show more
    Last updated: 30+ days ago • Promoted
    Software Quality Analyst

    Software Quality Analyst

    VirtualVocations • Baltimore, Maryland, United States
    Full-time
    A company is looking for a Software Quality Analyst to join their technology team on a contract basis.Key Responsibilities Develop and maintain automation frameworks using Selenium (Java), Rest A...Show more
    Last updated: 30+ days ago • Promoted
    Certified Coding Specialist Analyst

    Certified Coding Specialist Analyst

    VirtualVocations • Baltimore, Maryland, United States
    Full-time
    A company is looking for an Individual & Family Plans (IFP) Quality Review and Audit Analyst.Key Responsibilities Conduct medical records reviews and abstract diagnosis codes in compliance with r...Show more
    Last updated: 30+ days ago • Promoted
    Epic MyChart Analyst

    Epic MyChart Analyst

    VirtualVocations • Baltimore, Maryland, United States
    Full-time
    A company is looking for an Epic MyChart Analyst to support and maintain the MyChart patient portal application.Key Responsibilities Troubleshoots and resolves user and vendor reported issues Pa...Show more
    Last updated: 30+ days ago • Promoted
    Remote Commercial Banking Analyst - AI Trainer

    Remote Commercial Banking Analyst - AI Trainer

    Data Annotation • Frederick, Maryland
    Remote
    Full-time +1
    We are looking for a finance professional to join our team to train AI models.You will measure the progress of these AI chatbots, evaluate their logic, and solve problems to improve the q...Show more
    Last updated: 30+ days ago • Promoted
    SCRM Analyst

    SCRM Analyst

    ManTech • Fort Meade, MD, US
    Full-time
    MANTECH seeks a motivated, career and customer-oriented.Supply Chain Risk Management Analyst.Responsibilities include but are not limited to : . Review all-source intelligence products and industry tr...Show more
    Last updated: 5 days ago • Promoted
    QA Analyst - Remote

    QA Analyst - Remote

    TradeJobsWorkForce • 22205 Arlington, VA, US
    Remote
    Full-time
    QA Analyst Remote Job Duties : • Partner with the product and engineering team to understand project o...Show more
    Last updated: 30+ days ago • Promoted
    Quality Control Analyst

    Quality Control Analyst

    VirtualVocations • Rockville, Maryland, United States
    Full-time
    A company is looking for a Quality Control Analyst to conduct audits across their loan portfolio.Key Responsibilities Execute comprehensive audits of loan files, including pre-funding and post-cl...Show more
    Last updated: 30+ days ago • Promoted