At Home Group is looking to solve complex client needs using data and drive incremental value to the Marketing team in areas such as customer acquisition, retention, marketing campaign effectiveness, and sales growth initiatives.
Requirements
- 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.
- Experience with Agile and Scrum preferred
Responsibilities
- 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
- Build and maintain Power BI dashboards
- Develop and presents analysis and reports using data visualization and storytelling best practices.
- Perform data transformation and data analysis on Marketing-related data including email campaigns, SMS campaigns, etc.
Other
- Bachelor’s degree in data analytics, business analytics, information systems or related field preferred.
- Minimum 5-7 years of data analytics/data science experience
- Previous experience in Retail, CPG, Marketing, Loyalty/CRM or eCommerce is a plus.
- Experience supporting and working with cross-functional teams in a dynamic environment.
- Equivalent experience is considered
