Software Developer Specialist (IICS, Snowflake, ETL, AWS)

Who needs insurance? Everybody. That keeps us busy. Very busy. At the Intact Lab, we use machine learning, data science, software engineering, AI, agility, UX and design thinking to transform the customer experience for millions of Canadians. Join our team and get ready to explore, take risks, make mistakes, and learn all day, every day. We’ll support your goals with tools, opportunities, and flexibility. It’s our employee promise.  Our hybrid work model provides the balance between working from home and enjoying meaningful in-person interactions. Ready to make your mark? About the role Do you enjoy working with different technologies such as Oracle, Informatica and cloud tools (IICS, Snowflake, 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 Software Developer Specialist who will integrate data from the company’s diverse data source into our Enterprise Data Platform and make them available. Your mission: 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. Design and develop Data ingestion & consumption pipelines. Take leadership in defining the Software Engineering best practices regarding the code standardization, branching strategy, pipeline code optimization, cost optimization, design patterns, etc. Collaborate with Solution and Enterprise Architects to address unique business problems, provide project estimates and design complex data transformations solutions, utilizing appropriate tools and technologies. 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.  What you bring to the table: A bachelor’s degree in information technology / software engineering or any equivalent combination of training and experience  At least 7 years of strong experience with Informatica powercentre, IICS, Snowflake and Oracle databases Hands-on experience with PL/SQL , java and Python programming is a plus Minimum 5 years of hands-on experience with data integration (data warehouse). Strong knowledge of ETL (Extract, Transform, Load) techniques and different data ingestion patterns. Working experience with Data Vault and Relational Data Models. Knowledge of insurance or financial sector will be advantageous.  Assets: databricks, SAS Enterprise Guide, GIT, Jenkins, Business Objects and Power BI. Strong presentation, facilitation, verbal and written communication skills, including interpersonal skills. 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, curious 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 deployment No Canadian work experience required however must be eligible to work in Canada. #LI-Hybrid What we offer 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, we value diversity and strive to create an inclusive, accessible workplace where all individuals feel valued, respected, and heard. 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. , including background checks, internal candidates, and eligibility to work in Canada.