Current Employees: If you are currently employed at any of the Universities of Wisconsin, log in to Workday to apply through the internal application process.
Job Category:
Academic Staff
Employment Type:
Terminal (Fixed Term)
Job Profile:
BI Developer II
Job Summary:
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.
Key Job 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
Department:
School of Medicine and Public Health, Office of Informatics and Information Technology, Business Analytics.
This position is within the School of Medicine and Public Health’s Office of Informatics and Information Technology (IIT). IIT is a multidisciplinary team of data scientists, engineers, developers, and IT support staff. We offer a variety of Informatics and IT services to departments and research staff within the School of Medicine and Public Health and beyond to support the conduct of high-quality clinical and translational research.
Informatics: We provide innovative solutions and training for a broad spectrum of clinical and translational research utilizing real-world data to facilitate rapid translation of research findings into clinical practice, with an emphasis on precision medicine, healthcare delivery, and population health.
Technology Solutions: We provide technology solutions to the School of Medicine and Public Health including cybersecurity, educational technology, and IT support.
Compensation:
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. For more information, refer to the campus benefits webpage and the SMPH Academic Staff Benefits Flyer 2026.
Required Qualifications:
- 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.
Preferred Qualifications:
- Experience working with educational or learner data
- Experience with python or other scripting languages
Education:
- Bachelor's degree preferred
How to Apply:
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.
- 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.
Contact Information:
Cody Roekle, croekle@wisc.edu 608-263-7676
Relay Access (WTRS): 7-1-1. See RELAY_SERVICE for further information.
Institutional Statement on Diversity:
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. For more information regarding applicant and employee rights and to view federal and state required postings, visit the Human Resources Workplace Poster website.
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.