Senior Marketing Data Analyst

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
• Define problem statement and extracts user requirements for Marketing related data analysis.
• Build and maintain Power BI dashboards
• 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.

• Minimum 5-7 years of data analytics/data science experience
• 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.
• Previous experience in Retail, CPG, Marketing, Loyalty/CRM or eCommerce is a plus.

• Bachelor’s degree preferred
• Experience with Agile and Scrum preferred
• Experience with building and implementing analytics models preferred
• Data & Analytics tools;
  Snowflake (preferred), Redshift, or Big Query, Power
  
  BI (preferred), Tableau, or Qlik, Alteryx, Excel, Azure, and Mastercard APT Test/Learn