Marketing Analyst

About the role

The primary role of this individual will be to build, enhance, and maintain a business intelligence platform to support business intelligence and advanced analytics requirements. The selected candidate will engage with business and operations teams from initial project definition through to project completion and will work on multiple projects. Responsibilities include the development of reporting and analytical solutions, a full suite of documentation, and light application updates to enable such solutions. Deliverables consist of company reporting and dashboard solutions, documentation, light application enhancements, and custom analysis. The results of this work will streamline reporting operations and enable the generation of new insights that will transform Analytics & Insights efforts to support business strategy, as well as marketing and operations.

Responsibilities

• Analyze complex datasets, extracted using SQL, to deliver actionable insights for the Lottery’s digital initiatives to drive good business decisions
• Analyze and benchmark performance across multiple channels and platforms, and provide recommendations for areas of future growth
• Analyze CRM bonus campaign performance and provide recommendations for the generation of new campaigns
• Perform industry monitoring and reporting to keep the management team well informed of interactive market trends and innovations
• Elicit analytical and reporting requirements from the Lottery and work with Product Owners to ensure the requirements are delivered
• Attend the Lottery meetings and internal meetings to stay informed of new requests, features, and improvement areas, and provide support when necessary
• Attend training and conferences as necessary to build knowledge and refine skills
• Coordinate projects or requirement elicitation between the Lottery and vendors, when assigned

Requirements

• 3+ years of experience working within a Marketing Analytics/Business Analytics environment, with a focus on strategy, operations, and marketing data analysis
• Bachelor’s degree or equivalent experience with a focus in Business, Marketing, or Economics preferred
• Knowledge of SQL Server Reporting Services (SSRS) with writing complex SQL Queries
• Advanced Excel (Power Pivot, Power View, Power Query, Pivot Tables, Lookups, etc.)
• Expertise in gathering and documenting internal and external client requirements
• Expertise in analyzing complex data sets and converting them into actionable insights, which drives business decisions
• Experience in ensuring data integrity and validating results, with high attention to detail and accuracy
• Support, advise, and collaborate to deliver ad-hoc reports and data, as necessary to meet the needs of the department
• Experience with the Power BI reporting tools
• Capable of investigating, familiarizing, and master