Data Analyst Engineer

AXIS Capital; Halifax; Hybrid; CAD 75,000 - 120,000; Full time

Benefits offered by this job

Medical plans for you and family

Health and wellness programs

Retirement plans

Tuition reimbursement

Paid annual leave

Job summary

AXIS Capital is seeking a Data Engineer to join the Data & Analytics team within Platforms & Transformation. You will work on data products, data flows, and quality rules with business and technology partners.

The role blends data analysis and engineering across on-premises and cloud environments, with a strong emphasis on collaboration and delivering value to AXIS. The ideal candidate has 4+ years in data engineering, strong SQL/Excel skills, and experience with data modelling, governance, and

Qualifications

• Bachelor’s degree in computer science, IT, or related field or equivalent work experience.
• 4+ years as a Data Engineer or similar data-focused role.
• Strong SQL and Excel experience.
• Design experience with star schemas and delta concepts.
• Experience with data modelling in Excel and data governance frameworks.
• Excellent problem-solving and communication skills.
• Experience with large data projects delivering data products and use cases.
• Insurance industry experience preferred.
• Ability to read programming languages.

Responsibilities

• Define data products, data lineage, and data quality rules with business teams.
• Collaborate with Data Architecture to map current and future data flows.
• Partner with Data Insights and AI teams to shape outputs and workflows.
• Lead QA testing of data products and support UAT with business teams.
• Deliver ongoing support for live data products as SME.

Skills

SQL

Excel

Data modelling

Star schemas

Delta concepts

Azure Databricks

SQL Server

Programming language reading

Data governance

Data quality

Communication

Collaboration

Education

Bachelor’s degree in computer science, Information Technology, or related field

Equivalent work experience

Tools

Azure Databricks

Microsoft SQL Server

Job description

This is your opportunity to join AXIS Capital – a trusted global provider of specialty lines insurance and reinsurance. We stand apart for our outstanding client service, intelligent risk taking and superior risk adjusted returns for our shareholders. We also proudly maintain an entrepreneurial, disciplined and ethical corporate culture. As a member of AXIS, you join a team that is among the best in the industry. At AXIS, we believe that we are only as strong as our people. We strive to create an inclusive and welcoming culture where employees of all backgrounds and from all walks of life feel comfortable and empowered to be themselves. This means that we bring our whole selves to work.

All qualified applicants will receive consideration for employment without regard to any protected characteristic, including age, color, disability, ethnicity, gender identity, marital status, national origin, pregnancy, race, religion, sex, sexual orientation, veteran status, or any basis prohibited by the laws that govern its operations.

How does this role contribute to our collective success? We are seeking a skilled Data Engineer to join our dynamic Data & Analytics team, within the Platforms & Transformation group. The Data Engineer will use their technical, analytical and insurance expertise while working as part of project teams to deliver the benefits to AXIS. This is an excellent opportunity to work within great teams across the business on complex, challenging and rewarding projects and initiatives to build towards the success of AXIS.

What will you do in this role?

Data Analysis & Modelling

• Work with the business teams, including senior leaders, to define the data products and use cases along with their data lineage, critical data elements, data glossaries and data quality rules.
• Work with the Data Architecture team to enable the design of best-in‑class current state and future state data flow diagrams.
• Partner with the Data Insights and AI & Innovation teams to design the outputs and workflows for Use Cases and Data Products.
• Use your industry experience to define the metrics required for projects and solutions.
• Lead the QA testing of data products and supporting the business teams during UAT.
• Support the future phases of data products you have delivered in projects once live where you are considered a subject matter expert and have a relationship with the business teams.

Data Engineering

• Run simple and complex queries to understand existing data structures and relationships, data quality gaps and metric formulas to enable accurate documentation of the current state solutions.
• Use your advanced Excel skills to reverse engineer complex workbooks with macros and layered formulas to enable modular redesign in our modern data architecture.
• Build and execute test models against both on‑premises SQL Server and Azure Databricks databases.
• Work closely with the development teams to ensure your data product templates are clearly defined to the specifications required by the application delivery leads.
• You may also be required to take on additional duties, responsibilities and activities appropriate to the nature of this role.

About You

We encourage you to bring your own experience and expertise to the table, so while there are some qualifications and experiences, we need you to have, we are open to discussing how your individual knowledge might lend itself to fulfilling this role and help us achieve our goals.

What you need to have:

• Bachelor’s degree in computer science, Information Technology, or a related technical field (or equivalent work experience).
• 4+ years of experience as a Data Engineer or in a similar data‑focused role.
• Very strong SQL and Excel experience
• Design experience with star schemas and delta concepts
• Experience in data modelling in Excel having worked within Data Governance and Data Quality frameworks
• Strong problem‑solving skills with a proactive approach to understanding data quality issues and challenges
• Experience with large complex projects delivering data products and use cases
• Excellent verbal and written communication skills.
• Ability to work effectively in a collaborative team environment.
• Ability to time manage and work across different priorities.

What we prefer you to have:

• Insurance industry experience.
• Microsoft SQL Server and Azure Databricks experience
• Ability to read programming languages
• Knowledge of Insurance KPIs and metrics and processing within Underwriting, Claims and Pricing
• Experience taking a key role on Data & Analytics projects

Role Factors

In this role, you will typically be required to:

This position is a hybrid role and will require mandatory in office presence 3 days per week.

What we offer

For this position, we currently expect to offer a base salary in the range of $75,000 - $120,000 CAD (Nova Scotia).

Your salary offer will be based on an assessment of a variety of factors including your specific experience and work location.

You will be eligible for a comprehensive and competitive benefits package which includes medical plans for you and your family, health and wellness programs, retirement plans, tuition reimbursement, paid annual leave, and much more.

This posting is for an existing vacancy. Rewarding. Challenging. Meaningful.

We are shaping the direction of Insurance and Reinsurance during a critical and exciting time for the industry. Whether you are a student approaching graduation or a seasoned professional looking for a new environment, AXIS has the right challenges and career opportunities for you.

At AXIS, we value each individual and recognize that attracting and retaining the right people is essential to the success of our company.

We offer a comprehensive and competitive benefits package which includes medical plans for employees and their families, health and wellness programs, retirement plans, tuition reimbursement, paid vacation, and much more.