Data Analytics Consultant (Hybrid)

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. 

Your role in the team

The Data Analytics Consultant I is responsible for leveraging data and analytics to answer moderately complex questions. The position is also responsible for developing standards of practice around data retrieval, data manipulation, data reporting and data analytics.

Key Responsibilities

• Compiles, cleans, organizes and analyzes moderately complex data to understand business results
• Provides technical expertise
• Makes the business insights derived from data analytics accessible to those without technical skills
• Establishes, modifies, documents and communicates standards of practice around data retrieval, data manipulation, data quality, data reporting and data analytics
• Communicates and presents project information to team and provides presentations/updates to management
• Monitors and evaluates business initiatives against key performance indicators and communicates results and recommendations to management

Essential Skills

• All candidates must demonstrate they have a legal right to work in the UK for employment at Allstate. Allstate is not providing sponsorship for this vacancy.
• A minimum of 2 years experience in statistical analysis including predictive and prescriptive analytics
• A minimum of 1 years experience of querying databases (e.g., SQL, Oracle, MongoDB)
• Experience cleaning and transforming raw data into usable formats to ensure accurate and reliable data
• A minimum of 1 year experience with data visualization tools (e.g., Tableau, Power BI) for presenting insights
• Strong programming skills in SQL
• Basic programming skills in Python, PySpark, and/or R

Desirable Skills

• Basic knowledge of Microsoft Fabric
• Basic understanding of data modeling concepts, including normalization, denormalization, and schema design.
• Experience with data warehousing solutions and big data technologies and cloud platforms (Apache Spark, and Apache Kafka, AWS, Dremio)
• Basic understanding of the US Legal System

Supervisory Responsibilities

• This job does not have supervisory duties.

Job Posting End Date: Monday 10th March (11:59pm Midnight)

# LI-CG1 #LI-Hybrid

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.

What we offer

As Digital DNA’s Workplace of the Year 2020 & 2022 winners, we offer a generous benefits package that includes flexible annual leave entitlement, dental and healthcare insurance, an attractive pension package and discounts on gym memberships, public transport and parking. 

Allstate invests heavily in your development, as an employee you will have access to multiple world-class learning platforms and courses from our award-winning in-house Learning & Development team. 

We pride ourselves in providing clear career paths and opportunities for internal mobility allowing you to further develop within the organisation. 

We encourage a better work life balance and you’ll have the opportunity to apply for various flexible working arrangements.

Statement on Fair Employment and Equal Opportunities

Allstate NI wishes to ensure equal opportunity is given to all job applicants.  This company will not discriminate on the grounds of race, gender (including gender reassignment status), sexual orientation, religious belief, political opinion, marital status, age or disability.

We are an equal opportunities employer. We welcome applications from all suitably qualified persons. However, as women are currently under-represented in our workforce, we would particularly welcome applications from women. All appointments will be made on merit. 

Applicants should note Allstate NI complete AccessNI background checks on all candidates offered a position.

Posting End Date:

11 March 2025