Business Intelligence Developer

University of Washington Medical Center•Seattle, WA

1d•Hybrid

About The Position

The UW Facilities Business Innovation & Technology team has an outstanding opportunity for a Business Intelligence Developer to join their team. Reporting to the Manager of Departmental Computing, the Business Intelligence Developer is responsible for transforming operational data into clear, actionable insights for stakeholders across UW Facilities. This position develops and maintains a wide range of reports, dashboards, and their supporting data models across both Tableau and Power BI. A successful BI Developer operates as an internal technical consultant, working directly with business partners to understand reporting needs, translate requirements into technical solutions, and deliver high-quality reporting products. The ideal candidate combines strong SQL skills, experience with modern reporting tools, and the ability to design flexible, multifunctional data models. This role also contributes to the team's evolving data architecture and participates in shaping reporting standards, documentation practices, and automation opportunities.

Requirements

Bachelor’s degree in Computer Science, Information Systems, Engineering, Statistics, or related field.
Three or more years of experience developing and implementing reporting solutions.
Strong proficiency in SQL (T-SQL preferred).
Experience working with SQL Server and related tools, including SSRS.
Hands-on experience with data visualization tools like Tableau and Power BI.
Advanced Excel skills (pivot tables, complex formulas, macros).
Understanding of ETL concepts and data modeling principles.
Strong analytical and troubleshooting skills.
Experience working with stakeholders to gather requirements and deliver technical solutions.
Ability to work independently and collaboratively.
Commitment to supporting diverse perspectives and working in an inclusive environment.

Nice To Haves

Experience using Python for automation or ETL processes.
Familiarity with JSON, APIs, and integrating external data sources.
Experience working with virtualized or cloud infrastructure (Azure, AWS, or similar).
Experience working in higher education or large, complex organizations.
Familiarity with IT frameworks such as SDLC, ITSM, or ITIL.
Experience using Git for version control.

Responsibilities

Design, develop, and optimize complex SQL queries (including CTEs and subqueries) to support reporting and analysis.
Analyze business and operational data to identify trends, performance issues, and actionable insights.
Build and maintain reports and dashboards across tools (Tableau, Power BI, SSRS, Excel), selecting the appropriate platform for each use case.
Ensure reliability of reporting outputs by managing documentation/catalogs, validating data quality, and troubleshooting or enhancing existing reports.
Develop a deep understanding of existing data structures, governance policies, and architectural standards.
Design and refine data models to support new reporting needs, combining existing enterprise models with purpose-built solutions.
Contribute to ETL pipeline development (SQL/Python), improving automation, scalability, and reliability of data workflows.
Ensure data integrity through quality monitoring, audits, and clear documentation of ETL processes, data models, and BI assets.
Own KPI reporting and dashboard development, delivering clear, actionable views of operational and business performance.
Translate business requirements into technical specifications, analytical frameworks, and scalable reporting solutions.