Azure Data Engineer

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.

Azure Data Engineer

Job Family Grouping: Chief Underwriting Officer

Job Family: Data & Analytics

Location: Halifax NS, Canada

How does this role contribute to our collective success?

The Data & Analytics department transforms raw data into actionable insights to drive informed decision-making and optimize business operations. The Azure Data Engineer will support these goals by designing, implementing, and managing scalable data solutions on the Azure platform, ensuring efficient data processing, storage, and retrieval. This role will enhance the department's ability to deliver high-quality analytics and maintain robust data infrastructure.

What will you do in this role?

As an Azure Data Engineer, you will be responsible for designing, implementing, and maintaining data storage and processing solutions on the Azure platform. You will work with modern data warehouse (MDW) technologies, big data, and lakehouse architectures to ensure our data solutions are secure, efficient, and optimized.

Key Responsibilities:

• Design and implement modern data warehouse (MDW) and lakehouse architectures on the Azure platform.

• Develop and maintain data pipelines using Azure Data Factory.

• Manage and optimize data storage solutions using Azure Data Lake Storage.

• Develop and manage big data processing using Azure Databricks.

• Write complex SQL queries and scripts for data manipulation and extraction.

• Develop Python scripts for data processing and automation tasks.

• Implement medallion architecture to organize data into bronze, silver, and gold layers.

• Ensure data solutions are secure, including data encryption, access controls, and compliance with data governance policies.

• Monitor data solutions to ensure performance, reliability, and scalability.

• Develop and maintain CICD pipelines.

• Optimize data solutions for cost, performance, and efficiency.

• Collaborate with data scientists, analysts, and other stakeholders to understand data needs and deliver high-quality data solutions.

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.

Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or a related field.

• Proven experience as a Data Engineer with a focus on Azure technologies.

• Strong proficiency in modern data warehouse (MDW) and big data technologies.

• Expertise in designing and implementing lakehouse architectures.

• Proficient in SQL and Python programming.

• Hands-on experience with Azure Data Factory, Azure Data Lake Storage, and Azure Databricks.

• Deep understanding of medallion architecture and its implementation.

• Knowledge of data security best practices, including encryption and access control.

• Experience with monitoring and optimizing data solutions on the Azure platform.

• Strong problem-solving skills and attention to detail.

• Excellent communication and collaboration skills.

Preferred Qualifications:

• Azure Data Engineer certification or similar.

• Experience with other data tools and technologies in the Azure ecosystem.

• Familiarity with data governance frameworks and compliance requirements.

Role Factors:

The position is full-time with remote work options, requiring in-office presence three 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.