Technical Business Analyst

AppLab Systems, Inc; Quincy (IN); Hybrid; USD 85,000 - 110,000; Full time

Job summary

AppLab Systems, Inc. is seeking a Technical Business Analyst for a 6–12 month hybrid engagement in Quincy, MA. The role focuses on planning and developing a deep understanding of business processes, data flows, and system integrations. You will drive requirements, data mapping, and ETL/EDI solutions with stakeholders and vendors.

The ideal candidate has 5+ years BA experience, strong SQL skills, and working knowledge of SDLC and data security for healthcare data (PII/PHI).

Qualifications

• Bachelor's Degree in IT/CS or related field.
• 5+ years of business analysis and data integration.
• Experience with SDLC and healthcare data security (PII/PHI).
• Proficient in SQL and data mapping, ETL/EDI knowledge.
• Experience with Jira and Rational Quality Manager (RQM).

Responsibilities

• Plan and develop functional decomposition to understand business processes and data flows.
• Gather, document, and analyze data sources, schemas, and master interfaces for integration needs.
• Lead requirement gathering, design solutions, and assist in test script development.
• Collaborate with teams to integrate Webservices/ETL/EDI and ensure data quality and traceability.

Skills

Stakeholder comms

SQL queries

Data mapping

ETL/EDI

Gathers requirements

SDLC knowledge

Education

Bachelor's Degree in IT/CS

Tools

Jira

RQM

EDI tools

Job description

Quincy, MA/Hybrid

Duration: 6 - 12 Months with a possible extension

W2 Only

Job description :-

Job Duties: (Detailed list of Responsibilities):

Core Business Analysis Skills

Plan and Develop (Functional Decomposition) a deep understanding of the business environment, its leadership, its business processes, its system processes, its data flows, data sources & integrations.

Direct Client: EOHHS (State of MA)

Title: Technical Business Analyst

Location: Quincy, MA/Hybrid

Duration: 6 - 12 Months with a possible extension

W2 Only

Job description :-

Job Duties: (Detailed list of Responsibilities):

Core Business Analysis Skills

Plan and Develop (Functional Decomposition) a deep understanding of the business environment, its leadership, its business processes, its system processes, its data flows, data sources & integrations.

• Manage "document and "requirement traceability within the business, system, data, and technical domains; through common requirement documents (BRD, TRD, DRD, SAD) and ensure proper adherence with defined EOTSS\EOHHS Policies and Standards.
• Gather, document, and analyze the many data schemas and master interface control documents "sources to target inventory all in support of the businesses data integration needs.
• Lead and facilitate requirement gathering, document creation, solution design, and when required help develop appropriate user & system test scripts which require negative test scenarios.
• Maintain and enforce through proper change control; the businesses document repository to ensure proper business impact and dependencies are understood when changes are required which may have business or technical impacts. Ensure changes and updates are maintained.
• Present findings and/or recommendations as required to internal and external stakeholders.
• Provide subject-matter expertise in data discovery, mapping, analysis, and report creation using native database discovery and documenting tools to help improve operational efficiency, accuracy and consistency.
• Must have proficiency in and with SQL & SQL queries, stored procedures, webservices, database documentation toolsets.
• Experience in data quality & integrity management processes including merging and analyzing disjointed data sources to formulate business insights (example DIFF Comparisons)
• Define & document data mapping, validations, and transformation rules to facilitate the exchange of data between different systems using common Webservices, ETL and EDI standards.
• Perform or define data extraction, mapping, analysis, and quality assurance activities to assist in program evaluation, survey operations, and cost assessment decision making; develop and deliver presentations with insights and recommendations for leadership.
• Design sampling plans, data flows, data processing, and/or reports and briefing presentations to optimize the information gained from data collections.
• Create detailed technical documentation, including data mappings, transformation rules, data dictionaries, and system interfaces, to facilitate future reference and knowledge transfer, ensuring alignment between stakeholders and development teams product goals and objectives.
• Lead and oversee the end-to-end business process & data Client and mapping in the full Integration lifecycle, from concept to launch, demonstrating project management skills and technical expertise.
• Work closely with business, project management, development and testing teams to capture and/or integrate Webservices/ETL/EDI solutions with existing or new systems and applications, ensuring smooth data flow and minimal disruption to operations.
• Adhere to EOTSS\EOHHS Privacy and Security policies when processing confidential data and ensure updates are made in information guidelines.
• Evaluate and ensure proper change control and updates to source production systems documentation and integration guidelines.
• Plan and execute comprehensive testing strategies to validate the accuracy and completeness of ETL/EDI processes, resolving any issues that arise during testing if so required.
• Collaborate with cross-functional teams to gather, analyze and design business requirements, translating them into clear and comprehensive technical product specifications, and user stories.
• Provide quality assurance of data exchanges, working with developers and quality assurance analysts as necessary.
• Work with QA technical team during data setup for performance testing.
• Work with SQA Manager and across project teams to ensure testing completion meets project deadlines.
• Identify and prioritize required features based on business goals, user feedback, and technical constraints, driving product strategy and innovation.
• Monitor key performance indicators (KPIs) and metrics, conduct regular priority and performance reviews to identify areas for improvement and growth.
• Proactively manage risks and dependencies, employing problem-solving skills to overcome obstacles and ensure successful project delivery.
• Facilitate effective communication between technical teams and non-technical stakeholders, translating complex technical concepts into accessible language.
• Quickly gain a deep understanding of our internal software development & testing methodologies.
• Act as a subject matter expert, providing guidance and mentorship to junior team members, enhancing their analytical and technical skills.
• Assessing tests scripts and implementing plans on new, upgrades, or enhancement required
• Training end-users in areas of expertise as required.

