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