Business Intelligence (BI) Developer

University of Wisconsin-Madison

$110K *
US-AnywhereRemote in Madison, WI
Healthcare
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 5-7 years of experience in business intelligence or analytics, preferably in healthcare.
  • Proficient with analytic tools and techniques, particularly SQL, R, and Python.
  • Strong ability to create reports and dashboards that present data effectively.
  • Experienced in project management with a demonstrated leadership track record.
  • Knowledge of EPIC Caboodle and associated data solutions is a priority.
  • Ability to liaise between technical teams and non-technical stakeholders.
  • Professional understanding of data security and confidentiality protocols.

Responsibilities

  • Lead the design and development of complex BI solutions for clinical and operational data.
  • Collaborate with various stakeholders to assess analytics needs and deliver tailored reporting solutions.
  • Ensure the quality and documentation of BI development processes and outputs.
  • Oversee the BI team's project timelines and resource allocation for efficiency.
  • Develop enterprise BI standards and implement feedback from stakeholders.
  • Provide mentorship and support to junior BI developers to enhance team capabilities.
  • Manage high-risk analytics projects, ensuring alignment with departmental goals.

Benefits

  • Flexible work arrangements, primarily remote.
  • Generous vacation, holidays, and sick leave policies.
  • Comprehensive insurance and savings options.
  • Robust retirement benefits.
  • Commitment to professional fulfillment and health equity initiatives.
Full Job Description
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:
Regular

Job Profile:
BI Developer III

Job Summary:

The Department of Medicine offers a unique opportunity for a Business Intelligence Developer to lead the design, development, and delivery of analytic solutions to department leadership, faculty and staff within the department, leveraging a variety of analytic methods, tools, visualizations, and modeling techniques. This includes consultation and the development of trusted advisor relationships with leadership to assess analytics needs and facilitation of solution development by managing multiple concurrent efforts, including projects of significant complexity and risk. The candidate will work closely with a variety of stakeholders, including physicians, advanced practice providers, revenue cycle team members and health system leaders, coordinating analytics activities across the entire department clinical enterprise. 

The selected candidate will lead the work of the Clinical Business Intelligence team to design, develop, test and maintain performance-optimized business intelligence (BI) solutions based on underlying data warehouse structures and the optimal match of user requirements and available data presentation methods and tools. The BI Developer will develop and maintain solution documentation, coaches lower-level BI developers, and performs mid-to-high-level complexity assignments that require a deep understanding of underlying data structures and associated tools. Through a matrix arrangement with the UW Health Enterprise Analytics (EA) department, the BI Developer will have access to clinical, financial, and operational data in order to provide the department with dashboards, quality assurance and clinical operations reporting.

  • It is anticipated that this position will be remote and requires work be performed at an offsite, non-campus work location.

  • This position has been identified as a position of trust with access to vulnerable populations. The selected candidate will be required to pass an initial caregiver check to be eligible for employment under the Wisconsin Caregiver Law and every four years.

  • Candidates who demonstrate the following knowledge, skills, and abilities will be given first consideration:
     - Demonstrated leadership in project management.
     - Demonstrated ability to develop a compelling data story, presenting data in a way that provided actionable understanding to customers.
     - Demonstrated experience working with EPIC Caboodle to abstract data and develop BI solutions.

