AW Salary: Data Modeler (Remote)

Institutional Analytics and Reporting is seeking two salaried Academic Wage: Data Modelers. These are full-time (1.00 FTE), 12-month, fixed-term positions.

This position will be used to backfill for those supporting the Administrative Modernization Project (AMP) and is anticipated to last until 06/01/2026; however, staffing needs may dictate flexibility in the appointment’s duration.

Oregon State University is undergoing an exciting enterprise-scale modernization and transformation process, including a complete transformation of the data and reporting environment from legacy systems and data structures to modern medallion architecture in Microsoft Fabric. We are doing this for all Student, Human Resources, and Finance data supporting the operations and strategic work for the university.

The position will report to the Director of Decision Support and reside in the team responsible for enterprise data and reporting strategy and services.

As a Data Modeler, this individual will play a crucial role partnering to implement the modern medallion data architecture and implement data best practices in managing data for reporting and strategic analysis. The ideal candidate will work closely with cross-functional teams to understand business requirements and translate them into efficient and scalable data models using Microsoft Fabric tools.

This role will provide critical support in the transition from legacy reporting systems and data structures to the modern data pipeline that supports unified and consistent reporting practices for Oregon State University.

Why OSU?

Working for Oregon State University is so much more than a job!

Oregon State University is a dynamic community of dreamers, doers, problem-solvers and change-makers. We don’t wait for challenges to present themselves — we seek them out and take them on. We welcome students, faculty and staff from every background and perspective into a community where everyone feels seen and heard. We have deep-rooted mindfulness for the natural world and all who depend on it, and together, we apply knowledge, tools and skills to build a better future for all.

FACTS :

• Top 1.4% university in the world
• More research funding than all public universities in Oregon combined
• 1 of 3 land, sea, space and sun grant universities in the U.S.
• 2 campuses, 11 colleges, 12 experiment stations, and Extension programs in all 36 counties
• 7 cultural resource centers that offer education, celebration and belonging for everyone
• 100+ undergraduate degree programs, 80+ graduate degrees plus hundreds of minor options and certificates
• 35k+ students including more than 2.3k international students and 10k students of color
• 217k+ alumni worldwide
• For more interesting facts about OSU visit: https://oregonstate.edu/about

Locations:

Oregon State has a statewide presence with campuses in Corvallis and Bend, the OSU Portland Center and the Hatfield Marine Science Center on the Pacific Coast in Newport.

Oregon State’s beautiful, historic and state-of-the-art main campus is located in one of America’s best college towns. Corvallis is located close to the Pacific Ocean, the Cascade mountains and Oregon wine country. Nestled in the heart of the Willamette Valley, this beautiful city offers miles of mountain biking and hiking trails, a river perfect for boating or kayaking and an eclectic downtown featuring local cuisine, popular events and performances.

Total Rewards Package:

Oregon State University offers a comprehensive benefits package with benefits eligible positions that is designed to meet the needs of employees and their families including:

• Medical, Dental, Vision and Basic Life. OSU pays 95% of premiums for you and your eligible dependents.
• Free confidential mental health and emotional support services, and counseling resources.
• Retirement savings paid by the university.
• A generous paid leave package, including holidays, vacation and sick leave.
• Tuition reduction benefits for you or your qualifying dependents at OSU or the additional six Oregon Public Universities.
• Robust Work Life programs including Dual Career assistance resources, flexible work arrangements, a Family Resource Center, Affinity Groups and an Employee Assistance Program.
• Optional lifestyle benefits such as pet, accident, and critical illness insurance, giving you peace of mind and the support you need to thrive in all aspects of your life.

Future and current OSU employees can use the Benefits Calculator to learn more about the full value of the benefits provided at OSU.

Key Responsibilities

Data Modeling – 80%

• Works independently to Analyze, Design and Implement Data Models to move from legacy systems and databases to Microsoft Fabric
• Analyze legacy and recent data usage across applications.
• Develop conceptual, logical, and physical data models.
• Implement relational, dimensional databases.
• Create data models optimized across different data domains.
• Optimize models for data query performance using best practices.
• Ensure critical business functionality is met and performant in the new data platform
• Collaboration: Work with business analysts, data architects, Lead Data Modeler, data administrators and database & BI developers to make effective recommendations.
• Translate enterprise requirements into effective data models.

Data Standards and Documentation – 20%

• Implement data governance policies and standards to ensure data quality, integrity, access/permissions, and security within the Microsoft Fabric environment.
• Define, review and document data modeling and design standards.
• Ensure complete and thorough documentation for all modeling and data work as well as contribute to the standardization and maturation of the enterprise data modeling practice at OSU.

What You Will Need

• Bachelor’s degree in computer engineering, computer science, information systems, or a related field.
• 2+ years in data analytics, data modeling, or data architecture.
• Proficiency in data modeling for transactional, operational reporting, and analytical solutions ( EDW , Data Lake).
• Experienced with Dimensional Modeling and Data Warehouse Modeling.
• Experience using data modeling tools
• Experience with dbt and airflow for modeling and automation – or equivalent data transformation tools
• Experience with SQL and its use in data access and analysis
• Demonstrated skills necessary to remodel and/or re-platform from legacy application databases to modern data environments.
• Excellent communication, problem-solving, organizational, and analytical skills.
• Ability to work independently and collaboratively.
• Experience working with cloud-based databases (e.g., Azure/Fabric).

This position is designated as a critical or security-sensitive position; therefore, the incumbent must successfully complete a criminal history check and be determined to be position qualified as per University Standard: 05-010 et seq. Incumbents are required to self-report convictions and those in youth programs may have additional criminal history checks every 24 months

What We Would Like You To Have

• Knowledge of Workday and Banner for higher education is preferred
• Exposure to data architecture implementation on Azure/Fabric preferred.
• Certifications in Microsoft Fabric or related technologies preferred.

Working Conditions / Work Schedule

Standard business hours of operation that align with the typical operating schedule for the team on Pacific time zone are expected. Fully remote position is an option for this role.

Link To Position Description

https://jobs.oregonstate.edu/position_descriptions/165736

Posting Number P08918UF

Anticipated Appointment Begin Date 05/15/2025

Anticipated Appointment End Date 06/01/2026

Posting Date 03/14/2025

Full Consideration Date 03/21/2025

Closing Date 04/12/2025

We are an Equal Opportunity Employer, including disability, protected veteran, and other protected status.