Position Details

Position Information

Department Inst Analytcs & Reportng (JIS)

Position Title Academic Wage Appt - Salaried

Job Title Academic Wage Salary: Data Modeler

Appointment Type Academic Wage

Job Location Corvallis

Benefits Eligible Full-Time, benefits eligible

Remote or Hybrid option? Yes

Job Summary

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.

Data Statement

UIT is committed to delivering data as a strategic working asset and enabling data-informed decision-making across OSU . UIT leaders and staff use data to inform decision-making at all organization levels. Persons in technology roles are expected to design systems with data portability in mind and work within enterprise architecture and privacy guidelines.

DEI Statement

UIT has a strong commitment to and belief in the value of diversity, equity, and inclusion ( DEI ). As a member of the UIT community, the person in this position is expected to foster and promote DEI values and demonstrate a commitment to inclusive excellence in their work.

Security Statement

Securing and protecting OSU’s digital assets and information systems is crucial to our missions of teaching, learning, research, and outreach. All OSU IT professionals have a direct responsibility to provide high-quality and secure IT systems and services. Persons in technology roles are expected to be responsive to security-related actions and requirements and collaborate to support the OSU community securely.

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

•7cultural resource centers (https://hr.oregonstate.edu/work-life/diversity-and-cultural-resources) 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 acomprehensive benefits package (https://hr.oregonstate.edu/benefits/prospective-employee) 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 theBenefits Calculator (https://hr.oregonstate.edu/benefits/new-employees/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.

Pay Method Salary

Pay Period 1st through the last day of the month

Pay Date Last working day of the month

Recommended Full-Time Salary Range $66,316 - $115,962

Link to Position Description

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

Posting Detail Information

Posting Number P08918UF

Number of Vacancies 2

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

Indicate how you intend to recruit for this search Competitive / External - open to ALL qualified applicants

Special Instructions to Applicants

To ensure full consideration, applications must be received by 3/21/2025.Applications will continue to be accepted after the full consideration date, until a sufficient applicant pool has been achieved or the position is filled. The closing date is subject to change without notice to applicants.

When applying you will be required to attach the following electronic documents:

1) A resume/CV; and

2) A cover letter indicating how your qualifications and experience have prepared you for this position.

You will also be required to submit the names of at least three professional references, their e-mail addresses and telephone numbers as part of the application process.

For additional information please contact:Chrysanthemum Hayes atchrysanthemum.hayes@oregonstate.edu (%20chrysanthemum.hayes@oregonstate.edu%20)

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

OSU will conduct a review of the National Sex Offender Public website prior to hire.

OSU is a fair chance employer committed to inclusive hiring. We encourage applications from candidates who bring a wide range of lived experience including involvement with the justice system. This job has “critical or security-sensitive” responsibilities. If you are selected as a finalist, your initial job offer will be contingent upon the results of a job-related pre-employment check (such as a background check, motor vehicle history check, sexual misconduct reference check, etc.). Background check results do not automatically disqualify a candidate. Take a look at ourBackground Checks (https://hr.oregonstate.edu/careers/background-checks) website including thefor candidates (https://hr.oregonstate.edu/careers/candidates) section for more details. If you have questions or concerns about the pre-employment check, please contact OSU’s Employee and Labor Relations team atemployee.relations@oregonstate.edu.

Supplemental Questions

Read More at: https://jobs.oregonstate.edu/postings/166411

OSU commits to inclusive excellence by advancing equity and diversity in all that we do. We are an Affirmative Action/Equal Opportunity employer, and particularly encourage applications from members of historically underrepresented racial/ethnic groups, women, individuals with disabilities, veterans, LGBTQ community members, and others who demonstrate the ability to help us achieve our vision of a diverse and inclusive community.