Senior Developer - Data engineering
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
We are seeking an accomplished and visionary Data Engineering advisor to join our dynamic database marketing team. This role is pivotal in driving targeted marketing initiatives, including direct marketing and client communication towards an omnichannel engagement approach.
As a Senior Developer - Data engineering, you will lead the charge in ingesting data from diverse sources and executing complex transformations to deliver high-quality client communications and advance analytics insights-ready data.
Key Responsibilities:
Data Modeling and Architecture:
Design and implement data models that support marketing analytics, including customer segmentation, personalisation, attribution modeling, and performance tracking.
Optimize database structures and indexing strategies to enhance query performance and data retrieval speeds.
Drive Change, Innovation and Continuous Improvement:
Act as a transformational leader by fostering a culture of continuous improvement within the database marketing team, while proactively identifying and implementing innovative solutions to enhance data engineering practices.
Stay updated with the latest trends and advancements in data engineering, big data technologies, and marketing analytics.
Data Pipeline Development:
Design, develop, and maintain scalable data pipelines to ingest, process, and store large volumes of data from multiple sources, including CRM systems, web analytics platforms, social media, and third-party data providers.
Implement ETL (Extract, Transform, Load) processes to ensure data is clean, reliable, and accessible for client communications, analysis and reporting.
Data Integration:
Integrate data from various marketing platforms to create a unified and comprehensive view of customer interactions across different channels, enabling omnichannel marketing strategies.
Ensure seamless data flow between marketing automation tools, customer databases, and analytics platforms.
Data Quality Assurance:
Develop and implement data quality checks to identify and resolve data inconsistencies, duplicates, and errors.
Monitor data pipelines and perform regular audits to ensure data accuracy and reliability.
Collaborative Leadership:
Partner with senior developers, data experts, and data analysts, providing guidance and mentorship to elevate the team's capabilities.
Represent the team's needs and interests in important structural data projects (IT, Intact Lab etc).
Provide technical guidance and support to marketing team members, helping them leverage data effectively for campaign optimization and decision-making.
Qualifications:
Bachelor's degree in computer science, Software Engineering, Mathematics, or a related field. Master's degree is a plus.
10+ years of experience in software engineering, data engineering, ETL development, or data warehousing, with a track record of success in complex environments. Focus on marketing data and analytics experience.
Proficiency with big data and cloud technologies for handling large data volumes, with Snowflake, SQL, Oracle and Control-M as primary tools. Expertise in Snowflake is a must. Advanced skills in Python and PySpark programming languages.
Deep understanding of data management, security, and classification, coupled with knowledge of machine learning and artificial intelligence.
Strong analytical and problem-solving skills, with the ability to translate complex data into actionable insights.
Bilingual (French and English): Need to interact on a regular basis with an English-speaking clientele and colleagues across the country.
No Canadian work experience required however must be eligible to work in Canada
Join us and be a driving force in revolutionizing our data engineering practices, leading with vision, and making a significant impact on our targeted marketing initiatives. If you are a senior expert with a passion for leadership, innovation, and excellence, we want to hear from you!
#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.