Data Analytics Consultant II: Turn Data into Impact

Allstate Northern Ireland Limited; Northern (KY); Hybrid; USD 70,000 - 121,000; Full time

Job summary

Allstate Northern Ireland Limited is seeking a Data Analytics Consultant II or Senior Consultant I to turn data into insights and shape distribution strategy. You will analyze questions, build dashboards, and partner with sales, strategy, and business leaders to influence decisions.

The role requires SQL proficiency, Power BI expertise, and ability to communicate complex findings to both technical and non-technical audiences.

Qualifications

• 1+ years of experience in analytics, reporting, BI, or related field.
• Working knowledge with SQL.
• Experience building dashboards and reports using Power BI or similar tool.

Responsibilities

• Analyze business questions and deliver actionable insights.
• Compile, organize, query, and analyze large datasets from multiple sources.
• Identify trends, risks, opportunities, and performance drivers.
• Build and enhance Power BI dashboards, reports, KPI scorecards, and performance measurement tools.
• Use SQL to query and manipulate data and create analytics-ready datasets.
• Present findings through clear visualizations and data storytelling.

Skills

SQL

Power BI

Analytics

Communication

Dashboards

Time management

Education

Bachelor's degree in Business/Analytics/CS

Tools

Microsoft Fabric

Azure

Data Lakehouse

Job description

Allstate Northern Ireland Limited is seeking a Data Analytics Consultant II or Senior Consultant I to turn data into insights and shape distribution strategy. You will analyze questions, build dashboards, and partner with sales, strategy, and business leaders to influence decisions.

The role requires SQL proficiency, Power BI expertise, and ability to communicate complex findings to both technical and non-technical audiences.