Software Developer Senior (IICS, Snowflake, Databricks, AWS S3)

About the role

At Intact, we’ll give you countless opportunities to learn and grow, alongside a diverse and passionate community of experts – the best the industry has to offer. You’ll be empowered to be your best self, do your best work, and make a meaningful impact. Here, you can: shape the future of insurance, win as a team, and grow with us.

About the role

Do you enjoy working with different technologies such as Oracle, Informatica and Cloud tools (IICS, Snowflake, Databricks, AWS) and in a collaborative environment? Do you like to contribute to adding value to company data? This is a great opportunity for you! We are looking for a Senior Software Developer who will integrate data from the company’s underwriting and billing systems into our warehouses and data marts.

What you'll do here:

• Collaborate with the team and the other IT sectors to analyze, develop, test, and deploy solutions to maintain or integrate new business areas to our Oracle data warehouse and Snowflake migration.

• Participate in designing and developing solutions to problems or small requests related to data integration and consumption on the data warehouse.

• Document implementation steps and produce quality evidence. Create and maintain system documentation.

• Provide technical support to Business Intelligence analysts, testers, and deployment coordinators throughout our development cycle and for production support, typically during regular business hours.

• Provide estimates on developments to assist in planning.

Qualifications

What you bring to the table:

• A bachelor’s degree in information technology / software engineering or any equivalent combination of training and experience.

• Strong experience with Snowflake databases & development.

• 3 to 5 years of experience with Informatica IICS / Power Center.

• Strong experience with Oracle databases and PL/SQL programming.

• Experience in data integration (data warehouse & data mart).

• Strong knowledge of ETL (Extract, Transform, Load) techniques.

• Experience with Data Vault and Relational Data Models.

• Experience with Databricks is an additional asset.

• Knowledge of insurance or financial sector will be advantageous.

• Assets: AWS S3, Lambda, JAVA, SAS Enterprise Guide, GIT, Jenkins, Business Objects and Power BI.

You are:

• A developer with a passion for data integration and transformation (ETL-ELT).

• A visionary with an innovative spirit.

• A committed and open team player.

• Versatile, autonomous and resourceful.

• Someone who learns quickly and is curious about new technologies.

• Comfortable in complex environments and multidisciplinary teams.

• Available for second level production support.

• Open to new and emerging technologies for code automation, testing and deploymen.

• No Canadian work experience required however must be eligible to work in Canada.

#LI-Hybrid

What we offer

Our hybrid work model provides the balance between working from home and enjoying meaningful in-person interactions.

Working here means you'll be empowered to be and do your best every day. Here is some of what you can expect as a permanent member of our team:

• A financial rewards program that recognizes your success

• An industry leading Employee Share Purchase Plan; we match 50% of net shares purchased

• An extensive flex pension and benefits package, with access to virtual healthcare

• Flexible work arrangements

• Possibility to purchase up to 5 extra days off per year

• An annual wellness account that promotes an active and healthy lifestyle

• Access to tools and resources to support physical and mental health, embracing change and connecting with colleagues

• A dynamic workplace learning ecosystem complete with learning journeys, interactive online content, and inspiring programs

• Inclusive employee-led networks to educate, inspire, amplify voices, build relationships and provide development opportunities

• Inspiring leaders and colleagues who will lift you up and help you grow

• A Community Impact program, because what you care about is a part of what makes you different. And how you contribute to your community should be just as unique.