At a Glance
- Tasks: Design and build data infrastructure for real-time analytics and decision-making.
- Company: Join Allstate, a leader in innovative insurance solutions for over 90 years.
- Benefits: Enjoy competitive salary, flexible working, and comprehensive health benefits.
- Other info: Collaborative team environment with opportunities for mentorship and professional growth.
- Why this job: Make a real impact by optimising data for customer offers and market responsiveness.
- Qualifications: 3+ years in data engineering with strong skills in Python, SQL, and modern data frameworks.
The predicted salary is between 60000 - 80000 £ per year.
Your role in the team At Allstate, great things happen when our people work together to protect families and their belongings from life’s uncertainties. We are building a next-generation insurance analytics platform that powers real‑time offer optimization, market sensing, and model‑driven decision‑making across our personal lines products. This role is responsible for designing and building the data infrastructure in Microsoft Fabric that standardizes, integrates, and delivers the data our actuarial, data science, and product teams depend on.
Key Responsibilities:
- Design, develop, and enhance scalable data pipelines and data processing systems.
- Build reusable ingestion, transformation, and storage patterns to support product and analytical needs.
- Integrate data from diverse sources including APIs, databases, event streams, and third‑party systems.
- Implement data models and schemas that create unified, consistent views of business operations.
- Apply modern engineering practices, including version control, testing, CI/CD, and automated deployments.
- Ensure data quality, integrity, and reliability through validation, monitoring, and observability tools.
- Optimize data workflows for performance, cost efficiency, and operational resilience.
- Document data flows, lineage, and technical components in support of transparency and maintainability.
- Collaborate closely with product managers, engineers, and analysts to understand data requirements.
- Participate in iteration planning, ensuring shared understanding of backlog items and technical needs.
- Engage in daily stand‑ups, retrospectives, and product ceremonies as an active member of the team.
- Contribute to data governance practices such as metadata management and data lineage.
- Ensure compliance with data privacy, security, and regulatory requirements.
- Evaluate new technologies, frameworks, and patterns to improve data infrastructure and engineering capabilities.
- Share knowledge and mentor less experienced engineers, contributing to team growth and best practices.
Essential Skills:
- A minimum of 3 years experience in a related field developing sophisticated big data pipelines in support of machine learning and advanced analytics.
- Strong proficiency with data pipeline development in Python, Java, or Scala.
- A minimum of 3 years’ experience with modern data frameworks (Spark, Kafka, Flink, dbt, or equivalent).
- A minimum of 3 years’ experience with SQL and NoSQL databases and data modeling principles.
- Proven ability to optimize SQL, pipelines, and storage for performance and cost.
- Experience building batch and/or streaming data solutions.
- Experience using Microsoft Fabric Notebooks to develop, debug, and operationalize data engineering workflows.
Desirable Skills:
- A degree of any level in a quantitative field such as mathematics, physics or computer science with classification of 2.1 or higher (or equivalent).
- Experience with cloud data services (Azure, AWS).
- Experience with observability and monitoring tools.
- Hands‑on experience with Microsoft Fabric components, including Lakehouse, Warehouse, Data Pipelines, Dataflows Gen2, and Semantic Models.
- Familiarity with CI/CD pipelines (Jenkins, GitHub Actions, Azure DevOps, etc.).
- Performance tuning for data pipelines, databases, and queries.
- Familiarity with generative and agentic AI tools to improve engineering productivity.
- Experience with containerization and orchestration tools (Docker, Kubernetes).
Supervisory Responsibilities: This job does not have supervisory duties.
Benefits: As well as receiving a competitive annual salary, our reward package includes:
- Corporate bonus scheme
- Pension scheme
- Annual performance‑related pay reviews
- Life assurance and income protection
- Flexible working options
- Hybrid working
- Private medical and dental insurance
- Access to an employee assistance programme
- Discounted gym membership
- Two paid volunteering days each year
- Cycle to work scheme
Data Analytics Engineer- Senior Consultant II in Belfast employer: Allstate Insurance Company
At Allstate, we pride ourselves on fostering a collaborative and innovative work environment where our employees can thrive. As a Senior Data Analytics Engineer, you will be part of a forward-thinking team dedicated to building cutting-edge data infrastructure that directly impacts our customers' experiences. With a strong focus on employee growth, flexible working options, and a comprehensive benefits package, Allstate is committed to supporting your professional journey while making a meaningful difference in the lives of families across the nation.
Contact Details:
Allstate Insurance Company Recruitment Team
