Data Analytics - Consultant II / Senior Consultant I
About The Position
This is a multi-level opportunity posted at two levels: Data Analytics Consultant II and Data Analytics Senior Consultant I. The final placement, title, and compensation will depend on the selected candidate's skills, experience, and qualifications. The position is on a high-visibility analytics team that influences distribution strategy across Allstate. The role involves using data, reporting, visualization, and storytelling to influence decisions, improve performance, and help leaders solve business challenges. The Distribution Analytics Team partners with sales, strategy, and business leaders to deliver analytics, reporting, and actionable insights that improve agency performance and support profitable growth. They aim to help the business understand what is happening, why it is happening, and what actions to take next. Key stakeholder groups include Field Sales Organization, Distribution Strategy and Business Architecture, Program and Deployment teams, and Distribution and Agency leadership partners.
Requirements
- 1+ years of experience in analytics, reporting, business intelligence, or a related discipline (for Consultant II).
- Working knowledge with SQL.
- Experience building dashboards and reports using Power BI or a similar tool.
- Ability to communicate findings clearly to technical and non-technical audiences.
- Ability to organize work, manage priorities, and deliver multiple assignments.
- 3+ years of experience in analytics, reporting, business intelligence, or a related discipline (for Senior Consultant I).
- Strong SQL and advanced data analysis skills.
- Experience building and improving dashboards, reports, and performance measurement solutions using Power BI or a similar tool.
- Identify meaningful trends and communicate insights.
- Experience independently leading multiple analytics projects and influencing business decisions through insights.
Nice To Haves
- Bachelor's degree in Business, Analytics, Finance, Statistics, Computer Science, or a related field.
- Experience in insurance, sales, distribution, or financial analytics.
- Experience with Microsoft Fabric, Azure, or data lakehouse environments.
- Working knowledge of Python, R, or another programming language.
- Experience influencing business strategy through data-driven insights.
Responsibilities
- Analyze business questions and deliver actionable insights.
- Compile, organize, query, and analyze large datasets from multiple sources.
- Identify trends, risks, opportunities, and performance drivers.
- Build and enhance Power BI dashboards, reports, KPI scorecards, and performance measurement tools.
- Use SQL to query and manipulate data and create analytics-ready datasets.
- Apply data quality and governance best practices.
- Monitor business performance and evaluate key initiatives.
- Partner with stakeholders to identify opportunities and solve business challenges.
- Present findings through clear visualizations, data storytelling, and business-focused recommendations.
- Manage multiple analytics assignments and contribute to continuous improvement and analytics best practices.
- Complete analyses, recurring reporting, dashboard enhancements, and performance measurement assignments.
- Work with stakeholders to clarify business questions, gather requirements, and translate needs into analytical outputs.
- Apply established analytical methods, data standards, and governance practices.
- Identify meaningful trends and communicate practical recommendations to team members and business partners.
- Present findings to team members, project partners, and business stakeholders.
- Complete complex analyses, recurring reporting, dashboard enhancements, and performance measurement assignments.
- Partner with business leaders and cross-functional stakeholders to frame problems and identify opportunities.
- Connect insights across datasets, initiatives, and performance indicators to explain business drivers.
- Develop recommendations that influence strategy, priorities, and business action.
- Anticipate data quality, governance, and measurement risks and guide practical solutions.
- Contribute analytics best practices and help strengthen the quality and consistency of team deliverables.
Benefits
- Comprehensive technology setup, including a laptop, monitors, headset, keyboard, and mouse.
- Monthly connectivity reimbursement for employees working from home.
- Opportunity to shape the future of protection.
- Support for causes that mean the most to you.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
Associate degree
