Modeler

Job Description

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.

• 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

• 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

• 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

• 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

• 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

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