FEi Systems
Data Business Analyst - Migration and Integration Analyst (Remote)
FEi Systems, New York, New York, United States
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, our solutions are improving the lives of millions of people. We're seeking a skilled and detail-oriented Business Analyst with expertise in SQL, data mapping, and systems integration to support our data migration and integration initiatives. The ideal candidate will have hands-on experience with both real-time and batch-mode integration approaches and will play a critical role in validating the accuracy of migrated and integrated data through robust testing and reporting.
Principle Responsibilities :
Facilitate elicitation session(s) with a large group of stakeholders to gather, analyze, and document data migration and integration requirements. Develop and maintain source-to-target data mapping documents across systems and environments according to the standards and templates required by the customer. Support and coordinate data migration efforts, including data extraction, transformation, loading (ETL), and validation processes. Analyze large datasets using SQL to identify data quality issues, trends, and transformation needs. Perform detailed data validation and testing, including development of test plans, test cases, aa well as reconciliation of source and target system data. Create and deliver post-migration reports to verify data completeness, accuracy, and success metrics for each migration cycle. Design and support real-time (API-based, event-driven) and batch-mode (scheduled/ETL) integration workflows. Document integration logic, data flows, business rules, and test results according to the standards and templates required by the customer to support the SDLC, ongoing operations and compliance audits. Support customer user acceptance testing (UAT) by assisting them in validating migrated and integrated data. Work cross-functionally with developers, data architects, quality analysts, and business owners to ensure successful end-to-end delivery. Understand and communicate information on the requirements development and management process to the project team Use development, operation, planning and execution software such as ADO to manage the lifecycle of requirements. Conduct quality review walkthroughs of data migration and integration requirements documentation and test results. Operate as a spokesperson for the business departments as they interact with Customer groups to determine appropriate computer-related solutions to business problems. Elicit and document existing business models and workflows with the applicable customer SMEs. Deliver informative, well-organized presentations. Provide client support and consultation for IT issues and make recommendations on applicable technology. Provide post project implementation support. Perform other duties as assigned. Required Skills/Experience :
A Bachelor's degree from an accredited college or university with a major in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline or three (3) years of equivalent experience in a related field. At least three (3) years of experience in Software Development Life Cycle with direct focus in the following:
Large-scale system data migration/transformation, including data mapping, ETL processes, and data quality validation Gap analysis Customer-facing requirements elicitation and definition Writing business rules, authoring use cases, and designing/documenting data flows or data streams Data models, data diagrams, SQL Real-time, near real-time, scheduled, and event-driven system integrations Digital document management, identification, retention and transference
Excellent communication, prioritization, self-management, coordination and organizational skills Experience owning, analyzing, developing, and presenting software solutions to business problems Preferred Experience :
Experience in a healthcare-related information system is strongly preferred. Experience and expertise in at least two of the following types of systems:
Document Management System Financial System Infrastructure Support Management Reporting Procurement System Project/Program/Portfolio Management Systems
Experience supporting and leading efforts where a SDLC of Waterfall, Agile, and Hybrid methodologies were employed Solid understanding of current and emerging IT products, services, processes, and methodologies along with a continuing understanding of business functions and processes Experience using one or more data migration tools Preferred Tools and Technologies :
SQL Server, Oracle, or other RDBMS API tools and data exchange formats (e.g., Postman, JSON, XML) Reporting tools (e.g., Power BI, Excel, SSRS) Project and test management tools (e.g., ADO, SharePoint)
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
Equal Opportunity Employer This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.
Principle Responsibilities :
Facilitate elicitation session(s) with a large group of stakeholders to gather, analyze, and document data migration and integration requirements. Develop and maintain source-to-target data mapping documents across systems and environments according to the standards and templates required by the customer. Support and coordinate data migration efforts, including data extraction, transformation, loading (ETL), and validation processes. Analyze large datasets using SQL to identify data quality issues, trends, and transformation needs. Perform detailed data validation and testing, including development of test plans, test cases, aa well as reconciliation of source and target system data. Create and deliver post-migration reports to verify data completeness, accuracy, and success metrics for each migration cycle. Design and support real-time (API-based, event-driven) and batch-mode (scheduled/ETL) integration workflows. Document integration logic, data flows, business rules, and test results according to the standards and templates required by the customer to support the SDLC, ongoing operations and compliance audits. Support customer user acceptance testing (UAT) by assisting them in validating migrated and integrated data. Work cross-functionally with developers, data architects, quality analysts, and business owners to ensure successful end-to-end delivery. Understand and communicate information on the requirements development and management process to the project team Use development, operation, planning and execution software such as ADO to manage the lifecycle of requirements. Conduct quality review walkthroughs of data migration and integration requirements documentation and test results. Operate as a spokesperson for the business departments as they interact with Customer groups to determine appropriate computer-related solutions to business problems. Elicit and document existing business models and workflows with the applicable customer SMEs. Deliver informative, well-organized presentations. Provide client support and consultation for IT issues and make recommendations on applicable technology. Provide post project implementation support. Perform other duties as assigned. Required Skills/Experience :
A Bachelor's degree from an accredited college or university with a major in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline or three (3) years of equivalent experience in a related field. At least three (3) years of experience in Software Development Life Cycle with direct focus in the following:
Large-scale system data migration/transformation, including data mapping, ETL processes, and data quality validation Gap analysis Customer-facing requirements elicitation and definition Writing business rules, authoring use cases, and designing/documenting data flows or data streams Data models, data diagrams, SQL Real-time, near real-time, scheduled, and event-driven system integrations Digital document management, identification, retention and transference
Excellent communication, prioritization, self-management, coordination and organizational skills Experience owning, analyzing, developing, and presenting software solutions to business problems Preferred Experience :
Experience in a healthcare-related information system is strongly preferred. Experience and expertise in at least two of the following types of systems:
Document Management System Financial System Infrastructure Support Management Reporting Procurement System Project/Program/Portfolio Management Systems
Experience supporting and leading efforts where a SDLC of Waterfall, Agile, and Hybrid methodologies were employed Solid understanding of current and emerging IT products, services, processes, and methodologies along with a continuing understanding of business functions and processes Experience using one or more data migration tools Preferred Tools and Technologies :
SQL Server, Oracle, or other RDBMS API tools and data exchange formats (e.g., Postman, JSON, XML) Reporting tools (e.g., Power BI, Excel, SSRS) Project and test management tools (e.g., ADO, SharePoint)
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
Equal Opportunity Employer This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.