Analytics Engineer Intern

About the role

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

To qualify for this internship, you must

• 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

Ready to Take the Next Step?

If you're ready to take your passions to the next level and be part of a world-class team, please apply.

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.