Analytics Engineer II

Oregon State University Foundation
Corvallis, OR
Job Description
The Analytics Engineer II designs, builds, and maintains the Foundation's analytics infrastructure and applications, ensuring a reliable, scalable analytics environment that delivers meaningful value to end users.

Requirements

  • Design, build, and maintain SQL/dbt data models and semantic layers optimized for analytical query patterns and AI agent access.
  • Define and maintain semantic layer encoding business logic, KPIs, and metric definitions in a single authoritative location.
  • Apply dimensional modeling techniques to accurately represent business processes and metrics in our data warehouse.
  • Prepare and curate data assets optimized for machine learning, LLM, and AI-agent workflows.
  • Partner with analysts, data scientists, and stakeholders to translate business requirements into trusted data/analytical products.
  • Develop and optimize ELT/ETL pipelines in a cloud data warehouse (e.g., Snowflake) for reliable, scalable data delivery.
  • Implement data quality testing (schema, freshness, business rules) and remediate recurring data issues.
  • Establish and sustain data lineage standards across analytical models, enabling stakeholders to trace data provenance from source to consumption in support of data governance, auditability, and operational reliability.
  • Contribute to shared analytics codebases via Git/GitHub, including code reviews and established development workflows.
  • Support Python-based automation, lightweight analytics services, and troubleshooting of cloud or containerized components as needed.

Benefits

  • Comprehensive Benefits
  • Professional Growth
  • Innovative Work Environment
]]>