Business Analyst

The Senior Technical Business Analyst will report to the Assistant CIO (ACIO) of Executive Office of Aging & Independence- AGE, The Commission for the Blind- MCB, The Commission for the Deaf and Hard of Hearing- MCDHH, and the Office For Refugees and Immigrants- ORI and\or whom they delegate.

Job Overview

The MCDHH Information Technology Office is seeking a highly motivated Senior Technical Business Analyst with expertise in supporting full software development and data management lifecycles on projects. In supporting the types of projects across MCDHH, the Senior Technical Business Analyst will play a critical role in ensuring the business process, technical and data architectures are well documented and maintained through strong change control.

The Senior Technical Business Analyst will continually look to enhance these processes through discovery, diagramming, documentation, mapping, analysis, and in recommending improvements. Utilizing common IIBA Business Analysis frameworks, toolsets, and\or methods will ensure quality improvements, business continuity, and internal knowledge repository which is paramount.


The Senior Business Analyst roles will grow as their knowledge of the business grows, the candidate is to acquire this needed knowledge quickly and possess excellent technical, writing, modelling, data analysis, and presentation skills. They must have experience of working with SQL/ETL/EDI tools and in presenting complex problems simply to executive management. Once a trusted expert you will be called upon to participate in recommending current and future strategy for business and technical leadership.

The candidate is required to have project management experience, able to plan agenda and manage meetings, have prior experience in working within governance structures, in keeping minutes, conducting peer reviews, maintaining project risks and defects (In excel, Jira or other tracking system), reporting on project status, in job and time estimating, and working in a matrixed but highly collaborative environment. This position is anticipated to be a long-term engagement and is currently a hybrid remote position with the candidate able to come into the Boston MA office when requested.

Job Duties: (Detailed list of Responsibilities):

Core Business Analysis kills

• 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.

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 discover 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.
• 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.

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.