Analytics Engineer Intern
At a glance
- Pay
- $22/hr
- Location
- Portland, OR
- Work type
- Onsite
- Visa sponsorship
- Not offered
- Category
- Data
Analytics Engineer Intern at KEEN, onsite in Portland, OR, for a 10-week program with $22/hour compensation.
What they are looking for
Location: Portland, OR Department: Information Technology
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