BI Developer
Company: University of Wisconsin - Madison
Job Location: Madison, Wisconsin
Category: Software Engineer/Programmer
Type: Full-Time
*****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 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.
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
- 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
- Collaborates with data warehouse engineers and other BI Developers to integrate source data.
Department: School of Medicine and Public Health, Office of Information Technology, Business Analytics.
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 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
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. 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.
Contact Information: Cody Roekle, croekle@wisc.edu 608-263-7676
This is a Preview Listing…
You must sign in to see the full job description, and to apply.
Manage / Upgrade this job to a Full Job Listing.
Find Your Best Opportunity
Tell them AcademicJobs.com sent you!
