[Remote] Data Analytics Senior Consultant I

Note: The job is a remote job and is open to candidates in USA. Allstate is a well-established insurance company dedicated to protecting families and their belongings. They are seeking a Data Analytics Senior Consultant I to develop and maintain predictive models and operational forecasts that support Claims demand and capacity planning, while also improving data visualization and business intelligence 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
• Experience building and implementing short and long-term demand and capacity forecasting models is a plus
• 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

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