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

Our employees are at the heart of everything we do. Together, we help people, businesses, and society prosper in good times and be resilient in bad times.

Our employee promise represents Intact’s commitment to you in exchange for living our Values, striving to do your best work, being open to change and investing in your career. In return, we promise to provide support, opportunities and performance-led financial rewards at a workplace where you can shape the future, 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, AWS, Databicks) 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 Software Developer Specialist who will integrate data from the company’s diverse data source into our Enterprise Data Platform and make them available.
What you'll do here:

• Collaborate with the team and the other IT departments to analyze, develop, test, and deploy solutions to maintain or integrate new business areas to our data warehouse and Snowflake migration.
• Understand business requirements, translate them into technical requirements.
• Work closely with the Product Owner for estimation, backlog prioritization, and effective delivery planning.
• Lead the design and development of scalable data ingestion and consumption solutions tailored to meet business needs, applying advanced data engineering concepts such as medallion architecture, lakehouse architecture, data warehousing, and Lambda architecture.
• Develop robust stored procedures in Snowflake to facilitate data processing and management.
• Utilize expertise in IICS to design, implement, and manage cloud-based data integration solutions using CDI and CAI.
• Develop and maintain ETL pipelines using Iceberg to ingest and transform data.
• Provide critical technical guidance and mentorship to fellow developers, helping them to understand complex requirements and technical challenges.
• Collaborate closely with DevOps and Solution Architecture teams to design and implement seamless integration and deployment of data solutions.
• Ensure data solutions comply with industry best practices and regulatory standards, maintaining high levels of data security and integrity.
• Take leadership in defining the Software Engineering best practices regarding the code standardization, branching strategy, pipeline code optimization, cost optimization, design patterns, etc.
• Provide Level 2 (L2) support by quickly diagnosing, prioritizing, and resolving incidents to minimize downtime and maintain high service availability.
• Provide technical support to Business Intelligence analysts, testers, and deployment coordinators throughout our development cycle and for production support, typically during regular business hours. 
• Integrate CI/CD practices to automate and streamline the deployment and delivery processes.
• Monitor data environments and processes to ensure optimal performance and compliance with data governance standards.
• Conduct training sessions and workshops to help stakeholders effectively utilize data systems.
• Implement and leverage AI agents to enhance data engineering processes, increasing automation and efficiency.
• Stay updated with the latest trends and technologies in data engineering, CI/CD practices, AI applications in data engineering, and the insurance industry to propose innovative solutions.

What you bring to the table:

• Degree in Computer Engineering / Science or any combination of equivalent education and experience.
• 7 years of hands-on experience with data integration (data warehouse/lakehouse).
• At least 7 years of strong experience with Snowflake suite of products.
• At least 2 years working experience with IICS(CDI & CAI)
• At least 7 years experience with  PL/SQL and Python programming.
• Proven experience in providing L2 support with a strong track record of swiftly resolving issues and incidents in data ingestion pipelines.
• Strong knowledge of ETL (Extract, Transform, Load) techniques and different data ingestion patterns.
• Proficient in designing and creating stored procedures in Snowflake to support complex data transformations.
• Working experience with Data Vault and Relational Data Models.
• Knowledge of insurance or financial sector will be advantageous. 
• Assets: databricks,streamlit, GIT, iceberg,Jenkins, Business Objects and Power BI.
• Experience with JAVA, springboot, JMS ,JPA is a plus.
• Strong presentation, facilitation, verbal and written communication skills, including interpersonal skills.
• 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.

We are an equal opportunity employer

At Intact, our Value of respect is founded on seeing diversity as a strength. We strive to create an accessible workplace where employees feel valued, included and encouraged to share their unique perspectives.

We encourage applications from individuals who are members of equity-deserving groups, including but not limited to women, Indigenous peoples, persons with disabilities, Black people, and members of the 2SLGBTQI+ community.

As part of Intact’s commitment to reconciliation, we acknowledge that we work, meet and travel across the land currently called Canada, originally inhabited by First Nations, Metis and Inuit people. This history extends through many centuries and continues to evolve today.

We have policies to ensure equal access and participation for people with disabilities, including providing workplace adjustments (accommodations). A copy of applicable policies is available on request.

If we can provide a specific adjustment to make the recruitment process more accessible for you, please let us know when we reach out about a job opportunity. We’ll work with you to meet your needs.

Learn more about our recruitment process and your candidate journey here.

If you are an employee of Intact or belairdirect, please apply for this role on Internal Career Site.