Key Job Responsibilities:
  • Works with multiple data domains/sets and data architectures (unstructured/structured) and using advanced expertise in a broad set of enterprise-scale tools, matches the right data presentation modality to user requirements. Employs deep expertise in data visualization and storytelling to design, prototype, test, and deliver accurate, sustainable enterprise solutions for large-scale user populations
  • Partners with a team of business analysts, business subject matter experts (SMEs), source system data analysts, data architects, and ETL developers to interpret documented user requirements for enterprise-wide stakeholders. Works with data warehouse architects, data modelers, and ETL developers to document and present highly complex options through mock-ups and prototypes, refining underlying data structures to best meet use cases
  • Oversee, assess, and approve the content and quality of complex design/build documentation for approval by business SMEs and project team leads. Author documentation for highly complex design/build documentation outside of the expertise of lower level BI developers
  • Designs and documents enterprise BI development standards, assesses impact on existing BI projects, proposes solutions, and shepherds them through stakeholder feedback and governance approval. Resolves highly complex BI development issues escalated from lower-level BI developers
  • Review and approve, based on scope and requirements, BI developer resource effort and timing to design, build, test, and release BI developer solutions. Understand and balance developer resources across multiple competing projects to mitigate risks. Identify options for backfill or external resource acquisition to fulfil resource requirements
  • Supervise and direct the work of Business Intelligence Team, ensuring projects are managed to timely completion and staffing needs are met.

  • Use knowledge of healthcare industry, market environment, and clinical and business workflows and activities, to inform solution design and development. Partner with application team colleagues and others as needed for end-to-end solutions.

  • Manage initiatives and projects of significant complexity and risk.

Department:
School of Medicine and Public Health, Department of Medicine, Business Intelligence Team

Fueled by innovation yet grounded in kindness, the  empowers leaders to transform medicine and improve lives everywhere. We are committed to professional fulfillment and health equity. We strive to ensure that everyone in our department understands the importance of social impact and belonging—and is empowered to champion it in all they do. Join us and be a part of supporting our nationally recognized faculty, innovative medical education programs and exceptional clinical care as we work towards our vision of healthy people and healthy communities!
 

The Business Intelligence Team within the Department of Medicine (DOM) supports clinical operations and quality improvement to improve health outcomes across Wisconsin and beyond.


Compensation:

The starting salary for the position is $110,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 webpage and the SMPH Faculty /Academic Staff Benefits Flyer 2026


Required Qualifications:

  • Demonstrated success applying relational thinking in writing and validating queries against multiple data sources.

  • Demonstrated success creating analytic solutions such as reports, dashboards, and business plans.

  • Demonstrated success identifying needs and requirements of clients seeking analytic solutions.

  • Demonstrated success using quantitative and qualitative methods to identify opportunity.

  • Demonstrates professional maturity surrounding data access, data security, data sensitivity and data confidentiality.

  • Demonstrated ability to leverage knowledge and skill with a variety of query tools (e.g. SQL, R, Python), analytic techniques, tools and platforms, to analyze large quantities of data, from multiple sources, to design, create, and maintain, dashboards, business plans, forecasts, projections and presentations, models, algorithms, and statistical and financial analyses.

Preferred Qualifications:
  • Minimum of three (3) years of relevant data analysis or analytics experience in healthcare (provider or payor).

  • Minimum of one (1) year of experience using Epic Chronicles, Epic Registries, Epic Clarity and/or Epic Caboodle Data Warehouse.

  • Competency in the following areas:
     - Strong written and verbal communication skills
     - Strong attention to detail
     - Effective team member
     - Critical thinking

  • Emerging competency in at least three data and analytic competencies such as:
     - Analytic methods and tools
     - Business intelligence
     - Data management
     - Data architecture
     - Data querying
     - Analysis and critical thinking skills
     - Data governance
     - Analytics education/learning
     - Metadata

  • Subject matter expertise in domains such as:
     - Cost accounting
     - Financial modeling/analysis
     - Quality measurement
     - Health outcomes
     - Social determinants of health
     - Hospital or ambulatory operations
     - Population health management
     - Patient satisfaction
     - Strategic planning
     - Labor and productivity analytics
     - Revenue cycle management
     - Survey design/development

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 an ongoing position that will require continuous work eligibility.  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:

Sheri Lawrence,

Relay Access (WTRS): 7-1-1. See for further information. 

Similar Jobs

More Jobs at University of Wisconsin-Madison

More Healthcare Jobs

Find similar Business Intelligence (BI) Developer jobs: