Data Analytics Engineer

Full-time

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

3-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:

The estimated range for On-Target Earnings in this role is $100,000 to $130,000. On-Target Earnings consist of a combination of annual base pay and a variable bonus based on company performance

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 for assistance.