Sr Business Analyst

DUE DATE : 10 / 3 / 2025

Duration of engagement : 30 months

Location : Menands, NY (50% Onsite)

Targeted start : 11 / 7 / 2025

Day-to-day tasks :

• Work as a liaison among stakeholders in order to elicit, communicate and validate the requirements for changes to current business reporting requirements and policies for the development of new operational reports and analytics.
• Conduct data analysis of business and user needs and developing business requirements documents in accordance with the requirements and protocol of the ITS EIM Division during multiple project phases to convert the numerous Oracle Portals, Business Areas, and Discoverer Workbooks to the current Oracle analytical reporting platform.
• Create business documentation (Business Requirement documents, use cases, swim lanes, process documentation) that detail the Business Intelligence reporting requirements and deliverables for reports, dashboards, and ad hoc tools.
• Work closely with Data Warehouse and Business Intelligence technical team members and various OMH Business Owners to create Business Requirement documentation and to communicate the business requirements to the technical team for development of logical and physical dimensional data model reporting requirements.
• Collaborate with data modelers, ETL developers, programmers and the business owners to translate report requirements, provide clarification of business rules, prioritize development, obtain signoff and ensure successful delivery of accurate end user reporting requirements
• Create and execute test scripts, scenarios, and test plans to validate initial business requirements and report output through the DEV, QA and PROD migrations testing for accuracy and sign off on deliverables.
• Assist in providing training & end user support for OMH staff utilizing the Analytics tool.

Business Analyst :

Projects : Electronic Health Record (EHR) application upgrade project; Veterans Health Information Systems and Technology Architecture (VistA) / Pharmacy Management; State Facility Enterprise Reporting (SFER) for Office of Mental Health

Center for Human Resource Management (CHRM); Center for Human Resource Management (CHRM) Overtime(OT); Outpatient Staff Productivity (OPP)

Analyzes an organization or business domain (real or hypothetical) and documents its business or processes or systems, assessing the business model or its integration with technology with distinct deliverables to a solution.

Expert 84+ months : Candidate is able to provide guidance to large teams and / or has extensive industry experience and is considered at the top of his / her field.

1. 84 months data analytical background, experience with business intelligence tools to design reports( for example OBIEE, SQL, Microsoft Excel) or data analysis business solutions for operational reports.

2. 84 months experience in quality assurance testing of reports, SQL analytics, Oracle SQL knowledge, managing defects, development of report user acceptance documents including test plans.

3. 60 months experience soliciting report requirements, end user documentation development, specifically business reporting requirements documents (BRDs), use cases, report mockups, wire frames, and flow diagrams

4. 60 months experience with all phases of support specifications development including design, testing and maintenance of reports.

5. 60 months experience with developing end user training materials for use of Analytics, Dashboards, and / or Business Intelligence or application reports.

6. 60 months experience developing and implementing system and work-flow processes in a Business Intelligence environment.

7. Bachelor's degree in business intelligence, information science, criminal justice, health science, computer science, mathematics, or public / business administration.

8. CBAP (Certified Business Analysis Professional) certification by the International Institute of Business Analysis (IIBA).

Required Documentation

Resume

Copy of Candidate Identification (i.e., driver's license and / or passport and Visa if applicable)

Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.)