BUSINESS INTELLIGENCE DATA ARCHITECT

UW Medicine - Seattle, WA

Full-time - Mid Level

Hybrid - Seattle, WA

1,001-5,000 employees

Ambulatory Health Care Services

About the position

The University of Washington (UW) has an outstanding opportunity for a Business Intelligence Data Architect within the Business Innovation and Technology (BIT) team. This role is crucial for delivering on the UW Facilities strategy to enhance data-driven business decisions. The Business Intelligence Data Architect will work across the UW Facilities organization to improve cross-unit data collection and analysis, which is essential for managing work, improving processes, and aligning with organizational strategy. The data, analysis, reporting, and data visualization produced by this position will be critical in understanding tactical issues, designing supportive data structures, and 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. The position will collaborate with UW Facilities, UW-IT, and University partners to gather and document requirements for developing data and reporting strategies that meet University needs and priorities. Additionally, this role may work with inter-collegiate, state, and federal entities to deliver optimal data solutions for UW staff and partners.

Responsibilities

• 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.
• Recommend and design reporting solutions that inform UW Facilities' needs for long-term planning, goal setting and strategy.
• 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.
• 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.

Requirements

• 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.

Nice-to-haves

• 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.

Benefits

• Generous benefits and work/life programs.
• Professional growth opportunities.
• Unique resources in an environment noted for diversity, intellectual excitement, artistic pursuits and natural beauty.