ENT-Data Analytics-Cons I

At Allstate, great things happen when our people work together to protect families and their belongings from life's uncertainties. And for more than 90 years our innovative drive has kept us a step ahead of our customers' evolving needs. From advocating for seat belts, air bags and graduated driving laws, to being an industry leader in pricing sophistication, telematics, and, more recently, device and identity protection.

Job Description
We are seeking a skilled Business Analyst with 2-4 years of experience in marketing analytics and dashboard development. The role involves conducting moderately complex business and technical analyses, developing advanced dashboards using Power BI and Tableau, and extracting actionable insights to inform marketing strategies.
The ideal candidate will have strong proficiency in SQL, Python, and data visualization tools, with a solid understanding of direct and digital marketing analytics, including A/B and multivariate testing. Responsibilities include managing multiple projects, collaborating across teams, mentoring junior staff, and presenting data-driven recommendations to stakeholders.

Key Responsibilities:

• Review and research moderately complex business, operational, and technical challenges that require an in-depth evaluation of variable factors
• Perform complex to moderately complex analysis on marketing related data
• Develop and maintain complex Power BI and Tableau dashboards
• Extract actionable insights from data to inform marketing strategy and drive measurable growth
• Plan, coordinate, and execute analysis in conjunction with your peers and managers for your primary and secondary stakeholders
• Clearly communicate key findings and recommendations to stakeholders, translating complex data into actionable business strategies
• Manage multiple projects simultaneously, ensuring on-time campaign measurement, accurate reporting and effective communication with stakeholders
• Participate on large cross group projects and mentor less experienced staff

• 2-4 years of experience in dashboarding and analytics
• Expertise in marketing analytics, with proficiency in tools such as SQL, Python, Advanced Excel, Tableau and Power BI
• Experience in data visualization and presentation techniques for executive level reporting (Using Tableau, Power BI or any other visualization tool)
• Experience in Direct and Digital Marketing, with a strong focus on data analytics, A/B testing, multivariate testing, and performance optimization
• BS/BA degree or higher in a quantitative field such as applied math, statistics, engineering, physics, accounting, finance, economics, econometrics, computer sciences, or business/social and behavioral sciences with a quantitative emphasis

• Excellent written and verbal communication skills, capable of influencing stakeholders and presenting data-driven recommendations effectively

• Knowledge and understanding of complex databases
• Experience in data wrangling and complex SQL writing
• Knowledge and understanding of Marketing related data (Good to have)
• 2+ years Python or R (Good to have)
• 3+ years hands on experience performing data analysis (Good to have)
• Experience with text mining and text analytics (Good to have)
• Experience using statistical tools to interpret data sets, identifying correlations, trends and patterns (Good to have)

• Experience with iterative development approach (Agile)
• Experience with source control (GitHub)
• Experience with issue and project tracking (JIRA)