IT Data & Analytics Intern

TILLAMOOK COUNTY CREAMERY ASSOCIATION•Portland, OR

5d•Onsite

About The Position

The IT Data & Analytics Intern is a summer internship with Tillamook County Creamery Association (TCCA), based in the Portland, Oregon office. The TCCA Summer Internship Program lasts 10 to 12 weeks and gives undergraduate and graduate students the opportunity to contribute to real-world business challenges. In 2027, the Data & Analytics team is focused on migrating Sales, Finance, and Supply Chain data into Microsoft Fabric. The intern will own a scoped piece of that work and collaborate with the team building the modern data environment. Depending on the intern’s skills and interests, work may include building and testing data pipelines in Microsoft Fabric; gathering business needs and documenting technical requirements; using SQL, and optionally Python, PySpark, or DAX, to create reusable data models; developing and publishing Power BI reports and dashboards; exploring AI agents for interacting with data; and supporting data governance, documentation, and quality validation. The internship offers hands-on experience with Microsoft Fabric, Power BI, SQL, GitHub, Jira, and Confluence. The intern will have a mentor on the Data & Analytics team, regular meetings with a manager, and a clear project plan with checkpoints. The program also includes a final presentation to Data & Analytics and IT leadership, as well as cohort activities such as farmer-owner farm tours, product tastings, a cooking class, resume and interview workshops, and sales market tours. The role’s work helps create a central source of trusted data so business users can make decisions faster and more reliably.

Requirements

Be currently enrolled in a bachelor’s program and not due to graduate in the semester prior to the internship.
Have experience and exposure to Power BI and SQL.

Nice To Haves

Study in Data Science, Computer Science, Business Administration, or Data Analytics.

Responsibilities

Contribute to the data modernization project migrating Sales, Finance, and Supply Chain data into Microsoft Fabric.
Build and test data pipelines, load source data into the lakehouse, and organize data for discovery, trust, and reuse.
Meet with business partners to understand their questions and translate them into documented technical requirements.
Use SQL and potentially Python, PySpark, or DAX to transform raw data into clean, reusable data models.
Design, build, and publish Power BI reports and dashboards, including data visualization and performance tuning.
Walk end users through completed reports and dashboards.
Potentially help build AI agents that let business partners interact with their data in Fabric, and help define testing, governance, and measurement approaches.
Document data definitions, validate numbers against source systems, and contribute to data quality and governance standards.
Participate in team stand-ups, sprint work, peer reviews, troubleshooting, business-partner demos, and documentation.
Present a final project to Data & Analytics and IT leadership.