Note: The job is a remote job and is open to candidates in USA. Allstate Insurance Co. is a leader in protecting families and their belongings. The Data Analytics Senior Consultant I will develop and improve predictive models and operational forecasts to support Claims demand and capacity planning, ensuring accurate outputs and process integrity through various analytical solutions.
Responsibilities
- Predictive Modeling and Forecasting: Design, build, populate, own, monitor, and maintain medium- to high-complexity predictive models, including reruns and backfills
- Workflow Development: Build and support Python workflows for operational forecasting, reporting, and scalable analytical solutions
- Data Preparation and Quality: Query and transform datasets using Python and SQL to create feature datasets; perform data validation, reconciliation, and anomaly detection
- Process Improvement: Automate manual and spreadsheet-based processes, identify efficiency opportunities, and implement creative modeling concepts that improve business processes
- Business Partnership: Translate business questions into analytical solutions, provide high-quality data models to support stakeholder performance initiatives, and communicate effectively with stakeholders, product owners, and team members
- Knowledge Sharing: Support peer-to-peer cross-training and help build team capability through collaboration
Skills
- Experience developing, maintaining, or supporting predictive models
- Advanced Python skills for data analysis, feature engineering, workflow development, and model creation
- At least 2 years of hands-on experience with data reporting:
- Advanced SQL (joins, aggregations, window functions)
- Experience working with large or complex datasets
- Experience troubleshooting and debugging analytical processes
- Intermediate to advanced ability to build forecasts and/or technical tools, using a variety of data reporting and visualization software
- Intermediate technical knowledge with data management processes (i.e., data flow within systems, data mapping, etc.) and/or experience with integrating data from multiple sources, including databases, unstructured data, and/or other enterprise data stores
- Comprehensive knowledge of forecast reporting and business knowledge (financial skills, follow the numbers)
- Advanced proficiency in querying, compiling, analyzing, and integrating information from different sources to make data informative and form a recommendation
- Demonstrated ability to work with numbers and develop medium to high complexity formulas
- Advanced PC skills including Excel, PowerPoint, and Word
- Exceptional interpersonal skills to work effectively in a virtual team environment
- Effective time management and organization skills
- Strong oral and written communication skills
- Experience building and implementing short and long-term demand and capacity forecasting models is a plus
Benefits
- Allstate provides a comprehensive technology setup, including a laptop, monitors, headset, keyboard, and mouse.
- Employees eligible to work from home also receive a monthly connectivity reimbursement to help offset internet costs.
Company Overview