Senior Marketing Data Analyst

• 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.

• 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.
  

• Bachelor’s degree in data analytics, business analytics, information systems or related field preferred. Equivalent experience is considered.

• 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.

• 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

• Experience with building and implementing analytics models preferred

• Data & Analytics tools; Snowflake (preferred), Redshift, or BigQuery , PowerBI (preferred), Tableau, or Qlik, Alteryx, Excel, Azure, and Mastercard APT Test/Learn
  

WHO WE ARE