BI Developer III

Job Summary

The Business Intelligence (BI) Developer III serves as a technical expert responsible for designing, developing, and maintaining complex analytics solutions that support data-driven decision-making across the School of Medicine and Public Health (SMPH). This role leads advanced BI initiatives, develops scalable and automated reporting solutions, and ensures the integrity, consistency, and reliability of data assets.

The BI Developer III works closely with stakeholders across finance, human resources, facilities, and administrative domains to translate complex business needs into actionable analytics. This role serves as a bridge between technical and non-technical audiences, translating complex data into clear, actionable insights while helping cultivate a culture of data-informed decision-making across SMPH.

Activities will include developing and maintaining data visualization dashboards and reports, troubleshooting issues with reports, administration of the report environment, building and optimizing data models, collaborating with stakeholders, and supporting data governance. In addition to hands‑on development, this position provides technical leadership, mentorship, and guidance in BI best practices, data modeling, and analytics architecture.

Work may be performed remotely at an off‑site location, but requires approximately six days on‑site per year.

• Provides coaching to enterprise BI developers in BI/visualization development best practices and data governance standards. Reviews and assesses BI products for alignment with development standards as part of governance approval and production release. Contributes to the development and documentation of BI standards.
• Makes accurate estimations based on scope and requirements, BI developer resource effort, and timing to design, build, test, and release BI developer solutions. Understands and communicates possible risks and mitigations to estimated timelines.
• Works with multiple enterprise data domains/sets and using advanced expertise in enterprise‑level tools, matches the right data presentation modality to user requirements. Employs advanced expertise in data visualization and storytelling to design, prototype, test, and deliver accurate, on‑going enterprise solutions for low‑to‑medium‑scale user populations.
• Partners with a business analyst and/or business subject matter experts (SMEs) to elicit requirements from a broader set of enterprise stakeholders. Documents and presents complex options through mock‑ups and prototypes to these audiences.
• Develops and maintains complex design/build documentation for approval by business SMEs and project team leads. Designs and builds embedded documentation in BI products to support end‑user understanding. Reviews and provides input to communications and/or training resources on end‑user‑facing content.

School of Medicine and Public Health, Department of Information Technology, Business Analytics.

Starting salary is $85,000 annually, negotiable based on experience and qualifications.

Benefits include generous vacation, holidays, and sick leave; competitive insurance and savings accounts; retirement benefits.

• 5 or more years of hands‑on experience in BI development in visualization tools such as Power BI, Qlik, or Tableau.
• Experience writing, optimizing, and debugging complex SQL queries for data extraction, transformation, and performance tuning.
• Demonstrated experience leading BI projects from initiation through completion, including coordinating stakeholders, managing timelines, and ensuring implementation of solutions that meet business objectives.
• Demonstrated experience working with stakeholders to define and document scope and requirements.

• Experience administering Power BI.
• Experience creating visualizations in Power BI.
• Experience with a programming or scripting language such as Python, JavaScript, or Shell/Bash.
• Experience supporting business intelligence solutions involving financial data, or a degree in Finance, Accounting, or a related field.

Bachelor's degree preferred.

The University of Wisconsin-Madison is an Equal Opportunity Employer.

Diversity is a source of strength, creativity, and innovation for UW-Madison. We value the contributions of each person and respect the profound ways their identity, culture, background, experience, status, abilities, and opinion enrich the university community.