Analyst Programmer Analytics Engineer (Internal Employment Opportunity)

This posting has been re-opened in order to expand the original applicant pool.

This is an Internal Employment Opportunity.

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.

3) Please upload responses to the following questions as a separate document.

Note: Tabular and/or bullet response format is welcome.

For each item below briefly describe your

• Experience summary / Example work
• Specific tools level of proficiency
• Years of use
• Type of experience (e.g. coursework only internship professional job)

Categories:

SQL and data transformation.

dbt or code-based transformation and modeling frameworks.

Python or other scripting languages.

Data modeling and analytical data products.

Dashboard/report development (e.g. Power BI Tableau)

Cloud analytics platforms and modern data tooling (e.g. Fabric Snowflake AWS).

GitHub for version control.

Building solutions using enterprise level systems and data domains (ERP Banner Workday Student HR Finance Research etc.).

AI - Co-Development : experience and understanding of agentic development focused on data tasks.

Starting salary will be commensurate with skills education and experience.

For additional information please contact: Chrysanthemum Hayes at

This is an Internal Employment Opportunity

This recruitment will be used to fill 2 full time (1.00 FTE) Analyst Programmers: Analytics Engineer competency level 2 position for University Information Technology at Oregon State University (OSU).

At Oregon State University (OSU) University Information and Technology (UIT) is at the forefront of the universitys technological transformation. UIT is dedicated to empowering the entire university community by providing secure access to the right data tools and services needed to navigate and shape their unique paths to success. By protecting OSUs technological assets and managing resources efficiently we enable the university to thrive in an ever-evolving landscape.

Led by the Office of the Chief Information Officer (CIO) UIT manages IT operations for OSUs three campuses serving students in Oregons 36 counties and in more than 100 countries. UITs leadership philosophy centers around a human-centric and fully architected technology landscape leveraging enterprise solutions for common good services while empowering individual colleges and business units to innovate and invest in their missions and initiatives.

UIT designs and implements a seamless interconnected digital ecosystem that aligns to the universitys strategic goals and maximizes impact. The division is comprised of trusted partners and consultants committed to igniting innovation and fostering a culture of continuous improvement by providing expert guidance and innovative solutions that support the universitys teaching research outreach and extension mission. Together we are building a future where technology and education converge to create limitless possibilities.

Key Responsibilities:

• Plan Build and Maintain Enterprise-Facing Data Assets: Design build and maintain enterprise-ready analytical models semantic layers dashboards reports and analytical views that support institutional operations planning and decision making.
• Sustainable Solution Design: Translate business requirements into well-structured accurate and reusable data models and reporting products in collaboration with technical and functional partners across OSU.
• Validation Testing and Documentation: Develop and optimize data transformations analytical models and reporting solutions within OSUs modern data platform including medallion architecture and enterprise semantic model patterns. Conduct structured testing peer review validation and documentation of data transformations model logic business rules and reporting outputs to support trusted enterprise use.
• Innovation Emerging Technologies and Continuous Learning: Support continuous improvement of OSUs analytical ecosystem by reducing duplication improving data quality and usability and advancing sustainable self-service analytics through continuous learning community enablement and exploratory work with emerging analytics capabilities including responsible use of AI/ML where appropriate.
• Data Community Learning and Service: Strengthen OSUs data culture by building collaborative relationships supporting knowledge sharing and data literacy engaging in professional development and contributing to mentoring service and community initiatives that enhance team effectiveness and the universitys reporting ecosystem.

REQUIRED QUALIFICATIONS:

This classification requires a basic foundation of knowledge and skills in systems analysis and related programming support functions generally obtained by a bachelors degree in computer science or an equivalent amount of training and applied experience.

• Demonstrated proficiency using SQL in a professional setting for modeling or reporting work
• Experience developing validating and maintaining data models transformations or analytical data products in a production environment
• Experience developing dashboards and reports in enterprise grade tools (Power BI Tableau etc).
• Demonstrated ability to work effectively in a complex fastpaced team-based environment with changing priorities.
• Strong communication skills with demonstrated ability to convey technical concepts clearly to both technical and nontechnical audiences.
• Demonstrated ability to work independently and collaboratively as part of a diverse team.
• Demonstrated commitment to inclusive excellence.

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.

PREFERRED QUALIFICATIONS:

• Masters degree in Computer Science Data Engineering Analytics Information Systems or a related field.
• 2 years experience developing validating and maintaining data models transformations or analytical data products in a production environment.
• Experience using at least one additional programming or scripting language (such as Python) to support data preparation validation or prototyping.
• Experience working in a production environment for a large complex organization.
• Ability to translate business needs into technical requirements.
• Professional experience working with modern cloudbased platforms.
• Professional experience developing data transformations using dbt or similar SQL or other programming-based transformation frameworks.
• Demonstrated applied professional experience performing data modeling and data analytics from an operational system or ERP.
• Demonstrated experience with advanced statistical and effective storytelling techniques with data.
• Demonstrated experience independently completing data analytics and/or Business Intelligence related projects.

When applying please keep in mind this posting will close at 11:59 pm the night before the posted end date. Applications MUST be submitted prior to this deadline.

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. If this position has critical or security-sensitive responsibilities and/or driving duties and 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 our Background Checks website including the for candidates section for more details. If you have questions or concerns about the pre-employment check please contact OSUs Employee and Labor Relations team at .