Business Intelligence Architect III. Location: Madison, WI Need to Relocate

Business Intelligence Architect III.

Location: Madison, WI

Need to Relocate

Key Responsibilities with 3 to 5 years of experienc

e:1. Data Analysis and Report Developme

nt2. Stakeholder Engagement and Requirements Gatheri

ng3. Regulatory Compliance & Policy Integrati

on4. Documentation & Project Leadersh

ip
Nice to have skil

ls:· Experienced with business process reengineering and identifying new applications of technology to business problems to make business more effect

ive· Experience with business analyst and testing industry standards, current and emerging technologies, business process mapping, and reengineer

ing
Position Summary: The Data & Reporting Analyst will join the Integrated Data & Analytics Section (ID&AS) to support complex data initiatives for Wisconsin’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 regulati

ons.
Key Responsibil

1. itiesData Analysis and Report Develo

• pmentPerform 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 pro
• gramsDetermine 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 datab
• ases.Perform rigorous testing and evaluation of report outputs to ensure accuracy and data integ

1. rity.Stakeholder Engagement & Requirements Gath

• eringCollaborate with internal and external stakeholders, management staff, and other colleagues to define reporting requirements and refine system modificat
• ions.Translate complex policy language into user-friendly logic flows and technical specificat
• ions.Review design layouts and file structures, providing recommendations for resource allocation and optimiza

1. tion.Regulatory Compliance & Policy Integr

• ationReview and analyze changes in federal and state rules and regulations for impact on policy and processes, including system software support, especially those necessary for repor
• ting.Implement necessary revisions to reporting frameworks to ensure 100% compliance with shifting regulat
• ions.Evaluate standard reports for cost improvements and operational efficien

1. cies.Documentation & Project Leade

• rshipPrepare written comprehensive system and data requirements, flowcharts, and draft formal work directives for ven
• dors.Develop end-user documentation, program manuals, and user guides to ensure seamless adoption of reporting t
• ools.Lead small to medium-sized project teams through problem-solving and implementation ph
• ases.General skills and experi
• ence:Excellent interpersonal communication s
• killsExcellent organization and time management s
• killsProviding detailed status report updates to Project Ma
• nagerExperienced with business process reengineering and identifying new applications of technology to business problems to make business more effe
• ctiveExperience with business analyst and testing industry standards, current and emerging technologies, business process mapping, and reengine
• eringBusiness analyst skills and experi
• ence:Facilit

• ation
  Efficiently plan and execute me
• etingsEstablish agenda and set meeting obje
• ctivesDocument and distribute meeting decisions and action
• itemsTimely follow-up on all action
• itemsDocument issues and providing to Project M
• anagerFormulate systems to parallel overall business stra
• tegiesPrepare Risk Identifi
• cationPrepare 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 exp
• ected.Elici
• tationEfficiently and effectively divine business requirements from business area
• staffDocumen
• tationUse established business requirement tem
• platesProduce clear and concise requirements documen
• tationCreate traceability to RFP requir
• ementsVali
• dationEffectively and efficiently review and validate documented business requirements with business area staff and
• ownersReview, analyze, and evaluate business systems and user
• needsT
• estingDocument clear test plans and create test cases that are traceable to business, functional, non-functional, and transition requir
• ementsEffectively and efficiently executes test plan and document test r
• esultsDocument defects and collaborates with other business analysts and developers to resolve and execute regression t
• estingFacilitate review of test results with project stakeh
• oldersData analytics skills and exper
• ience:Analyze and document the current state of existing data repositories and the associated data reporting enviro
• nmentsAssess end-to-end data integration workflows and systems operational depend
• enciesCreate and maintain technical documentation such as data flows, interface control documents, entity relationship diagrams and data ca
• talogsAssist in clearly defining the future state of enterprise data analytics capabi
• litiesAbility to grasp technical concepts (such as Data Warehouse, ETL, Transactional Batch Processing, Data Schemas, Secured Transport, etc.) and communicate to System Delivery
• TeamsGather and analyze end user requirements for new and existing data loads for the enterprise data war
• ehouseCreate technical specifications to load data from disparate source systems into the enterprise data warehouse for reporting and an
• alysisExperience 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 expe
• rience3 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 mana
• gementMember (recipient) eligibility and enro
• llmentClaims and enco
• untersBenefit plan administ
• rationService authori
• zationFinancial se
• rvicesDecision support system/data war
• ehousePharmacy benefit mana
• gementProgram integrity and utilization mana
• gementCertified Business Analysis Professional (CABP) pre