Modeler

University of Washington Medical Center

About The Position

Finance, Planning, and Budgeting (FPB) encompasses the major central financial, planning, analytical, and budgeting functions for the University of Washington, including: Finance & Budget Strategy Institutional Analytics & Decision Support Policy, Planning & State Operations University Business Services The Modeler supports the University’s strategic, financial, and operational decision-making by developing and maintaining institutional data models, automated reporting systems, and analytical solutions. This position serves as a critical link between business needs and technical data systems, ensuring that complex institutional information is transformed into accurate, accessible, and actionable insights. Working within Finance, Planning & Budgeting (FPB) and Institutional Analysis & Reporting (IA/IR), the Modeler designs and implements sustainable data solutions that enhance reporting consistency, data integrity, and analytical capacity across the University. The role requires collaboration with cross-functional stakeholders to define data and reporting requirements, streamline business processes, and deliver reliable tools and dashboards that inform planning, budgeting, and performance management.

Requirements

Bachelor's degree in Information Systems, Data Analytics, Computer Science, Economics, or a related field, and four or more years of experience in data modeling, business systems analysis, or institutional research
Advanced proficiency in SQL and relational database management
Experience developing and maintaining ETL processes and automated data workflows
Skill in designing and delivering data models, reports, and dashboards using tools such as Tableau, Power BI, or Microsoft SSRS
Ability to document business processes, workflows, and data lineage
Proven experience translating business requirements into technical and analytical solutions
Excellent analytical reasoning, problem-solving, and attention to data accuracy
Effective communication and collaboration skills across technical and non-technical audiences
Familiarity with data governance, metadata management, and enterprise data environments, such as Edify desirable
Demonstrated experience in working with diverse groups and teams; create a culture of inclusion and equity throughout the team while supporting the overall culture of FPB

Nice To Haves

Master’s degree in Information Systems, Data Analytics, Economics, Statistics, or a related field
Experience in higher education institutional research, financial planning, or administrative data environments
Expertise with enterprise data platforms such as Edify, or other data lake and data warehouse solutions
Familiarity with predictive analytics, forecasting, or statistical modeling using tools such as R, Python, or SAS
Knowledge of data governance frameworks, metadata management, and data quality assurance processes
Demonstrated success in implementing process automation and improving reporting efficiency through modern BI and analytics tools

Responsibilities

Data Modeling and Reporting Development Design, build, and maintain institutional data models and analytical datasets supporting planning, budgeting, and performance analysis
Develop automated reporting solutions, dashboards, and visualizations that improve data accessibility and accuracy
Ensure data models align with institutional standards and strategic information needs
Requirements Gathering and Stakeholder Engagement Facilitate requirements-gathering sessions with FPB, IA/IR, and campus partners to identify data and reporting needs
Translate business questions into technical specifications and actionable data solutions
Build consensus among diverse stakeholders to establish shared definitions and methodologies
ETL Development and System Automation Develop and manage Extract, Transform, and Load (ETL) processes, integrating data from multiple enterprise systems
Streamline workflows to automate data transformation and reduce manual manipulation
Collaborate with IT and data architecture teams to validate scripts and ensure interoperability across systems
Documentation and Data Governance Create and maintain documentation, including data models, workflows, metadata, and standard operating procedures
Ensure compliance with institutional data governance and information security standards
Support consistent data definitions and methodologies across institutional reporting
Institutional Collaboration and Continuous Improvement Serve as a technical and analytical resource to stakeholders across FPB, IA/IR, and other university units
Participate in cross-campus initiatives that enhance data systems, reporting tools, and analytic capacity
Remain current with emerging technologies and practices in data modeling, business intelligence, and analytics
Train and cross train team across the team and organization to ensure organizational sustainability and operational continuity
Other duties as assigned