"Alerted.org

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.

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:

+ 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

+ 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:

+ 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

+ 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

Compensation, Benefits and Position Details

Pay Range Minimum:

$87,984.00 annual

Pay Range Maximum:

$120,000.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 [email protected] .

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.