Data Engineer

Job Summary:

Allied World is seeking an individual to contribute integration efforts of underwriting and claims platforms with our corporate Enterprise Data Warehouse (EDW). The successful candidate will work within our Agile environment as part of a Scrum team to develop new, and support pre-existing Extract, Transform & Load (ETL) processes. We look for people who can work effectively within a team as well as take the lead on new initiatives.

Job Duties:

• Work with EDW & Architecture groups to define and implement integration of new systems and processes

• Participate in peer code reviews and adhere to best practice development methodologies

• Assemble large, complex data sets that meet functional / non-functional business requirements

• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.

Job Requirements:

• Must be a self-starter with a great attitude, not afraid to take the initiative, and work with little supervision

• Prefer a 4-year University Degree or Diploma in Computer Science or related field

• Preferred experience working within an Agile – Scrum/Kanban environment

• Minimum 5 years ETL experience, real world experience with SSIS

• Minimum 5 years of experience with SQL server

• Extensive knowledge and experience using concepts including but not limited to:

o Stored Procedures/TSQL

o Query Performance Tuning

o Data Warehousing & OLAP

o Source control tools & concepts (CI/CD, Git, Bitbucket, Github)

• Practical experience with property & casualty insurance/reinsurance and multi-currency systems is an asset

• Ability to analyze and write business and technical specifications and interact with our business users effectively

• Experience with AWS-based data services will be plus: Athena, Glue, RedShift, RDS, S3, etc.

• Ability to work independently while understanding the necessity for communicating and coordinating work efforts with other employees and organizations

Our Business

Allied World Assurance Company Holdings, Ltd, through its subsidiaries, is a global provider of insurance and reinsurance solutions. We operate under the brand Allied World and have supported clients, cedents and trading partners with thoughtful service and meaningful coverages since 2001. We are a subsidiary of Fairfax Financial Holdings, Limited and benefit from a strong capital base and a worldwide network of affiliated entities that allow us to think and respond in non-traditional ways.

Our generous benefits package includes: Health, Dental and Disability Insurance, a company match 401k plan, and Group Term Life Insurance. Allied World is an Equal Opportunity and Affirmative Action Employer. All qualified applicants will be considered for employment without regard to an individual's race, color, national origin, religion or belief, sex, gender, gender identity, age, genetic information, marital or civil partnership status, family status, sexual orientation , military, veteran status, disability or any other characteristic protected by law.

To learn more, visit awac.com, or follow us on Facebook at facebook.com/alliedworld and LinkedIn at linkedin.com/company/allied-world.