Data Engineer
Halifax, NS, Canada
AXIS Capital
With 19 offices worldwide, AXIS Capital is a leading provider of specialty lines insurance and reinsurance globally.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 EngineerJob Family: CUO > Data & Analytics > Data Platforms & Transformation
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 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 & Databricks Implementation
• Use Databricks to develop and optimize big data solutions and perform complex data transformations.
• 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:
• Proven experience with MS SQL Server databases, including database design, optimization, and management
• Experience with Azure Data Factory, Databricks and Python preferred
• CI/CD Devops code management and deployment
• 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.
• Insurance industry experience.
What we prefer you to have:
Qualifications:
• Education: 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.
• Knowledge of Insurance KPIs and metrics and processing within Underwriting, Claims and Pricing
• Experience taking a key role on Data & Analytics projects
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
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Architecture Azure Big Data Business Intelligence CI/CD Computer Science Databricks Data governance Data pipelines Data quality Data warehouse DevOps ETL KPIs MS SQL Pipelines Python SQL SSIS
Perks/benefits: Health care Insurance Medical leave Parental leave Transparency Wellness
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.