Data Analysis & Mapping Skills

• Provide subject-matter expertise in data discovery, mapping, analysis, and report creation using native database discovery and documenting tools to help improve operational efficiency, accuracy and consistency.
• Must have proficiency in and with SQL & SQL queries, stored procedures, webservices, database documentation toolsets.
• Experience in data quality & integrity management processes including merging and analyzing disjointed data sources to formulate business insights (example DIFF Comparisons)
• Define & document data mapping, validations, and transformation rules to facilitate the exchange of data between different systems using common Webservices, ETL and EDI standards.
• Perform or define data extraction, mapping, analysis, and quality assurance activities to assist in program evaluation, survey operations, and cost assessment decision making; develop and deliver presentations with insights and recommendations for leadership.
• Design sampling plans, data flows, data processing, and/or reports and briefing presentations to optimize the information gained from data collections.
• Create detailed technical documentation, including data mappings, transformation rules, data dictionaries, and system interfaces, to facilitate future reference and knowledge transfer, ensuring alignment between stakeholders and development teams product goals and objectives.
• Lead and oversee the end-to-end business process & data Client and mapping in the full Integration lifecycle, from concept to launch, demonstrating project management skills and technical expertise.
• Work closely with business, project management, development and testing teams to capture and/or integrate Webservices/ETL/EDI solutions with existing or new systems and applications, ensuring smooth data flow and minimal disruption to operations.
• Adhere to EOTSS\EOHHS Privacy and Security policies when processing confidential data and ensure updates are made in information guidelines.
• Evaluate and ensure proper change control and updates to source production systems documentation and integration guidelines.

Testing Skills

• Plan and execute comprehensive testing strategies to validate the accuracy and completeness of ETL/EDI processes, resolving any issues that arise during testing if so required.
• Collaborate with cross-functional teams to gather, analyze and design business requirements, translating them into clear and comprehensive technical product specifications, and user stories.
• Provide quality assurance of data exchanges, working with developers and quality assurance analysts as necessary.
• Work with QA technical team during data setup for performance testing.
• Work with SQA Manager and across project teams to ensure testing completion meets project deadlines.

REQUIRED SKILLS (Special Skill Set, Abilities, Knowledge)

• Broad knowledge of business analysis techniques in creating requirements and design documents
• Broad technical knowledge and experience supporting a wide range of applications, data processes, and technologies (e.g. Java, .NET, Oracle, SQL Server, and Cloud).
• Excellent technical skills, including experience with ETL/EDI tools (e.g XML Spy, Database Spy, MapForce, ERWin, Informatica PowerCenter, IBM DataStage, etc ).
• Prior experience with Jira, SQL Queries, Rational Quality Manager (RQM) and ADA compliance.
• Strong familiarity with NIST security standards and working with PII and PHI data.
• Proven understanding and knowledge of software development life cycle (SDLC).
• 5+ years of experience in business analysis and data integration.
• Experience managing and working with 3rd party vendors.
• Experienced in use cases and testing methodologies including functional, systems, integration, performance, and UAT.
• Demonstrated ability to conduct detailed planning, perform risk assessments, and successfully mitigate risks.
• Ability to develop and maintain effective relationships with management, end users, project team members, and vendors. Excellent customer service skills.
• Excellent oral and written communication and presentation skills.
• Proficient in using Microsoft Office suite, Visio, MS Project, other project management and collaboration tools.
• Excellent problem-solving skills.

QUALIFICATIONS (Education, Years' Experience, Certificates)

• Bachelor's Degree in computer science, Information Systems, Business Administration or other related field, or equivalent work experience.
• Professional certification in IIBA, or Six Sigma, or TOGAF preferred or a minimum of 5 years of extensive hands-on experience in IT application implementations or systems support.
• At least 5 years of experience working in a Business, System, and Data Analysis, or other related experience in an IT healthcare environment.
• At least 3 years of business analysis and data analysis or related experience within Business application implementations or IT software development project(s).
• Excellent technical skills, including experience with data analysis and visualization tools.
• Excellent writing and communication skills.
• Excellent presentation skills.
• Ability to work independently and as part of a team.