BI Developer

Universities of Wisconsin•Madison, WI

1d•Hybrid

About The Position

This Business Intelligence (BI) Developer position is a two-year project position within the department of Informatics and Information Technology at the UW School of Medicine and Public Health (SMPH). This position will directly contribute to SMPH’s educational mission by transforming complex academic, curricular, and learner data into meaningful insights that inform decision-making, enhance educational programs, and support accreditation efforts. Activities will include developing and maintaining data visualization dashboards and reports, troubleshooting issues, and administration of the report environment. This position may be eligible for conversion to a permanent (renewable) role after two years. This position works closely with the BI Development Team, Data Engineering Team, Educational Technology team, program leaders, and other IT colleagues. The BI Developer partners with stakeholders to gather requirements, develop scalable reporting solutions, and ensure alignment with data governance and institutional standards. They serve 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. Terminal, 24 month appointment This position has the possibility to be extended or converted to an ongoing appointment based on need and/or funding. This position may require some work to be performed in-person, onsite, at a designated campus work location. Some work may be performed remotely, at an offsite, non-campus work location. Expectations regarding on-site vs. remote work will be discussed during the interview. Applicants for this position will be considered for the following titles – BI Developer II, BI Developer III. The title is determined by the experience and qualifications of the finalist. The ideal candidate is motivated by the opportunity to contribute to the training of future health professionals and understands that each visualization and insight ultimately supports SMPH’s mission of improving health through education, research, and service. Success in this role requires: technical proficiency, curiosity about academic environments, a strong commitment to using data in service of education, strong written and oral communication skills, and the ability to build relationships, actively listen, and collaborate effectively across teams.

Requirements

3 or more years of hands-on experience in BI development, data engineering, or a heavily technical data analyst role
Experience writing, optimizing, and debugging complex SQL queries for data extraction, transformation, and performance tuning
Demonstrated track record of partnering with stakeholders to understand their core objectives, co-create strategies, and collaboratively drive projects to successful completion
Experience in creating datasets and visualizations in Power BI
Strong written and oral communication skills, with the ability to build relationships, actively listen, and collaborate effectively across teams.
Demonstrates intellectual curiosity and initiative, with a strong desire to learn and deeply understand academic data.

Nice To Haves

Experience working with educational or learner data
Experience with python or other scripting languages

Responsibilities

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
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
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
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
Collaborates with data warehouse engineers and other BI Developers to integrate source data.