Senior Marketing Data Analyst

JOB SUMMARY 

At Home Group has an immediate opportunity within its marketing organization for a Marketing Data Senior 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 Senior 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 Senior 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, analytical, and like helping teams implement data-driven decisioning and analytics in marketing activation campaigns to personalize marketing communications.   

ESSENTIAL FUNCTIONS 

• Must be comfortable with executing reporting and analysis as well as being a strategic advisor who can help marketing teams activate based on results. 

• Work collaboratively with Marketing Analytics team members to build consistent, accurate, and available data solutions.  

• Independently receive and conduct ad-hoc data analysis and reporting requests that require data blending from multiple data sources and provide strategic guidance on how to activate marketing programs based on the results. 

• Analyze and assess the productivity of loyalty offers including profitability and incrementality 

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

• Build and maintain Power BI dashboards 

• 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 data analytics, business analytics, information systems or related field preferred. Equivalent experience is considered.  

• Minimum 5-7 years of data analytics/data science experience  

• Has written complex SQL statements to extract and transform data for consumption and uses SQL on a regular, ongoing basis 

• 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 and maintained Power BI dashboards consistently used by non-technical team members 

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

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

• 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 

• Experience with building and implementing analytics models preferred 

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

WHO WE ARE