Analytics Engineer Intern

KEEN Footwear•Portland, OR

1d•Onsite

About The Position

The Analytics Engineer Intern will join KEEN’s Analytics Engineering team at its Global Headquarters in Portland, Oregon, for a 10-week internship. The intern will support KEEN’s move from legacy SAP to SAP S/4HANA by mapping legacy data to the new system, validating data in the warehouse, and documenting the tables, lineage, and business logic used for reporting. The role offers hands-on experience with Snowflake, dbt, SQL, and Power BI, and exposure to how data supports inventory and finance at a global footwear brand. The internship runs from Monday, June 14th through Friday, August 20th, with a stated compensation of $22 per hour. It is an on-site role requiring 40 hours per week during normal Monday–Friday working hours, with occasional travel in and around the Portland area. Interns will track their progress and present findings and recommendations to the team and stakeholders.

Requirements

Currently pursuing or recently completed a bachelor’s degree in Information Systems, Business Analytics, Data Science, or a related field.
Must be enrolled at an accredited college or university at the Junior, Senior, or Graduate level, or have recently graduated from an accredited college or university.
Must be able to work 40 hours per week during the internship, Monday–Friday, 8:00 AM–5:00 PM, and work in the office five days per week.
Coursework or project experience writing SQL queries, such as joins, aggregations, and filtering.
Familiarity with a data visualization tool such as Power BI or Tableau, or advanced Excel skills such as pivot tables and lookups.
Be eligible to work in the U.S. without sponsorship.
Commit to the 10-week program from mid-June through mid-August and plan no more than four total vacation days during the internship.
Demonstrate proficiency in Microsoft Office programs, including Outlook, Word, and PowerPoint.
Ability to learn and adapt quickly to new software and tools.
Strong verbal and written communication skills and attention to detail in preparing presentations, reports, and materials.
Strong organization skills and the ability to prioritize and manage multiple tasks.
Ability to work independently as well as collaborate with a team.
Ability to perform essential functions, with or without reasonable accommodation, including using a computer for extended periods.

Nice To Haves

Passion for outdoor activities, sustainability, footwear trends, or innovation.
Creative, detail-oriented approach and interest in solving problems.
Strong communication and presentation abilities.
Curiosity, initiative, and eagerness to learn.

Responsibilities

Map legacy SAP tables and fields to SAP S/4HANA equivalents, documenting structural and business-logic differences.
Write SQL to reconcile legacy and S/4HANA data across Snowflake and SQL Server, including row counts, key metrics, and financial and inventory tie-outs.
Investigate and log data discrepancies, partnering with analytics engineers and business users to identify root causes.
Review Power BI reports to identify dependencies on legacy SAP structures and recommend reports for rework or retirement.
Document new source tables, data lineage, and business logic in Confluence as new data models are built.
Contribute to dbt models and data quality tests with guidance from the Analytics Engineering team.
Track progress during the internship and present findings and recommendations to the team and stakeholders.