Academic Staff
Terminal (Fixed Term)
BI Developer II
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 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, being able to communicate clearly and collaborate by translating complex data into clear, actionable insights while helping cultivate a culture of data-informed decision-making across SMPH.
Success in this role requires technical proficiency, curiosity and initiative in learning the academic domain, and a strong commitment to using data in service of education. 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.
- 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 or during the offer.
- 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.
- 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
- 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
School of Medicine and Public Health, Office of Information Technology, Business Analytics.
The starting salary for the position is $80,000 annually; but is negotiable based on experience and qualifications.
Employees in this position can expect to receive benefits such as generous vacation, holidays, and sick leave; competitive insurances and savings accounts; retirement benefits.
- 3 or more years of professional experience in BI development or a heavily technical data analyst role
- Experience writing, optimizing, and debugging complex SQL queries for data extraction, transformation, and performance tuning
- Experience in creating datasets and visualizations in Power BI
- Experience collaborating with cross-functional teams and stakeholders to achieve shared goals
- Demonstrated ability to communicate technical and non-technical information clearly, both verbally and in writing, to colleagues, stakeholders, and end users
- Experience working with educational or learner data
- Experience with python or other scripting languages
- Bachelor's degree preferred
For the best experience completing your application, we recommend using Chrome or Firefox as your web browser.
To apply for this position, select either “I am a current employee” or “I am not a current employee” under Apply Now. You will then be prompted to upload your application materials.
Important: The application has only one attachment field. Upload the following documents in that field, either as a single combined file or as multiple files in the same upload area. Failure to submit the required documents will result in no longer being considered for the position
- Cover letter (required)
- Resume (required)
Your cover letter should address how your training and experience aligns with the required and preferred qualifications listed above. Application reviewers will rely on these written materials to determine which applicants move forward in the process. References will be requested from final candidates. All applicants will be notified once the search concludes and a candidate is selected.
University sponsorship is not available for this position, including transfers of sponsorship and TN visas. The selected applicant will be responsible for ensuring their continuous eligibility to work in the United States (i.e. a citizen or national of the United States, a lawful permanent resident, a foreign national authorized to work in the United States without the need of an employer sponsorship) on or before the effective date of appointment. This position is currently scheduled to end 24 months from the start date and will require eligibility to work until that time. If you are selected for this position you must provide proof of work authorization and eligibility to work.
The department will not be able to support a request for a J-1 waiver. If you choose to pursue a waiver and apply for our position, neither the UW nor UWMF will reimburse you for your legal or waiver fees.
Cody Roekle, [email protected] 608-263-7676
Relay Access (WTRS): 7-1-1. See RELAY_SERVICE for further information.
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. We commit ourselves to the pursuit of excellence in teaching, research, outreach, and diversity as inextricably linked goals.
The University of Wisconsin-Madison fulfills its public mission by creating a welcoming and inclusive community for people from every background - people who as students, faculty, and staff serve Wisconsin and the world.
The University of Wisconsin-Madison is an Equal Opportunity Employer.
Qualified applicants will receive consideration for employment without regard to, including but not limited to, race, color, religion, sex, sexual orientation, national origin, age, pregnancy, disability, or status as a protected veteran and other bases as defined by federal regulations and UW System policies. We promote excellence by acknowledging skills and expertise from all backgrounds and encourage all qualified individuals to apply.
To request a disability or pregnancy-related accommodation for any step in the hiring process (e.g., application, interview, pre-employment testing, etc.), please contact the Divisional Disability Representative (DDR) in the division you are applying to. Please make your request as soon as possible to help the university respond most effectively to you.
Employment may require a criminal background check. It may also require your references to answer questions regarding misconduct, including sexual violence and sexual harassment.
The University of Wisconsin System will not reveal the identities of applicants who request confidentiality in writing, except that the identity of the successful candidate will be released. See Wis. Stat. sec. 19.36(7).
The Annual Security and Fire Safety Report contains current campus safety and disciplinary policies, crime statistics for the previous 3 calendar years, and on-campus student housing fire safety policies and fire statistics for the previous 3 calendar years. UW-Madison will provide a paper copy upon request; please contact the University of Wisconsin Police Department.
