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
Reporting to the Analytics Lead for the Partnerships functional area, the Data Analyst will be responsible for a wide range of responsibilities including company-wide data modelling, business intelligence and decision support for the Partnerships team.
You will build and maintain Tableau dashboard solutions for the Partnerships functional area and contribute to the Analytics delivery road-map as required. Your key initial focus will be to take over data modelling tasks, the daily and weekly dashboard updates and deliver on dashboard change requests, with a longer-term goal of supporting all ad-hoc or business queries as required.
Key Responsibilities
- Develop and maintain data models using dbt and SQL that are efficient, scalable, and reliable.
- Run Python scripts as part of the dashboard update process
- Encourage self-service analytics and consistent, high-quality metrics by building and maintaining Tableau Dashboards (e.g. bugs, visualisations, calculated fields)
- Migration of Tableau Prep flow logic to Python
- Collaborate with stakeholders at all levels of the business to understand their data needs and deliver solutions to meet the expectations.
- Maintain documentation, manage change and technical debt, and ensure that our stack can scale.
Create and update JIRA tickets as part of project and task tracking
Job Requirements
- Data Modelling for modern cloud data warehouses (e.g. Snowflake, BigQuery, Databricks)
- dbt experience
- Intellectually curious and passionate about asking questions
- Analytical
- Keen to solve problems
- Meticulous and detail oriented
- Strong collaborative and interpersonal skills; ability to build effective working relationships with internal and external parties
- Eager to contribute and get things done
- Able to work with a high degree of independence and exercise good judgement
- Experience in Tableau Desktop and any data flow tools (like Tableau Prep, Alteryx or similar)
- Experience in building and maintaining dashboards
- Experience in SQL to query and perform analysis
Desirable:
- Experience in data modelling to design, build and maintain reporting structures in a database
- Experience in R/Python and deploying production code
- Data Science exposure through direct involvement or building data pipelines / models for it
Airflow to orchestrate data ingestion and transformation tasks
These are key requirements we will be asking specific questions about
Tableau development experience is also very important (together with other data visualisation tools as a bonus)
Primary Skills
Customer Centricity, Digital Literacy, Inclusive Leadership, Learning Agility, Results-Oriented
Shift Time
Shift B (India)
Recruiter Info
Annapurna Jha
[Confidential Information]
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. And one where you can impact the future for the greater good.
You'll do all this in a flexible environment that embraces connection and belonging. And with the recognition of several inclusivity and diversity awards, we've proven that Allstate empowers everyone to lead, drive change and give back where they work and live.
Good Hands. Greater Together.
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.
