Business Intelligence Developer

University of Washington

Seattle, WA

Apply

JOB DETAILS

SKILLS

Amazon Web Services (AWS), Analysis Skills, Application Programming Interface (API), Architectural Services, Automation, Business Analysis, Business Intelligence, Business Operations, Cloud Computing, Compensation and Benefits, Computer Science, Data Modeling, Data Processing, Data Quality, Data Structures, Data Visualization Tools, Database Extract Transform and Load (ETL), Diversity, Document Management, Documentation, Facilities Management, Git, Higher Education, IT Service Management (ITSM), ITIL (IT Infrastructure Library), Identify Issues, Information Technology & Information Systems, JSON, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Microsoft Windows Azure, Needs Assessment, Operational Audit, Operational Improvement, Operational Strategy, Performance Metrics, Pivot Tables, Portfolio Analysis, Power BI, Problem Solving Skills, Process Improvement, Python Programming/Scripting Language, Quality Monitoring, Query Optimization, Reporting Dashboards, Requirements Management, SQL (Structured Query Language), SQL Server Reporting Services (SSRS), Software Development Lifecycle (SDLC), Source Code/Configuration Management (SCM), State Laws and Regulations, Statistics, Systems Engineering, Tableau, Technical Consulting, Technical Delivery, Trend Analysis, Use Cases, Virtualization

LOCATION

Seattle, WA

POSTED

5 days ago

**Job Description** **The UW Facilities Business Innovation & Technology team has an outstanding opportunity for a Business Intelligence Developer to join their team.** **About this Opportunity** 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. This position is located in the UW Tower and requires a hybrid work schedule that includes 1-2 days working in the office Monday-Friday during regular day shift hours. Regular and predictable attendance is required. **Key Responsibilities** **Standardized Reporting and Analytics (50%)** + 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. **Data Maintenance and Modeling (30%)** + 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. **Analytics and Stakeholder Engagement (20%)** + 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. **Required Qualifications** To be considered for this opportunity your application must demonstrate you meet both the minimum qualifications and additional qualifications listed below. Equivalent education and/or experience may substitute for minimum qualifications except when there are legal requirements, such as a license, certification, and/or registration. **Minimum Qualifications** Applicants who do not meet these qualifications WILL NOT be forwarded to the Hiring Department. + Bachelor's degree in Computer Science, Information Systems, Engineering, Statistics, or related field. + Three or more years of experience developing and implementing reporting solutions. **Additional Qualifications** + 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. **Preferred Qualifications** + 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. **About the Team** The Business Innovation & Technology (BIT) Process Team supports UW Facilities by delivering data-driven insights that improve operational efficiency, inform decision-making, and enhance cross-unit collaboration. The team maintains a growing portfolio of analytical tools, reporting assets, and data models that enable Facilities departments to manage work, plan resources, and measure performance. **Compensation, Benefits and Position Details** **Pay Range Minimum:** $70,308.00 annual **Pay Range Maximum:** $105,468.00 annual **Other Compensation:** - **Benefits:** For information about benefits for this position, visit https://www.washington.edu/jobs/benefits-for-uw-staff/ **Shift:** First Shift (United States of America) **Temporary or Regular?** This is a regular position **FTE (Full-Time Equivalent):** 100.00% **Union/Bargaining Unit:** Not Applicable **About the UW** Working at the University of Washington provides a unique opportunity to change lives - on our campuses, in our state and around the world. UW employees bring their boundless energy, creative problem-solving skills and dedication to building stronger minds and a healthier world. In return, they enjoy outstanding benefits, opportunities for professional growth and the chance to work in an environment known for its diversity, intellectual excitement, artistic pursuits and natural beauty. **Our Commitment** The University of Washington is committed to fostering an inclusive, respectful and welcoming community for all. As an equal opportunity employer, the University considers applicants for employment without regard to race, color, creed, religion, national origin, citizenship, sex, pregnancy, age, marital status, sexual orientation, gender identity or expression, genetic information, disability, or veteran status consistent with UW Executive Order No. 81 (https://policy.uw.edu/directory/po/executive-orders/eo-81-prohibiting-discrimination-harassment-and-sexual-misconduct/) . To request disability accommodation in the application process, contact the Disability Services Office at 206-543-6450 or dso@uw.edu . Applicants considered for this position will be required to disclose if they are the subject of any substantiated findings or current investigations related to sexual misconduct at their current employment and past employment. Disclosure is required under Washington state law (https://app.leg.wa.gov/RCW/default.aspx?cite=28B.112.080) . University of Washington is an affirmative action and equal opportunity employer. All qualified applicants will receive consideration for employment without regard to, among other things, race, religion, color, national origin, sexual orientation, gender identity, sex, age, protected veteran or disabled status, or genetic information.

About the Company

University of Washington

INDUSTRY

Other/Not Classified

Resume Resources

Free Resume Templates Free Resume Builder