Wizards of the Coast (Skeleton Key studio) is looking for a Data Visualization & Analytics Intern to join our Commercial Analytics team. This role transforms complex commercial data into clear, actionable insights that drive strategic decisions. You'll be embedded on the team, trusted with meaningful projects, and gain a behind-the-scenes look at a global play and entertainment company.
What You'll Do
- Design, build, and maintain automated dashboards and reporting tools using Power BI, Power Query, and Excel.
- Modernize legacy Excel macro-based reports by migrating them to scalable, dynamic Power BI solutions.
- Integrate and model data from multiple complex systems and data sources.
- Develop custom DAX calculations and Power Query M transformations to support advanced business logic.
- Maintain dashboards, KPIs, Availability and feasibility trackers.
- Support data validation and input integrity in collaboration with Commercial team members.
- Partner with cross-functional teams to deliver ad hoc analytics and ensure data accuracy.
- Assist the VP of Planning & Operations on specialized analysis tasks, including data entry and system clean-up.
- Identify opportunities to automate repetitive processes and implement solutions to streamline reporting.
What We're Looking For
- Bachelor’s degree or higher in Data Analytics, Computer Science, Information Systems, Statistics, Engineering, or a closely related field.
- 2+ years of experience (including internship or academic project work) in data analysis, reporting, or business intelligence.
- Advanced proficiency in Microsoft Excel, including VBA/macros, pivot tables, and dynamic formulas.
- Hands-on experience with Power BI and Power Query, including M language and DAX for advanced data transformation.
- Experience working with Databricks for data querying, preparation, and analytical support.
- Proven ability to consolidate and normalize data from multiple complex systems to create unified dashboards.
- Demonstrated ability to translate business needs into structured, scalable analytics tools in a commercial or retail environment.
- Strong attention to detail, process accuracy, and organizational skills.
- Ability to manage competing priorities and collaborate cross-functionally in a dynamic team.
- Experience working in consumer goods, retail, or commercial planning functions.
Nice to Have
- Familiarity with SQL, Python, or R for data preparation and light automation.
- Experience assisting with cross-functional system transitions or modernization efforts.
- Strong communication skills with the ability to visualize and explain complex data outputs to non-technical users.
Technical Stack
- Power BI
- Power Query
- Excel
- DAX
- Databricks
- SQL
- Python
- R
Team & Environment
This role is embedded directly on the Commercial Analytics team, collaborating with stakeholders across the Commercial organization. You will report to the VP of Planning & Operations.
Benefits & Compensation
- Exposure to professional development sessions, networking opportunities, and leadership engagement.
Wizards of the Coast is an equal opportunity employer.
