> Markdown version of [/jobs/ext/70742-analytics-engineer-ii](https://www.wearedevelopers.com/jobs/ext/70742-analytics-engineer-ii). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Analytics Engineer II

- **Company:** Oregon State University
- **Location:** Corvallis, OR, United States
- **Experience:** Experienced
- **Contract:** Permanent contract
- **Skills:** Sql Data Warehouse, Artificial Intelligence, Airflow, Amazon Web Services, Data Analysis, Business Logic, User Authentication, Microsoft Azure, BigQuery, Code Review, Encodings, Data Governance, Data Infrastructure, Extract Transform Load (ETL), Data Warehousing, Relational Databases, Web Development, Dimensional Modeling, Document-Oriented Databases, Python (Programming Language), PostgreSQL, Machine Learning, Microsoft SQL Server, Routing, Power BI, Standard Sql, Software Engineering, SQL Databases, Tableau (Software), Web Applications, Workflow Management Systems, Data Processing, Azure Data Factory, Flask (Web Framework), Large Language Models, Snowflake, Data Layers, Containerization, Information Technology, Data Lineage, Data Management, Virtual Agents, Data Delivery, Looker Analytics, Software Version Control, Docker, Amazon Redshift, Databricks
- **Published:** May 13, 2026
- **Apply:** https://www.indeed.com/viewjob?jk=933518dacc920f09

## About the Role

Do you have a valid Driver's License license?, Do you have experience in Web development?, Do you have a Bachelor's degree?, * Solid experience in data modeling, including dimensional modeling concepts and data warehouse design, and leveraging AI tools such as Claude Code.

 * Strong SQL proficiency for transformation, analysis, and validation
 * Python proficiency for data processing, automation, and integration
 * Experience with dbt or a comparable analytics engineering framework to build, test, and document data models

Data Platforms & Infrastructure

 * Experience in Azure cloud environments (AWS or GCP transferable)
 * Experience with Snowflake or other modern cloud data warehouses (BigQuery, Redshift, Databricks SQL, etc.)
 * Familiarity with relational databases such as SQL Server and PostgreSQL

Data Platforms & Orchestration

 * Experience designing, building, and maintaining ELT/ETL pipelines
 * Familiarity with orchestration tools (Airflow, Prefect, Azure Data Factory, or similar)
 * Ability to troubleshoot pipeline failures, performance issues, and data quality problems
 * Experience implementing data quality tests, including schema, freshness, and business rule validations

Version Control & Development Practices

 * Experience with Git/GitHub for version control and shared codebase collaboration
 * Comfortable with following established development workflows, including code reviews and iterative improvement

Additional Knowledge/Skills:

 * Experience designing data models and semantic layers that support machine-learning and LLM-based reasoning for leveraging AI-driven analytical agents
 * Experience with Tableau or similar BI tools (Power BI, Looker, etc.) to support dashboard development and analytics
 * Familiarity with Python web application development using frameworks such as Flask
 * Understanding of web application concepts, including routing, authentication patterns, and environment configuration
 * Exposure to Docker or containerized applications, including interpreting logs and basic runtime troubleshooting, Bachelor's degree in computer science or related field and three to five years of software development or related experience. Preference will be given to those with experience or knowledge in AI-related processes and technologies, including Python, DBT, Azure, SQL Server, and Snowflake. Education and experience equivalencies will be considered.
Important Organizational Notes:
The candidate must possess a valid driver's license and be prepared to work a flexible schedule that may include evenings and weekends to support foundation events and donor-related activities. Adherence to a professional code of conduct is essential at all times, ensuring the highest standards of integrity, respect, and ethical behavior in all interactions and responsibilities. Adherence to the Core Values is vital to success.

## Description

Reporting to the Senior Director II, Relationship Insights & Analytics, the Analytics Engineer II designs, builds, and maintains the Foundation's analytics infrastructure and applications. This role ensures a reliable, scalable analytics environment that delivers meaningful value to end users, with a strong emphasis on an AI-ready architecture optimized for advanced analytics and use by analytical AI agents.
Measures of Success:

 * Reliability: Data is delivered on time and consistently, with minimal disruptions that impact end users.
 * Analytics Readiness: Analytics infrastructure and platforms are well-designed, accessible, and easy to use, enabling teams to answer questions quickly with fewer data issues or downtime.
 * Impact: Infrastructure supports meaningful business decisions and AI initiatives, demonstrated by increased use of trusted datasets and semantic layers, faster delivery of insights, and improved analytics.

Major Duties

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.
Knowledge/Skills


## Related Videos

- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Creating a routing app with Google Maps API from scratch](https://www.wearedevelopers.com/videos/831-creating-a-routing-app-with-google-maps-api-from-scratch)
- [Docker Compose: Rediscovered](https://www.wearedevelopers.com/videos/1978-docker-compose-rediscovered)
- [Remote Driving on Plant Grounds with State-of-the-Art Cloud Technologies](https://www.wearedevelopers.com/videos/251-remote-driving-on-plant-grounds-with-state-of-the-art-cloud-technologies)
- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [Shipping Faster with Less: Render on Cloud Hosting, AI Workloads, and the Future of DevOps](https://www.wearedevelopers.com/videos/1894-shipping-faster-with-less-render-on-cloud-hosting-ai-workloads-and-the-future-of-devops)

## Related Articles

- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [How to Become an AI Engineer](https://www.wearedevelopers.com/magazine/331-how-to-become-an-ai-engineer)
- [Dev Digest 121 - AI goes offline](https://www.wearedevelopers.com/magazine/456-dev-digest-121-ai-goes-offline)
- [Dev Digest 120 - Apple and peers](https://www.wearedevelopers.com/magazine/455-dev-digest-120-apple-and-peers)
- [Best Coding Boot Camps in Germany](https://www.wearedevelopers.com/magazine/237-best-coding-boot-camps-in-germany)