At Home Group is looking for a Marketing Data Analyst to design data products that drive incremental value to the Marketing team by addressing customer acquisition, retention, marketing campaign effectiveness, and other sales growth initiatives.
Requirements
- 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
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.
Other
- Bachelor’s degree in Marketing, Business, or Data Analytics preferred
- Minimum 4 years of data analyst/data engineering experience
- 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.
