Loyalty and CRM Analyst

At Home Group has an immediate opportunity within its marketing organization for a Loyalty and CRM Analyt. 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  Analyst’s primary objective is to design data products that quickly drive incremental value to the Marketing team as they address customer acquisition, retention, and other sales growth initiatives.

The 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.  S/he needs 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.  

Responsibilities:

• 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.
• 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.
• 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.

Strength areas needed:

• Data Analytics
• Data Wrangling
• Data Blending/Integration
• Knowledge of data lifecycle
• Data Integration
• Agile development process
• Proficient in data processing technologies
• SQL

Experience & Desired Qualifications:

• 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, 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 (e.g., 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.

Data & Analytics tools we use:

• Snowflake (preferred), Redshift, or BigQuery
• PowerBI (preferred), Tableau, or Qlik
• Alteryx
• Excel
• Azure

Education:

• BS required; advanced degree preferred