Analytics Engineer Intern

KEEN Footwear•Portland, OR

1d•Onsite

About The Position

The Analytics Engineer Intern will support KEEN’s move from legacy SAP to SAP S/4HANA. Working with analytics engineers, the intern will map legacy data to the new system, validate that key figures reconcile in the data warehouse, and document tables, data lineage, and business logic used for reporting. The role offers hands-on experience with Snowflake, dbt, SQL, Power BI, and SQL Server, and exposure to how data supports inventory and finance at a global footwear brand. This is a 10-week, onsite internship at KEEN’s Global Headquarters in Portland, Oregon, running Monday, June 14 through Friday, August 20. The intern must work 40 hours per week during normal working hours, Monday through Friday, 8:00 a.m. to 5:00 p.m., and may take no more than four total vacation days during the program. Occasional travel in and around the greater Portland area is required.

Requirements

Currently pursuing or recently completed a bachelor’s degree in Information Systems, Business Analytics, Data Science, or a related field.
Must be enrolled in 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 through Friday, 8:00 a.m. to 5:00 p.m., 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.
Must be eligible to work in the U.S. without sponsorship.
Must commit to the 10-week program from mid-June through mid-August and plan no more than four total vacation days during the internship.
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, with attention to detail when preparing presentations, reports, and materials.
Strong organizational skills and ability to prioritize and manage multiple tasks.
Ability to work independently as well as collaboratively with a team.
Ability to perform the essential functions of the role, with or without reasonable accommodation, including using a computer for extended periods.

Nice To Haves

A passion for the outdoors, sustainability, footwear trends, or innovation.
Creativity, detail orientation, and problem-solving ability.
Proactive curiosity, initiative, and enthusiasm for learning.

Responsibilities

Map legacy SAP tables and fields to their SAP S/4HANA equivalents and document 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 which reports need 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 throughout the internship and present findings and recommendations to the team and stakeholders.