BI Developer Consultant I
This job is no longer available.
At Allstate, great things happen when our people work together to protect families and their belongings from life's uncertainties. And for more than 90 years, our innovative drive has kept us a step ahead of our customers' evolving needs. From advocating for seat belts, air bags and graduated driving laws, to being an industry leader in pricing sophistication, telematics, and, more recently, device and identity protection.
Job Description
We are seeking a versatile Analytics & BI Specialist to join our EU Operations Analytics team. This role provides crucial analytical support for our EU Operations team, working on key projects to support Supply Chain, Customer Operations, and Customer Experience.
You will be an analytics 'all-rounder', supporting data engineering and data modelling to prepare high-quality datasets for analysis, and supporting the development of front-end visualisations. A key part of your role will be assisting our team with its strategic migration to the Microsoft Fabric platform. This will involve supporting with the move from Tableau to Power BI and contributing to the development of robust data models, and building simple, maintainable pipelines using Python and SQL to transform source data into analysis-ready datasets. The ideal candidate is technically skilled, collaborative, and passionate about using data to solve complex business problems, with a pragmatic approach to data preparation and automation.
Want more jobs like this?
Get Data and Analytics jobs in Bangalore, India delivered to your inbox every week.
● Stakeholder Collaboration: work closely with business stakeholders and lead analysts to understand project requirements and help translate business needs into technical solutions.
● Project Support: assist in the end-to-end delivery of analytics projects, from requirements gathering and data exploration to building, testing, and deploying solutions.
● Data Engineering: Design and build basic pipelines using Python and SQL to ingest, clean, and transform source data into analysis-ready datasets. This includes automating recurring data preparation tasks and improving the reliability and scalability of existing data flows.
● Data Modelling: contribute to the design, build, and maintenance of scalable and efficient data models, using dbt and Microsoft Fabric semantic models.
● BI & Visualisation: Develop, maintain, and enhance dashboards and reports in Power BI to provide actionable insights for the Operations team.
● Migration Support: play an active support role in our analytics transformation, assisting with activities to migrate data pipelines into Microsoft Fabric and transition existing reports from Tableau to Power BI.
● Data Analytics: write complex and efficient SQL queries and use Python where appropriate to extract, manipulate, and analyse large datasets to answer specific business questions.
● Insight Generation: perform deep-dive analyses to identify trends, inefficiencies, and opportunities for operational improvement, presenting findings clearly to the team.
Data Governance: help champion data quality and consistency, ensuring that data is accurate, well-documented, and trusted by the business.
Essential:
- Familiarity with the Microsoft Fabric ecosystem, including Lakehouse and pipelines
- Proven experience in data analytics, business intelligence, or related role
- Advanced SQL skills for data extraction, transformation, and complex querying
- Working experience with Python for data manipulation, automation, and building basic pipelines.
- Strong experience with a modern BI visualisation tool (e.g. Power BI, Tableau)
- Demonstrable experience in data modelling
- Excellent communication and interpersonal skills; you must be comfortable handling 'client-facing' or stakeholder conversations to understand requirements and present findings
- A strong analytical mindset with a high degree of business acumen and a proactive, problem-solving attitude
- Ability to manage multiple tasks and contribute to several projects simultaneously in a dynamic environment
Desirable:
- Experience building or maintaining pipelines in an analytics environment
- Experience with using dbt for data transformation
- Experience with Power BI and writing DAX measures
- Previous experience supporting Operations, Supply Chain, or Customer Experience functions
- Knowledge of data warehousing concepts and cloud data platforms
Knowledge/Education:
Essential:
● Bachelor's degree REQUIRED in Mathematics, Economics, Statistics, Finance, Engineering, or any quantitative background
● 2-4 years' experience in data analytics, business intelligence, or related role
Primary Skills
Shift Time
Shift B (India)
Recruiter Info
Shriya Kumari
skuow@allstate.com
About Allstate
Joining our team isn't just a job - it's an opportunity. One that takes your skills and pushes them to the next level. One that encourages you to challenge the status quo. One where you can shape the future of protection while supporting causes that mean the most to you. Joining our team means being part of something bigger - a winning team making a meaningful impact.
The Allstate Corporation is one of the largest publicly held insurance providers in the United States. Ranked No. 84 in the 2023 Fortune 500 list of the largest United States corporations by total revenue, The Allstate Corporation owns and operates 18 companies in the United States, Canada, Northern Ireland, and India. Allstate India Private Limited, also known as Allstate India, is a subsidiary of The Allstate Corporation. The India talent center was set up in 2012 and operates under the corporation's Good Hands promise. As it innovates operations and technology, Allstate India has evolved beyond its technology functions to be the critical strategic business services arm of the corporation. With offices in Bengaluru and Pune, the company offers expertise to the parent organization's business areas including technology and innovation, accounting and imaging services, policy administration, transformation solution design and support services, transformation of property liability service design, global operations and integration, and training and transition.
Learn more about Allstate India here.
Perks and Benefits
Health and Wellness
- Health Insurance
- Dental Insurance
- Vision Insurance
- Life Insurance
- Long-Term Disability
- Short-Term Disability
- HSA
- FSA
- Mental Health Benefits
- On-Site Gym
- Pet Insurance
- Virtual Fitness Classes
- Health Reimbursement Account
Parental Benefits
- Non-Birth Parent or Paternity Leave
- Birth Parent or Maternity Leave
- Adoption Leave
- Family Support Resources
- Adoption Assistance Program
Work Flexibility
- Remote Work Opportunities
- Hybrid Work Opportunities
- Work-From-Home Stipend
- Four-Day Work Week
Office Life and Perks
- Commuter Benefits Program
- Casual Dress
- On-Site Cafeteria
Vacation and Time Off
- Paid Vacation
- Paid Holidays
- Leave of Absence
Financial and Retirement
- 401(K)
- 401(K) With Company Matching
- Pension
- Financial Counseling
- Relocation Assistance
Professional Development
- Tuition Reimbursement
- Access to Online Courses
- Internship Program
- Promote From Within
- Mentor Program
- Lunch and Learns
- Leadership Training Program
- Associate or Rotational Training Program
Diversity and Inclusion
- Employee Resource Groups (ERG)
- Diversity, Equity, and Inclusion Program
Company Videos
Hear directly from employees about what it is like to work at Allstate.