remote
Senior Consultant - Enterprise Reports, Automation & Dashboards - Allstate Insurance
Software Engineer
Senior consultant driving enterprise financial and operational reporting, automating data pipelines, and building interactive dashboards using Python, SQL, Power BI, and ETL tools to ensure data integrity and timely insights.
About the role
Key Responsibilities
- Design, develop, and maintain automated data pipelines that transform raw data into reliable financial and operational reports.
- Build and optimize Power BI dashboards, ensuring they meet stakeholder requirements and provide actionable insights.
- Collaborate with cross‑functional teams to define data models, validate data quality, and implement best practices for data governance.
- Leverage Python and SQL to extract, cleanse, and analyze large datasets, delivering accurate and timely reporting.
- Document processes, create user guides, and provide training to end users on reporting tools and data interpretation.
Requirements
- 5+ years of experience in data reporting, automation, and dashboard development.
- Proficiency in Python, SQL, and Power BI with a strong understanding of ETL concepts.
- Experience designing data models and ensuring data integrity across enterprise systems.
- Excellent communication skills and ability to translate complex data into clear business insights.
- Strong problem‑solving skills and a proactive approach to process improvement.