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 Senior Consultant partners with Finance teams to translate complex business needs into scalable, data-driven solutions and leads analytics projects through implementation. The role delivers trusted datasets, semantic models, reporting solutions, and actionable insights using financial and technical expertise.
Responsibilities
- Lead complex analytics initiatives from requirements through delivery, validation, and implementation
- Partner with Finance teams to translate business questions and financial processes into clear data and solution requirements
- Build scalable analytics solutions using SQL, Power BI, Microsoft Fabric, Python, and advanced Excel
- Develop and maintain trusted datasets, semantic models, calculations, and reporting solutions
- Validate data sources, business rules, and financial metrics to ensure accurate and consistent results
- Support migration from legacy data sources and tools to modern Fabric-based solutions
- Establish best practices for data sourcing, transformation, quality, documentation, governance, and reporting
- Coach analysts and enable Finance teams through technical consultation, training, and reusable solutions
- This job does not have supervisory duties
Skills
- 3 or more years of relevant experience in data analytics, business intelligence, financial analysis, or a related field
- Experience delivering complex analytics solutions from requirements through implementation
- Business and Financial Acumen
- Data Analytics
- Consulting
- SQL
- Power BI
- Microsoft Fabric
- Python or PySpark
- Semantic Modeling
- Data Visualization
- Data Quality
- Data Governance
- Advanced Excel
- Stakeholder Management
- Technical Coaching
- Experience working with Finance, insurance, or other business partners is preferred
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