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 our business and operations teams from initial project definition through to project completion and will engage on multiple projects. Primary responsibilities will include the development of reporting and analytical solutions, a full suite of documentation, as well as some light application updates to enable such solutions.
Deliverables include company reporting and dashboard solutions, documentation, light application enhancements, and custom analysis. The results of your work will allow us to streamline our reporting operations and enable the generation of new insights that will allow us to transform our Analytics & Insights efforts to support business strategy, as well as marketing and operations.
What You'll Do:
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
What We're Looking For:
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
Expe