Analytics Engineer Intern

KEEN; Portland (OR); In loco; USD 25.000 - 36.000; Tempo pieno

Vantaggi offerti da questo lavoro

Product discounts

Subsidized cafeteria

Inspiring workspace

Descrizione del lavoro

KEEN is seeking an Analytics Engineer Intern to work on our SAP S/4HANA migration at KEEN’s Portland headquarters. You’ll gain hands-on experience with Snowflake, dbt, SQL, and Power BI while supporting data quality and reporting initiatives.

The role focuses on mapping legacy SAP data to the new system, validating data in our warehouse, and documenting models and logic for future reporting. This is a 10-week, on-site internship in Portland, OR.

Competenze

• Pursuing or recently completed a bachelor’s degree in IS, analytics, data science, or related field.
• Coursework or project experience writing SQL queries (joins, aggregations, filtering).
• Familiarity with Power BI or Tableau, or advanced Excel skills.

Mansioni

• Map legacy SAP tables to SAP S/4HANA and document differences.
• Write SQL to reconcile legacy data with S/4HANA across Snowflake and SQL Server.
• Investigate data discrepancies with analytics engineers and business users.
• Review Power BI reports and identify dependencies on legacy structures.
• Document new data models, data lineage, and business logic in Confluence.
• Contribute to dbt models and data quality tests.
• Track internship progress and present findings to team and stakeholders.

Conoscenze

SQL

Power BI

Excel

Data visualization

Formazione

Bachelor’s degree in Information Systems

Bachelor’s degree in Business Analytics

Bachelor’s degree in Data Science

Strumenti

Snowflake

dbt

SQL Server

Descrizione del lavoro

Are you passionate about sandals, boots, and everything in between? Do you live and breathe sustainability? Do you have a creative eye, a hunger to learn, and a KEEN interest in the outdoor industry? If you said yes to any of the above, we have the perfect opportunity for you!

Position: Analytics Engineer Intern

Location: KEEN’s Global Headquarters in Portland, Oregon (on-site)

Duration: 10 weeks

Compensation: $22/hour

Program Duration: Monday, June 14th – Friday, August 20th

What You’ll Do

As an Intern at KEEN (KEENtern), you’ll dive into the exciting world of footwear, innovation, and community! You’ll get hands‑on experience working alongside industry experts and contribute to shaping the future of KEEN.

On the Analytics Engineering team, you will help KEEN through one of its most important data initiatives: our move to SAP S/4HANA. You will work alongside our analytics engineers to map how legacy SAP data translates to the new system, confirm that key numbers tie out in our data warehouse, and document the tables and business logic our reporting will rely on for years to come. Along the way, you build practical experience with a modern data stack, including Snowflake, dbt, SQL, and Power BI, and see how data powers everything from inventory to finance at a global footwear brand.

Essential Responsibilities

• Map legacy SAP tables and fields to their 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 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

Minimum Qualifications

• 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. You will also be considered if you have recently graduated from an accredited college or university.
• Must be able to work 40 hours/week during the internship program during normal working hours (Monday–Friday 8:00 AM – 5:00 PM) and be available to work in the office 5 days/week.
• Coursework or project experience writing SQL queries (e.g., joins, aggregations, filtering)
• Familiarity with a data visualization tool such as Power BI or Tableau, or advanced Excel skills (e.g., pivot tables, lookups)
• No prior SAP or ERP experience required

What We’re Looking For

We’re seeking someone who embodies our passion for creativity, sustainability, and the great outdoors. Our ideal KEENtern is:

• Passionate: Whether you’re an outdoor enthusiast, committed to sustainability, or fascinated by footwear trends and innovation, you’re excited to engage with the world around you.
• Creatively Minded: You’re detail-oriented, love bringing fresh ideas to life, and have a knack for solving problems.
• A Strong Communicator: Whether it’s collaborating with a team or presenting ideas, you know how to express yourself clearly and effectively.
• Proactive & Eager to Learn: You’re curious, ready to ask questions, take initiative, and dive into new challenges with enthusiasm.

Why Intern with Us?

Being a KEENtern Means You’re Not Just An Intern—you’re a Valued Part Of Our KEEN Community. Here’s What You Can Look Forward To

• Meaningful Work: Tackle real-world projects that make an impact, gaining valuable hands‑on experience at a globally recognized brand.
• Collaborative Environment: Partner with talented teammates and work on a group project with other KEENterns.
• Networking Opportunities: Build connections with industry experts and mentors who can help shape your career.
• Perks & Benefits: Enjoy product discounts, a subsidized cafeteria, and an inspiring workspace.
• Outdoor Adventures: Immerse yourself in Portland – a vibrant city nestled between the mountains and the coast – a hub for all things outdoors, such as hiking, biking, rafting, camping, and climbing.

Program Requirements

• Be a Junior, Senior, or Graduate student working toward a degree in Information Systems, Business Analytics, Data Science, or a related field
• Be eligible to work in the U.S. without sponsorship
• Commit to a 10-week program from mid-June through mid-August
• Dedicate 40 hours per week during standard M-F work week
• This is an onsite role located at our beautiful headquarters office in Portland, OR
• Plan no more than four total days of vacation during the internship
• Demonstrate proficiency in Microsoft Office programs, including Outlook, Word, and PowerPoint
• Able to learn and adapt quickly to new software and tools
• Demonstrate strong verbal and written communication skills, strong attention to detail in preparation of presentations, reports, and materials
• Demonstrate strong organization skills with the ability to prioritize and manage multiple tasks
• Proven ability to work independently as well as collaborate with a team
• Able to perform the essential functions of the role, with or without reasonable accommodation, including using a computer for extended periods

Travel: Occasional travel in and around the larger Portland area

Other Requirements

Please note this job description is not designed to contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this job. Duties responsibilities and activities may change at any time with or without cause.

Fuerst Group, KEEN and Chrome are equal opportunity employers. We value an inclusive and diverse community. Qualified candidates of all backgrounds are encouraged to apply and will be considered without regard to race, color, religion, sex, national origin, age, sexual orientation, gender identity, gender expression, veteran status, or disability.