Business Intelligence Architect III

Key Responsibilities 

1. Data Analysis and Report Development 

· Perform analysis, development, preparation, implementation, and evaluation of complex standard and ad hoc reports that support data collection, access, changes, retrieval and retention related to Medicaid and FoodShare programs  

· Determine report specifications and assist in preparing necessary queries to obtain required data for reports to complete technical queries using SQL/SAS to extract and manipulate data from MES and IM databases. 

· Perform rigorous testing and evaluation of report outputs to ensure accuracy and data integrity. 

2. Stakeholder Engagement & Requirements Gathering 

· Collaborate with internal and external stakeholders, management staff, and other colleagues to define reporting requirements and refine system modifications. 

· Translate complex policy language into user-friendly logic flows and technical specifications. 

· Review design layouts and file structures, providing recommendations for resource allocation and optimization. 

3. Regulatory Compliance & Policy Integration 

· Review and analyze changes in federal and state rules and regulations for impact on policy and processes, including system software support, especially those necessary for reporting.  

· Implement necessary revisions to reporting frameworks to ensure 100% compliance with shifting regulations. 

· Evaluate standard reports for cost improvements and operational efficiencies. 

4. Documentation & Project Leadership 

· Prepare written comprehensive system and data requirements, flowcharts, and draft formal work directives for vendors. 

· Develop end-user documentation, program manuals, and user guides to ensure seamless adoption of reporting tools. 

· Lead small to medium-sized project teams through problem-solving and implementation phases. 

· General skills and experience:

o Excellent interpersonal communication skills

o Excellent organization and time management skills

o Providing detailed status report updates to Project Manager

o Experienced with business process reengineering and identifying new applications of technology to business problems to make business more effective

o Experience with business analyst and testing industry standards, current and emerging technologies, business process mapping, and reengineering

· Business analyst skills and experience:

o Facilitation

§ Efficiently plan and execute meetings

§ Establish agenda and set meeting objectives

§ Document and distribute meeting decisions and action items

§ Timely follow-up on all action items

§ Document issues and providing to Project Manager

§ Formulate systems to parallel overall business strategies

§ Prepare Risk Identification

§ Prepare Fiscal Analysis (i.e. cost/benefit, ROI, buy/build)

§ Relies on experience and judgment to plan and accomplish goals. Independently, performs a variety of complicated tasks. A wide degree of creativity and latitude is expected.

o Elicitation

§ Efficiently and effectively divine business requirements from business area staff

o Documentation

§ Use established business requirement templates

§ Produce clear and concise requirements documentation

§ Create traceability to RFP requirements

o Validation

§ Effectively and efficiently review and validate documented business requirements with business area staff and owners

§ Review, analyze, and evaluate business systems and user needs

o Testing

§ Document clear test plans and create test cases that are traceable to business, functional, non-functional, and transition requirements

§ Effectively and efficiently executes test plan and document test results

§ Document defects and collaborates with other business analysts and developers to resolve and execute regression testing

§ Facilitate review of test results with project stakeholders

· Data analytics skills and experience:

o Analyze and document the current state of existing data repositories and the associated data reporting environments

o Assess end-to-end data integration workflows and systems operational dependencies

o Create and maintain technical documentation such as data flows, interface control documents, entity relationship diagrams and data catalogs

o Assist in clearly defining the future state of enterprise data analytics capabilities

o Ability to grasp technical concepts (such as Data Warehouse, ETL, Transactional Batch Processing, Data Schemas, Secured Transport, etc.) and communicate to System Delivery Teams

o Gather and analyze end user requirements for new and existing data loads for the enterprise data warehouse

o Create technical specifications to load data from disparate source systems into the enterprise data warehouse for reporting and analysis

o Experience working in system environments with relational databases (either SAS, MySQL, Oracle, MS SQL, DB2, etc.)

o Knowledge of data reporting platforms (either MS SSRS, MS Access, SAS, etc.)

o Knowledge of data visualization tools (either SAS Visual Analytics, Power BI, Tableau, etc.)

· Industry skills and experience

o 3 to 5 years of experience performing a business analyst role supporting State Medicaid and MMIS, or similar health care business and system in one or more of the following functional areas:

§ Provider management

§ Member (recipient) eligibility and enrollment

§ Claims and encounters

§ Benefit plan administration

§ Service authorization

§ Financial services

§ Decision support system/data warehouse

§ Pharmacy benefit management

§ Program integrity and utilization management

Certified Business Analysis Professional (CABP) preferred