Business Intelligence (BI) Developer

The Office of Data, Academic Planning & Institutional Research (DAPIR) is seeking a Business Intelligence (BI) Developer to join our high functioning and collaborative Institutional Research and Decision Support (IRDS) team.

This position will play a key role in building out resources for the UW-Madison community, making data more available and usable to inform decisions. Relationship building is pivotal to the success of this role. This BI Developer will work with individuals across DAPIR and the institution to identify and understand needs and collaborate to work towards providing a solution. Activities will include developing and maintaining data visualization dashboards and reports for DAPIR and its partners, troubleshooting issues with reports, administration of the report environment, and supporting the data governance program through ensuring products using institutional data meet quality, accuracy, and documentation requirements. The BI Developer will also be instrumental in helping the institution navigate its transition to Workday HR and Finance by developing expertise in Workday reporting to support the campus community.

This is a full-time (100% FTE), ongoing/renewable position.

Remote work is an option for this position on a voluntary basis. However, it is important to note that this role is headquartered in Madison, WI and the responsibilities of the position require occasional work-related travel. Per university policy, if working remotely out-of-state, travel back to UW-Madison would not be reimbursable. Other business travel will require cost comparisons between your home and Madison.

• Partners with a team of business analysts, subject matter experts (SMEs), source system specialists, data architects, and ETL developers to interpret documented user requirements for enterprise-wide stakeholders. (30%)

• Review and approve, based on scope and requirements, BI developer resource effort and timing to design, build, test, and release institutional 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. (5%)

• 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 or non-central BI developers. (10%)

• Serves as subject matter experts to leadership and institutional stakeholders to manage the institution's enterprise business intelligence tools for analytics initiatives. (5%)

• 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. (40%)

• Leads the design and documents institutional 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. (10%)

Data, Academic Planning and Institutional Research (DAPIR)

The annual (12 month) salary for this position is $96,000.

In addition to salary, this position offers a comprehensive benefits package, including generous paid time off, competitively priced health/dental/vision/life insurance, tax-advantaged savings accounts, and participation in the nationally recognized Wisconsin Retirement System (WRS) pension fund. For a summary of benefits, please see https://www.wisconsin.edu/ohrwd/benefits/download/fasl.pdf.

• Strong understanding of databases and data structures, including experience in SQL or similar database programming languages.
• Experience developing business intelligence solutions, such as reports or dashboards.
• Familiarity with data visualization tools, such as Tableau or Qlik.
• Experience querying centralized data warehouses, and cleaning and transforming data into usable and consumable information.
• Experience solving both business and technical problems in a consultative manner with internal or external clients.
• Proficiency with the Microsoft Office suite, including Excel; email and calendaring is assumed.

• Experience across multiple functional areas or data, such as finance, HR, and student.
• Experience supporting end users of BI solutions.
• Experience in a higher education setting.
• Experience with PHP or other similar web scripting languages.
• Experience building reports in Workday.
• Experience administering the 12twenty platform and building reports.
• Skilled at managing multiple priorities.

Bachelor's degree required

Click 'Apply Now' above to start an application. You will be asked to upload a cover letter and resume. Your application materials should demonstrate how your knowledge, skills, and experience align with the qualifications listed in the job posting.

Please note that successful applicants are responsible for ensuring their 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 need of employer sponsorship) on or before the effective date of appointment.

Kory Breuer, HR Manager, kory.breuer@wisc.edu

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.

For more information on diversity and inclusion on campus, please visit: Diversity and Inclusion

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, click here.

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.