Business Intel Architect III

Codetech•Madison, WI
•Remote

About The Position

The Data & Reporting Analyst will join the Integrated Data & Analytics Section (ID&AS) to support complex data initiatives for Medicaid and FoodShare programs. Working with ID&AS staff and contracted MMIS vendors, the role handles the end-to-end lifecycle of data reporting, from gathering stakeholder requirements through technical development and implementation of ad hoc and standard reports. The role connects policy and technology and ensures that data outputs comply with state and federal regulations. The position covers data analysis and report development, stakeholder engagement and requirements gathering, regulatory compliance, documentation, and project leadership. It also includes business analysis and testing activities, data analytics and technical documentation, and work involving enterprise data environments, relational databases, reporting platforms, and data visualization tools. Candidates must be Wisconsin residents or willing to relocate to Wisconsin at their own expense before starting. The position may be performed 100% remotely within Wisconsin.

Requirements

  • Three to five years of experience performing a business analyst role supporting State Medicaid and MMIS, or a similar health care business and system, in one or more of the following areas: provider management; member eligibility and enrollment; claims and encounters; benefit plan administration; service authorization; financial services; decision support system/data warehouse; pharmacy benefit management; or program integrity and utilization management.
  • Experience with SQL and SAS for extracting and manipulating data from MES and IM databases.
  • Experience working in system environments with relational databases such as SAS, MySQL, Oracle, MS SQL, or DB2.
  • Business analysis skills, including facilitation, requirements elicitation and documentation, validation, testing, and traceability to RFP requirements.
  • Experience with business process reengineering and identifying technology applications that improve business effectiveness.
  • Experience with business analyst and testing standards, current and emerging technologies, business process mapping, and reengineering.
  • Ability to analyze data repositories, reporting environments, data integration workflows, and system dependencies.
  • Ability to create technical data documentation and specifications, including data flows, interface control documents, entity relationship diagrams, data catalogs, and data-load specifications.
  • Ability to understand technical concepts such as data warehouses, ETL, transactional batch processing, data schemas, and secured transport, and communicate them to System Delivery Teams.
  • Excellent interpersonal communication, organization, and time-management skills.
  • Ability to provide detailed status updates to a Project Manager and independently accomplish complicated tasks using judgment and experience.
  • Wisconsin residency or willingness to relocate to Wisconsin at the candidate's own expense before starting.

Nice To Haves

  • Certified Business Analysis Professional (CABP) certification.
  • Knowledge of data reporting platforms such as MS SSRS, MS Access, or SAS.
  • Knowledge of data visualization tools such as SAS Visual Analytics, Power BI, or Tableau.

Responsibilities

  • Analyze, develop, prepare, implement, and evaluate complex standard and ad hoc reports supporting Medicaid and FoodShare data collection, access, changes, retrieval, and retention.
  • Determine report specifications and prepare queries to obtain required data; use SQL and SAS to extract and manipulate data from MES and IM databases.
  • Test and evaluate report outputs to ensure accuracy and data integrity.
  • Collaborate with stakeholders, management, colleagues, and external parties to define reporting requirements and refine system modifications.
  • Translate policy language into user-friendly logic flows and technical specifications.
  • Review report design layouts and file structures and recommend resource allocation and optimization.
  • Analyze changes in federal and state rules and regulations for their impact on policy, processes, system software support, and reporting.
  • Revise reporting frameworks to maintain compliance with changing regulations and evaluate standard reports for cost improvements and operational efficiency.
  • Prepare system and data requirements, flowcharts, and formal work directives for vendors.
  • Develop end-user documentation, program manuals, and user guides.
  • Lead small to medium-sized project teams through problem-solving and implementation.
  • Plan and facilitate meetings, establish agendas and objectives, document decisions, action items, and issues, and follow up on action items.
  • Prepare risk identification and fiscal analyses, including cost-benefit, ROI, and buy/build assessments.
  • Elicit, document, validate, and trace business requirements, including reviewing and evaluating business systems and user needs.
  • Create test plans and traceable test cases; execute tests, document results and defects, coordinate defect resolution and regression testing, and facilitate stakeholder review of test results.
  • Analyze current data repositories and reporting environments, assess end-to-end data integration workflows and operational dependencies, and document data flows, interface control documents, entity relationship diagrams, and data catalogs.
  • Help define future-state enterprise data analytics capabilities and communicate technical concepts to System Delivery Teams.
  • Gather and analyze requirements for enterprise data warehouse loads and create technical specifications for loading disparate source-system data for reporting and analysis.
  • Provide detailed status updates to the Project Manager.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service