Modeler

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

TheModelersupports the Universitys strategic financial and operational decision-making by developing andmaintaininginstitutional 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 intoaccurate 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.

Duties & Responsibilities

Data Modeling and Reporting Development

• Design build andmaintaininstitutional 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 toidentifydata and reporting needs

• Translate business questions into technical specifications and actionable data solutions

• Build consensus among diverse stakeholders toestablishshared 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 tovalidatescripts and ensure interoperability across systems

Documentation and Data Governance

• Create andmaintaindocumentation 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

Requirements:

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

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

Desired:

• Masters degree in Information Systems Data Analytics Economics Statistics or a related field

• Experience in higher education institutional research financial planning or administrative data environments

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