Business Intelligence Architect

Position Overview


Position Summary
The Data & Reporting Analyst will join the Integrated Data & Analytics Section (ID&AS) to support complex data initiatives for client's Medicaid and FoodShare programs. Working alongside ID&AS staff and contracted MMIS vendors, this role is responsible for the end-to-end lifecycle of data reporting-from gathering requirements with stakeholders to the technical development and implementation of ad hoc and standard reports. The ideal candidate bridges the gap between policy and technology, ensuring all data outputs are compliant with state and federal regulations.

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 client 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:
Excellent interpersonal communication skills
Excellent organization and time management skills
Providing detailed status report updates to Project Manager
Experienced with business process reengineering and identifying new applications of technology to business problems to make business more effective
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:
Analyze and document the current state of existing data repositories and the associated data reporting environments
Assess end-to-end data integration workflows and systems operational dependencies
Create and maintain technical documentation such as data flows, interface control documents, entity relationship diagrams and data catalogs
Assist in clearly defining the future state of enterprise data analytics capabilities
Ability to grasp technical concepts (such as Data Warehouse, ETL, Transactional Batch Processing, Data Schemas, Secured Transport, etc.) and communicate to System Delivery Teams
Gather and analyze end user requirements for new and existing data loads for the enterprise data warehouse
Create technical specifications to load data from disparate source systems into the enterprise data warehouse for reporting and analysis
Experience working in system environments with relational databases (either SAS, MySQL, Oracle, MS SQL, DB2, etc.)
Knowledge of data reporting platforms (either MS SSRS, MS Access, SAS, etc.)
Knowledge of data visualization tools (either SAS Visual Analytics, Power BI, Tableau, etc.)

Industry skills and experience
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

Notes:

Monday through Friday, 8:00 a.m. 5:00 p.m.
This position is remote and work must be performed within the State. Selected candidate will be required to be onsite
Remote

VIVA is an equal opportunity employer. All qualified applicants have an equal opportunity for placement, and all employees have an equal opportunity to develop on the job. This means that VIVA will not discriminate against any employee or qualified applicant on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.