Data Analytics Consultant II
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Data Analytics Consultant II using SQL, Power BI, and dashboards to improve Allstate’s insurance workforce and operations. Delivering executive-ready insights, data-quality improvements, and analytical solutions.
Responsibilities:
- Leverage data and analytics to answer moderately complex questions and influence business strategy
- Develop standards of practice around data retrieval, data manipulation, data quality, data reporting, and data analytics
- Coach and develop less experienced analysts
- Communicate and present project information to the team and provide updates to management
- Compile, clean, organize, and analyze moderately complex data to understand business results
- Monitor and evaluate business initiatives against key performance indicators and communicate results and recommendations to management
- Make business insights accessible to non-technical audiences
- Develop and maintain dashboards, reports, and data visualizations for workforce and operational data
- Partner with Workforce Planning, Operations, Reporting, and other stakeholders to gather requirements and deliver analytical solutions
- Monitor data quality, investigate discrepancies, validate outputs, and resolve data issues
- Produce visual analyses and executive-ready reporting on workload trends, staffing impacts, forecast performance, and operational drivers
- Participate in cross-functional projects including requirements gathering, solution design, testing, implementation, documentation, validation, and enhancement
- Maintain documentation, job aids, data definitions, and standards of practice
- Identify opportunities to improve reporting, analytics, data quality, and Workforce Management processes through automation and improved data models
- Support technology outages and operational disruptions by evaluating impacts and communicating insights and recommendations
- Balance recurring reporting and planning responsibilities with ad hoc analysis and project work
Requirements:
- 2 or more years of experience (Preferred)
- Experience with Amazon Web Services (AWS)
- Experience with data analysis and data analytics
- Experience with Microsoft Excel
- Experience with Microsoft Power BI / PBI and data visualization
- Experience with MS SQL queries, SQL database queries, and Structured Query Language (SQL)
- Must submit to a background investigation
- Reliable internet with minimum speeds of 50 MB download and 5 MB upload
- Dedicated, private workspace free from distractions, with appropriate desk and seating when working from home
- Allstate generally does not sponsor individuals for employment-based visas for this position
Benefits:
- Comprehensive technology setup, including a laptop, monitors, headset, keyboard, and mouse
- Monthly connectivity reimbursement to help offset internet costs
- Opportunity to develop skills and challenge the status quo
- Support for causes that mean the most to you
Similar Jobs
Working Student – Business Intelligence, Reporting & Data Analytics
Werkstudent:in supporting Qlik Sense BI reporting, dashboards, and data analytics. Transforming Data Warehouse data and assisting Controlling teams with data quality and user support.
Commercial Analytics Manager – Western US
Commercial Analytics Manager translating sales and syndicated data into growth insights for Palm Bay International’s imported wine and spirits portfolio. Supporting Western U.S. sales teams with Power BI analytics, training, and opportunity analysis.
Commercial Analytics Manager
Commercial Analytics Manager translating syndicated sales data into actionable insights for Palm Bay International’s wine and spirits portfolio. Supporting U.S. sales leaders with Power BI analytics, opportunity analysis, and training.
Analytics Manager, Strategic Accounts
Analytics Manager driving category insights and growth strategies for Palm Bay International’s imported wine and spirits portfolio. Partnering with strategic accounts, sales, distributors, and retail buyers.
Senior Data Analyst – Analytics and Automation
Senior Data Analyst modernizing FP&A reporting, data pipelines, and AI automation for Welo Global’s multilingual AI and content solutions. Building investigative analytics and self-refreshing reporting tools.
Senior Data Analyst
Analista de Dados Sênior mantendo pipelines e desenvolvendo scripts em Azure, Databricks e dbt. Spread Tecnologia oferece soluções de inovação, tecnologia e negócios digitais.
Data Analyst, Disability Operations
Data Analyst developing BI solutions and disability insights for Manulife, an international financial services provider. Transforming data, automating processes, and supporting management decisions.
Commercial Analytics Manager – Western US
Commercial Analytics Manager translating sales and syndicated data into growth insights for Palm Bay International’s imported wine and spirits portfolio. Supporting Western US sales teams with Power BI analytics, training, and strategic recommendations.
Commercial Analytics Manager
Commercial Analytics Manager translating wine and spirits data into actionable sales growth insights for Palm Bay International. Supporting U.S. sales divisions through Power BI analytics, opportunity analysis, training, and executive presentations.
Analytics Manager, Strategic Accounts
Analytics Manager driving category insights for Palm Bay International’s imported wines and spirits portfolio. Partnering with strategic accounts, sales, distributors, and retailers to grow volume and profit.
Commercial Analytics Manager – Western US
Commercial Analytics Manager translating Power BI and syndicated data into actionable sales insights for Palm Bay International’s imported wines and spirits portfolio. Supporting Western U.S. division planning, opportunity analysis, and field training.
Data & Analytics Lead
Data & Analytics Lead building Tapouts’ analytical foundation across growth, product, payments, and coaching operations. Defining metrics, modeling customer journeys, and guiding retention and quality decisions.
Senior GTM Analytics Manager
GTM analytics leader scaling Pebl’s AI-powered global employment platform. Improving revenue operations, marketing systems, pipeline forecasting, and data-driven growth.
Data Analyst, Disability Operations
Data Analyst developing SQL, Power BI, and business intelligence solutions for Manulife’s disability operations. Partnering with operational teams and data scientists to improve insights and automate processes.
Senior Data Analyst
Senior Data Analyst guiding commercial expansion and field operations for Starship Technologies’ autonomous delivery robots. Connecting complex datasets to drive scaling, efficiency, and strategic decisions.
Analytics Manager, Strategic Accounts
Analytics Manager driving category insights and growth strategies for Palm Bay International’s imported wine and spirits portfolio. Supporting strategic accounts through advanced analytics, reporting, and customer engagement.
Commercial Analytics Manager – Western US
Commercial Analytics Manager translating Power BI and syndicated data into actionable insights for Palm Bay International’s imported wine and spirits sales organization. Supporting Western U.S. division performance, opportunity analysis, and data-driven growth.
Commercial Analytics Manager
Commercial Analytics Manager translating syndicated sales data into growth insights for Palm Bay International’s imported wine and spirits portfolio. Supporting U.S. sales leaders with Power BI analytics, training, and performance planning.
Quantitative Analyst – Prediction Markets
Quantitative Analyst researching alpha signals and models for Moreton Capital Partners’ prediction markets fund. Building data pipelines and taking strategies from analysis through live trading deployment.
Senior Financial Data Analyst
Senior Financial Data Analyst leading financial analysis and consulting engagements. Supporting Kodiak’s technology-driven healthcare reconciliation and revenue-cycle solutions.