Must be WI Resident only || Business Intelligence Architect || Once a Month Onsite at Madison, WI

Key Responsibilities with 3 to 5 years of experience:

• Data Analysis and Report Development
• Stakeholder Engagement and Requirements Gathering
• Regulatory Compliance & Policy Integration
• Documentation & Project Leadership

Nice to have skills:

• 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

Key Responsibilities

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.

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.

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.

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:
• 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.
• Elicitation
• Efficiently and effectively divine business requirements from business area staff
• Documentation
• Use established business requirement templates
• Produce clear and concise requirements documentation
• Create traceability to RFP requirements
• 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
• 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