About the position
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.
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.
- 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.
Requirements
- 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 (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
Nice-to-haves
- 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
