Marketing Data Analyst

JOB SUMMARY

At Home Group has an immediate opportunity within its marketing organization for a Marketing Data Analyst. This role is expected to understand complex client needs that can be solved or further informed with the use of data and implement those solutions. The Marketing Data Analyst’s primary objective is to design data products that quickly drive incremental value to the Marketing team as they address customer acquisition, retention, marketing campaign effectiveness and other sales growth initiatives.

The Marketing Data Analyst will collaborate with business users, Analytics peers within Marketing and across the Enterprise to maximize the value of insights and shared resources to benefit At Home.They will need to understand common challenges in data structures and strategies to build data products in an extensible, scalable, and performant manner. You would enjoy this role, if you are detail-oriented, logical, and analytical, and like helping organizations drive data-driven cultures to improve operations and solve important business problems, especially with technology.

ESSENTIAL FUNCTIONS

Independently receive and conduct ad-hoc data analysis and reporting requests that require data blending from multiple data sources.

Calculate incrementality of loyalty offers

Define problem statement and extracts user requirements for Marketing related data analysis.

Develop and presents analysis and reports using data visualization and storytelling best practices.

Produce necessary documentation to ensure consistency, quality, and transparency across the enterprise.

Perform data transformation and data analysis on Marketing-related data including email campaigns, SMS campaigns, etc.

Identify underlying trends or patterns and generate meaningful insights / recommendations for the business.

Participate in data quality issue analysis and resolution recommendations.

Collaborates with peer analysts across the enterprise to ensure data accuracy, consistency, and trust from internal customers.

QUALIFICATIONS

Bachelor’s degree in Marketing, Business, or Data Analytics preferred

Minimum 4 years of data analyst / data engineering experience

Has profiled, explored, and combined datasets in a cloud data warehouse

Experience with real-time POS data, email and SMS campaign data, big data pipelines, structured, semi-structured, and unstructured datasets

Has independently created performance reports / dashboards consistently used by non-technical team members

Has produced documentation to aid business users, IT users, and administrators (., source to target mappings, data lineage, data dictionaries, data source profiles, in-line code commentary).

Has written complex SQL statements to extract and transform data for consumption

Has tuned and improved performance of queries using strategies such as indexing, subqueries, and temp tables.

Proficiency with Business Intelligence Tools

Previous experience in Retail, CPG, Marketing, Loyalty / CRM or eCommerce is a plus.

Experience with Agile and Scrum preferred.

Experience supporting and working with cross-functional teams in a dynamic environment.

Knowledge of data lifecycle

Skilled in data analytics, data wrangling, data blending / integration, data processing technologies, and agile development processes

Data & Analytics tools; Snowflake (preferred), Redshift, or BigQuery, PowerBI (preferred), Tableau, or Qlik, Alteryx, Excel, Azure, and Mastercard APT Test / Learn