Note: The job is a remote job and is open to candidates in USA. Allstate is an insurance company focused on protecting families and their belongings from life’s uncertainties. The Data Analytics Consultant I leads complex regulatory data calls and analytical submissions, ensuring accurate, complete, traceable, and defensible deliverables. The role also coordinates cross-team dependencies, manages delivery risk, strengthens validation and documentation standards, and coaches peers.
Responsibilities
- Define execution plans for complex requests, including scope, approach, dependencies, milestones, owners, and quality gates, and lead delivery from intake through final submission
- Translate ambiguous business or regulatory requirements into clear, defensible data logic, validation methods, assumptions, and documentation
- Set and enforce documentation, traceability, validation evidence, and review-readiness expectations for complex or high-risk deliverables
- Lead multi-owner data investigations, align root-cause findings and corrective actions, confirm fixes through validation, and establish controls that reduce recurrence
- Partner directly with stakeholders and upstream data owners to align on definitions, assumptions, timelines, risks, tradeoffs, limitations, and required decisions or approvals
- Provide concise, decision-ready communication on delivery status, methodology, validation outcomes, risks, and recommendations
- Lead peer reviews for complex or sensitive work and provide standards-setting coaching that improves analytical judgment, evidence quality, and delivery consistency
- Develop and improve reusable queries, validation packs, templates, runbooks, playbooks, and shared controls that strengthen repeatability and reduce rework
- This job does not have supervisory duties
Skills
- Bachelor's degree or equivalent relevant experience
- Three or more years of experience delivering regulatory and/or complex analytical data work, including leading workstreams, performing peer reviews, and producing audit-ready documentation
- Demonstrated ability to lead complex deliverables with minimal oversight, coordinate contributors, and make sound decisions about delivery approach and validation depth
- Advanced SQL capability, including reusable query patterns and the ability to review complex logic for accuracy, readability, efficiency, and defensibility
- Experience using analytical and data tools such as Excel, Power Query, Python, R, Microsoft Fabric, Power BI, or comparable tools for data preparation, reconciliation, validation, automation, reporting, or visualization
- Strong knowledge of data quality controls, validation strategy, reconciliation, exception reporting, control totals, anomaly detection, and reviewer-ready evidence packaging
- Experience maintaining source-to-report mappings, assumptions and decision logs, change rationale, audit trails, and shared documentation repositories
- Strong written and verbal communication skills, including the ability to explain methodology, evidence, risks, tradeoffs, and limitations to technical and business stakeholders
Benefits
- Fully remote work arrangement
- 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