Data Engineer

at  AXIS Insurance

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 race, color, religion or creed, sex, pregnancy, sexual orientation, gender identity or expression, national origin or ancestry, citizenship, physical or mental disability, age, marital status, civil union status, family or parental status, or any other characteristic protected by law. Accommodation is available upon request for candidates taking part in the selection process.
Data Engineer
Job Family: CUO> Data & Analytics > Data Platforms
Location: Halifax (Hybrid)
Job Type: Full Time
How does this role contribute to our collective success?
We are seeking a skilled Data Engineer to join our dynamic data team. In this role, you will be responsible for designing, developing, and maintaining our data infrastructure, including on-prem SQL Server databases, data warehouses, and Azure-based solutions. You will play a key role in data modelling, ETL development, and supporting data analytics through platforms such as Databricks and Azure Data Factory as we start a new journey to modernise our data platforms. The ideal candidate should have a strong technical background in data engineering, a solid understanding of cloud and on-prem environments, and hands-on experience with data integration and transformation tools.
What will you do in this role?

Data Warehouse Development & Maintenance:

• Design, implement, and optimize data warehouses to support business intelligence and analytics requirements.
• Develop and maintain data pipelines to ensure efficient and reliable data transfer between systems.

Data Modelling

• Design and maintain data models that support business reporting and analytics.
• Collaborate with stakeholders to understand data requirements and create both logical and physical data models.

ETL Development

• Build and maintain ETL processes using Azure Data Factory and SQL Server Integration Services (SSIS).
• Create, monitor, and troubleshoot data ingestion and transformation processes to ensure data accuracy and timeliness.

Azure Implementation

• Utilize Azure Data Factory to orchestrate data workflows, integrate data from multiple sources, and manage data movement across on-prem and cloud environments.

Documentation & Collaboration

• Document data workflows, architecture, and processes for transparency and knowledge sharing.
• Work closely with data analysts, data scientists, Architecture, Data Quality, Data Governance and IT teams to support data-driven decision-making.

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:

• Proficiency in SQL, T-SQL, and database management.
• Strong knowledge of Azure Data Factory and other Azure data services including Python or Spark SQL
• Hands-on experience in data warehousing and data modelling.
• CI/CD Devops code management and deployment
• Databricks experience a plus
• Strong problem-solving skills with a proactive approach to resolving data issues.
• Excellent communication and documentation skills.
• Ability to work effectively in a collaborative team environment.
• Ability to time manage and work across different priorities.
• P & C Insurance industry experience required.

What we prefer you to have:

• Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related technical field (or equivalent work experience).
• 4+ years of experience as a Data Engineer or in a similar data-focused role.
• Proven experience with on-premise SQL Server databases, including database design, optimization, and management.
• Hands-on experience in data warehousing and data modelling.

Role Factors:
Be in the office at least 2 days per week
What we offer:
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.

Please refer the Job description for details