Data Reporting Analyst Intern na Merchology

Description

Mur-chol-uh-jee | The science of company merch; the skill of creating and delivering custom-branded apparel and corporate gifts around the world.

Merchology is a leading eCommerce retailer in B2B sales of co-branded merchandise including apparel, headwear, drinkware, gifts, and accessories. We are family-owned, people-powered, and we are adding to our #MerchFam at our facility in Plymouth. Come see why we are a three-time Star Tribune Top Workplaces award winner!

Merchology is in pursuit of a Data Reporting Analyst Intern to join our Development Operations team. This individual will play a key role in transforming raw data into meaningful insights. They will support the design, development, and maintenance of dashboards, reports, and analytics using tools such as Power BI, Tableau, and Excel and will collaborate closely with business stakeholders and data engineers.  

PRIMARY RESPONSIBILITIES

A successful Data Reporting Analyst Intern will: 

Data Management & Reporting

• Develop, maintain, and automate dashboards and reports using Power BI, Tableau, or similar visualization tools 
• Support the collection, cleaning, and transformation of data from multiple sources, including Snowflake, SQL databases, and Excel 
• Assist with the creation and maintenance of data models and data pipelines 
• Ensure data accuracy, consistency, and integrity across reports and systems 
• Perform ad-hoc analysis to support business decisions and identify actionable insights

Analytics & Insights 

• Analyze trends and performance metrics across departments to support strategic initiatives  
• Help define and track key performance indicators (KPIs) to measure business performance 
• Translate data findings into clear visualizations, summaries, and recommendations for stakeholders 
• Collaborate with teams to understand reporting needs and propose analytical solutions 

Data Governance & Quality 

• Support data quality assurance by validating datasets, reports, and visualizations 
• Document data sources, metrics definitions, and reporting processes 
• Assist in improving data governance and standardization practices across the organization 

Application & Platform Administration

• Administer internal collaboration platforms including Microsoft 365 and SharePoint Online
• Assist in software license tracking, renewals, and audits

Collaboration & Communication 

• Work with cross-functional teams (Finance, Operations, Sales, Marketing) to gather reporting requirements 
• Present findings in clear, concise formats to technical and non-technical audiences 
• Maintain documentation of report logic, queries, and visualizations for knowledge sharing 

Requirements

REQUIRED QUALIFICATIONS

• Currently pursuing or recently completed a Bachelor’s Degree or Higher in Data Analytics, Information Systems, Computer Science, or related field 
• Familiarity with data visualization tools (e.g., Power BI, Tableau) 
• Proficiency in Excel, including advanced formulas, pivot tables, and charts 
• Basic SQL knowledge for querying relational databases 
• Strong analytical mindset with attention to detail and data accuracy

PREFERRED QUALIFICATIONS

• Experience with cloud data platforms such as Snowflake or Azure Synapse 
• Familiarity with ETL processes and data modeling concepts 
• Knowledge of Python or R for data analysis or automation 
• Ability to manage multiple projects and prioritize tasks effectively 
• Clear communicator who can turn data into meaningful business insights

WHAT WE OFFER

In addition to an outstanding creative culture, authentically nice people, and interesting work, we have:

• The pay range for this position will be between $20-$30 an hour
• Generous PTO (18 days per year)*
• 8 company-paid holidays*
• Hybrid work schedule for select departments
• 40 hours of paid volunteer time*
• 401(k) with match*
• Medical and dental insurance options, FSA, and HSA*
• Company-paid life insurance and short-term disability*
• Company-sponsored social events
• Premium brand partner discounts
• Employee-led Committees in Social Events, Wellness, DE&I and Giveback

               * denotes full-time permanent employee benefits

LOCATION

• 3000 Niagara Lane North, Plymouth, MN 55447
• Remote hybrid role: Three days onsite and two days remote following training

INDUSTRY

• Business to Business eCommerce and Apparel

Merchology is an equal opportunity employer and certified Disability-owned Business Enterprise. We celebrate diversity and are committed to a workplace where personal and professional growth are achieved through inclusion. If you require disability resources to submit your application, please email [email protected] for assistance.