BUSINESS INTELLIGENCE DATA ARCHITECT

As a UW employee, you have a unique opportunity to change lives on our campuses, in our state and around the world. UW employees offer their boundless energy, creative problem-solving skills and dedication to build stronger minds and a healthier world. UW faculty and staff also enjoy outstanding benefits, professional growth opportunities and unique resources in an environment noted for diversity, intellectual excitement, artistic pursuits and natural beauty. UW Facilities manages the University's buildings, infrastructure and land, with more than 1,100 employees in a variety of fields. The Asset Management group includes Capital & Space Management, Real Estate, Sustainability and other teams responsible for planning and workload management. The Operations group includes Project Delivery, Maintenance & Construction, Campus Utilities & Operations, Building Services, Transportation Services and Safety. Supporting these groups are the Business Intelligence & Information Technology group and the Finance & Administration group. We have an outstanding opportunity for a Business Intelligence Data Architect. The Business Intelligence Data Architect is an important role in the Business Innovation and Technology (BIT) team for delivering on the UW Facilities strategy to make more data driven business decisions. This position is instrumental in working across UW Facilities organization for driving efforts to improve cross-unit data collection and analysis used to manage work, improve processes, and align with organizational strategy. The data, analysis, reporting, and data visualization produced by this position will play a critical role in understanding tactical issues, designing supportive data structures, managing technical resources, to establishing a robust reporting architecture to meet business demands. Under the general direction of the Manager of Business Intelligence Analytics, this role will be responsible for designing, developing, creating, dashboarding, and maintaining critical business and operational reports. This position will work across UW Facilities, UW-IT, and University partners to gather and document requirements for developing data and reporting strategies to meet University needs and priorities. This role may also work with inter-collegiate, state, and federal entities to deliver the best possible data solutions for UW staff and partners. Job complexities include contributing to initiatives to develop and document and implement data standards, implement database security requirements, and develop business aligned reporting solutions. Primary Duties and Responsibilities: Data architecture (40%) * Devise and implement data structure and solutions that will impact, improve and inform both UW Facilities stakeholders as well as external teams across the University that use and work with facilities data. * Operate as a subject matter expert for UW Facilities data architecture and design. * Translate business requirements into databases, data warehouses, and data streams. * Create and implement data management processes and procedures. * Research and maintain documented understanding of the broad university data environment. * Develop application programming for ETL interfaces to effectively move, update and verify data. Data Reporting (30%) * Recommend and design reporting solutions that inform UW Facilities' needs for long-term planning, goal setting and strategy. Solutions will include organizational Key Performance Indicators and operational performance metrics. * Collaborate and partner with peers and business owners to define business requirements. * Operate as a subject matter expert for UW Facilities data reporting. * Use SQL, data visualization, and business intelligence tools to create reports. * Maintain existing reports and troubleshoot them when needed. * Work with departments to understand their needs and develop objectives and metrics. * Create department-specific reports that help improve workflow and efficiency. * Work with stakeholders to review, update and enhance existing reports. Database administration (20%) * Operate as a subject matter expert for UW Facilities database administration. * Maintain data access requirements and ensure that organizational data is secure. * Manage vendor, partner and contractor engagements from negotiation through delivery. * Backup and restore data to prevent data loss. * Monitor database operation and provide support. * Build and maintain data repositories. Other Duties as Assigned (10%) Core Competencies * Demonstrate personal integrity and trustworthiness. * Manage stressful situations and change priorities effectively. * Anticipate, recognize, and resolve problems. * Be responsible and accountable. * Use organizational skills and attention to details. * Maintain a positive, optimistic, and success-oriented attitude. * Exercise professionalism, which includes being tactful and courteous. * Exhibit a professional work ethic. * Continuously promote a safe work environment. Requirements include: * Bachelors degree in Data Science, Informatics, Information Technology, Computer Science or related field. * 4 years' experience in Business Intelligence supporting a medium sized or larger complex enterprise data environment. * Excellent technical skills including understanding of operational requirements for data base servers, data warehouses and data integration (including API's). * Highly capable with MS SQL, MySQL, and supporting reporting platforms including SSRS, Tableau, and PowerBI. * Excellent soft skills. Demonstrated ability to translate technical needs into business requirements, and work as a senior level member of a technology team. * Knowledge of descriptive statistics including mean and median, standard deviation, percentiles, outliers, and distribution. * Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy. * Ability to deal with ambiguity and navigate with little written documentation and instructions Equivalent education/experience will substitute for all minimum qualifications except when there are legal requirements, such as a license/certification/registration. Desired: * Experience in higher education processes, applications, and systems at a complex, large, research university. * Knowledge and understanding of common IT frameworks including the Software Development Lifecycle (SDLC), Information Technology Service Management (ITSM or ITIL). * Experience with Java, JavaScript, and API usage. * Experience with complex, distributed cloud-based infrastructure. Conditions of Employment: * Regular and predictable attendance is required. * Must be able to work in a non-smoking environment. * Potential for hybrid work schedule. Application Process: The application process for UW positions may include completion of a variety of online assessments to obtain additional information that will be used in the evaluation process. These may include Work Authorization, Cover Letter and/or others. Any assessments that you need to complete will appear on your screen as soon as you select "Apply to this position". Once you begin an assessment, it must be completed at that time; if you do not complete the assessment, you will be prompted to do so the next time you access your "My Jobs" page. If you select to take it later, it will appear on your "My Jobs" page to take when you are ready. Please note that your application will not be reviewed, and you will not be considered for this position until all required assessments have been completed.