Business intelligence (bi) developer

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 Department of Medicine 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 campus benefits webpage and the SMPH Faculty /Academic Staff Benefits Flyer.

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, sll@medicine.wisc.edu

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.