Data Analytics Engineer

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 HQ in Plymouth, MN. Come see why we are a three-time Star Tribune Top Workplaces award winner!

Merchology seeks a Data Analytics Engineer for our Data team. Reporting to the Director of Data, Development, and Sales Operations, the Data Analytics Engineer is a critical role that will play a key part in all aspects of Merchology’s business intelligence efforts. This person will be responsible for data modeling, creating reports, and analyzing data across the sales, marketing, operations, and customer service departments.

A successful Data Analytics Engineer will: 

• Design, execute, and ensure quality of automated reports, live dashboards, and one-off requests using SQL, DBT, Tableau, and Excel
• Build data models using DBT paired with a Snowflake data warehouse environment
• Coordinate with various internal teams to understand and transform raw data sources into data models that can be used for downstream reporting and visualization in BI tools
• Effectively use BI tools, such as Tableau, to visualize and serve data to key stakeholders
• Balance large-scale projects and small-scale requests to provide ongoing value to key stakeholders
• Demonstrate a creative and enthusiastic approach to research
• Willing to take the lead on the requirement gathering and stakeholder management of a project
• Develop and implement reporting on customer segment performance, trends, and key behavior drivers
• Analyze customer demographics, psychographic data, and purchasing behavior to improve segmentation of customer database, marketing campaigns, and sales activities
• Analyze the effectiveness of marketing and sales efforts to ensure best utilization of resources
• Maintain and improve dashboards for sales, marketing, operations, customer service, and management teams
• Be willing to conduct a deep analysis of a topic and use that data to increase the value of Merchology
• Demonstrate a curiosity about data that drives new ideas and new perspectives on how to effectively utilize and create metrics

Requirements

 REQUIRED QUALIFICATIONS

• 5-7 years of experience in an analytical reporting role in sales, marketing, retail, ecommerce, or related field
• Bachelor’s Degree required; preferred in Analytics, Computer Science, Math, Data Science, or Economics
• Must have experience working in a variety of analytics and database programs; Tableau and SQL required 
• Advanced Excel skills a must
• Must have extremely strong analytical skills
• Must be able to communicate findings and business insights to management teams and other stakeholders at all levels of the organization
• Must be able to recommend creative and practical solutions to increase revenue and optimize marketing and sales practices

PREFERRED QUALIFICATIONS

• Working knowledge of Snowflake and general best practices for a data warehouse
• Experience building data models in DBT
• Experience working in HubSpot, Shopify, NetSuite, and Google Analytics
• Experience working in a high growth environment

WHAT WE OFFER

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

• 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

LOCATION

• 3000 Niagara Lane North, Plymouth, MN 55447
• Remote hybrid role: Two at-home days and three onsite days (following completion of training period)

INDUSTRY

• Business to Business E-commerce and Apparel

Merchology is an equal opportunity employer and 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 jobs@merchology.com for assistance.