Business Intelligence (BI) Developer

University of Wisconsin Madison
$95,824 ANNUAL (12 months)
paid time off, remote work
United States, Wisconsin, Madison
21 North Park Street (Show on map)
Nov 22, 2024
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.breuer@wisc.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 The University of Wisconsin-Madison is an Equal Opportunity and Affirmative Action Employer. Qualified applicants will receive consideration for employment without regard to, including but not limited to, race, color, religion, sex, sexual orientation, gender identity, 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 through diversity 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 If you need to request an accommodation because of a disability, you can find information about how to make a request at the following website: https://employeedisabilities.wisc.edu/disability-accommodation-information-for-applicants/ Employment may require a criminal background check. It may also require you and your references to answer questions regarding 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.