BI Developer III

Universities of Wisconsin•Madison, WI

10d•Hybrid

About The Position

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. This position may require some work to be performed in-person, onsite, at a designated campus work location. Most work may be performed remotely, at an offsite, non-campus work location. The position will require approximately 6 days on-site, spread throughout the year, but otherwise can be performed primarily remote.

Requirements

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

Nice To Haves

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 a Finance, Accounting, or a related field

Responsibilities

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