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.
RESPONSIBILITIES:
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.
Must be a self-starter with a great attitude, not afraid to take the initiative, and work with little supervision
Preference given for holders of a 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
Stored Procedures/TSQL
Query Performance Tuning
Data Warehousing & OLAP
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 withAWS-based dataservices will be plus:Athena, Glue,RedShift,RDS,S3,etc.
Ability to workindependently while understanding the necessity for communicating and coordinating work efforts with other employees and organizations
About Fairfax
Fairfax is a holding company which, through its subsidiaries, is engaged in property and casualty insurance and reinsurance and investment management.
About Allied World
Allied World, through its subsidiaries and brand known as Allied World, is a global provider of innovative property, casualty and specialty insurance and reinsurance solutions. Allied World offers superior client service through a global network of offices and branches. All of Allied World's rated insurance and reinsurance subsidiaries are rated A by A.M. Best Company, A by Standard & Poor's, and A2 by Moody's, and our Lloyd's Syndicate 2232 is rated A+ by Standard & Poor's and AA- by Fitch.
Our generous benefits package includes: Health and Dental Insurance, 401k plan, and Group Term Life Insurance. Allied World Insurance Company 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, age, genetic information, marital or civil partnership status, family status, sexual orientation, gender identity, or their protected veteran or disability status. Please visit www.awac.com for further information on Allied World.
