Business Intelligence (bi) Developer

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. Work Type: Full Time: 100% This is a hybrid position - some onsite, in-person work may be required with the flexibility to perform some work remotely. Expectations regarding on-site vs. remote work will be discussed during the interview. Appointment Type, Duration: Ongoing/Renewable Salary: Minimum $95,824 ANNUAL (12 months) Depending on Qualifications This position offers a comprehensive benefits package, including generous paid time off, competitively priced insurance plans, tax-advantaged savings accounts, and participation in the nationally recognized Wisconsin Retirement System (WRS) pension fund. Learn more at https://hr.wisc.edu/benefits/. Additional Information: The successful candidate will be responsible for ensuring eligibility for employment in the United States on or before the first day of employment. University sponsorship of an employment visa is not available for this position. How to Apply: Click the 'Apply Now' button above to begin. After creating a UW Jobs profile, 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. Contact: Kory Breuer kory.breuerwisc.edu Relay Access (WTRS): 7-1-1. See RELAY_SERVICE for further information. Official Title: BI Developer IV (Inst)(IT211) Department(s): A01-GENL EDUCATIONAL ADMIN/A0124/INST RESRCH&SUPPORT Employment Class: Academic Staff-Renewable Job Number: 308292-AS