Job Description

Job Summary:
The Office of Data, Academic Planning & Institutional Research (DAPIR) is seeking a 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 useable to inform decisions. Relationship building is pivotal to the success of this role. The 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.

Responsibilities:
Provides technical leadership for large, complex enterprise analytics initiatives. Leads and directs the design, development, testing, and maintenance of 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. Coaches mid and lower-level BI Developers and performs high complexity assignments with cross-tool expertise and the ability to build analytic products.
40% 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
30% 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
10% 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% 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.
5% 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% Serves as subject matter experts to leadership and institutional stakeholders to manage the institution's enterprise business intelligence tools for analytics initiatives
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.

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

Education:
Required
Bachelor's Degree

Qualifications:
REQUIRED:
- 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.

PREFERRED:
- 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
- Skilled at managing multiple priorities.