Loyalty and CRM Analyst

At Home; Coppell (TX); On-site; USD 80,000 - 110,000; Full time

Job summary

A leading company in the retail sector is looking for a Loyalty and CRM Analyst to enhance data-driven marketing strategies and drive customer engagement. You will design and implement data solutions that provide actionable insights to optimize marketing efforts, requiring expertise in data analysis and SQL. Ideal candidates are detail-oriented, analytical, and enjoy collaborating with cross-functional teams.

Qualifications

• Minimum 4 years of data analyst/data engineering experience.
• Experience with real-time POS data and big data pipelines.
• Strong understanding of cloud data warehouses.

Responsibilities

• Collaborate with Marketing Analytics to build data solutions.
• Conduct ad-hoc data analysis and produce performance reports.
• Identify trends and generate insights for marketing initiatives.

Skills

SQL

Data Analytics

Data Wrangling

Data Integration

Agile development process

Data Visualization

Data Blending/Integration

Data Lifecycle Knowledge

Business Intelligence Tools

Education

BS required; advanced degree preferred

Tools

Snowflake

PowerBI

Alteryx

Excel

Azure

Job description

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