Détails du poste
- Lieu de travail : Montreal (Hybride)
- Type de poste : Permanent à temps plein
- Salaire : 101 800$ - 124 400$ /an
Ce que nous offrons
Pay at Intact is about much more than just salary.
Flexible work arrangements and a hybrid work model
Possibility to purchase up to 5 extra days off per year
Multiple benefits offered to support physical and mental wellbeing, including telemedicine, Wellness account and much more
Share plan & other savings: up to 12% of salary or even more (ask how you could earn guaranteed income for life)
Salary range (but not limited to):
101,800 - 124,400
Annual bonus target, based on the base salary, with a potential payout of up to double the target (subject to personal and company performance):
12%
As part of our commitment to Win As A Team, we share our success with employees through our annual bonus plan and Employee Share Purchase Plan (ESPP) – with Intact matching 50% of your net shares.
Our pension offerings provide flexibility and long-term security for our employees beyond their careers. We are one of the few companies offering the opportunity to receive guaranteed income for life via our defined benefit pension plan.
Salary for the candidate will be determined taking into consideration a number of factors including: experience, skills, qualifications, anticipated contribution to role, internal equity, etc. The salary range presented above is based on a 35-hour workweek and would represent a majority of different candidate profiles. However, we encourage candidates who may fall outside of this range to apply as well.
Description du poste
About the role
We’re looking for a Senior SQL Developer to join our growing Database Marketing team.
Reporting to the Database Marketing Manager, the Senior SQL Developer will help prepare and execute marketing campaigns. You will be responsible for SQL programming on Snowflake, data extraction, list and segment creation, coordination of timelines, and process documentation.
You will also leverage your business domain knowledge and analytical skills to advance the relationship‑marketing database environment. You will propose improvements to data structures and processes and participate in the development, maintenance, and continuous improvement of this environment while adhering to data‑security guidelines.
This role is pivotal in driving targeted marketing initiatives, including direct marketing and client communications within an omnichannel engagement approach.
Principales responsabilités
Key Responsibilities:
Data Extraction and Programming
Program and perform data extractions for relationship marketing activities (email, postal mail, media audiences, surveys) primarily using SQL, meeting stakeholder requirements and deadlines.
Actively participate in the design, implementation, and maintenance of data processing workflows in Snowflake for campaign production, results tracking, and reporting.
Data Modeling and Optimization
Understand, analyze, and document the department’s business needs as well as operational and data‑processing procedures.
Propose and implement improvements to data structures and processes to optimize efficiency and performance.
Collaborative Leadership
Represent the team in cross‑functional projects to communicate data needs and explain the impact of changes to our processes.
Provide technical guidance and support to team members, helping them leverage data effectively for campaign optimization and decision‑making.
Data Quality Assurance
Ensure systems meet business standards by performing analyses, making recommendations, and developing evaluations.
Develop and implement data quality checks to proactively identify and resolve inconsistencies, duplicates, and errors.
Continuous Improvement
Foster a culture of continuous improvement by identifying and implementing innovative solutions to enhance data engineering practices.
Stay current with trends and advancements in programming, big data technologies, AI, and marketing analytics.
Ce que vous apportez
What you bring to the table:
Bachelor’s degree in Business Administration, Business Intelligence, Management Information Systems, Computer Engineering, or a related field.
5+ years of relevant experience in a similar role. Other combinations of education and experience may be considered.
Excellent command of SQL and strong knowledge of relational databases.
2+ years’ experience with Snowflake and Python is required.
Knowledge of Git, GitHub, and GitHub Copilot is a strong asset.
Knowledge of Power BI is an asset.
Excellent analytical and synthesis skills, with strong attention to detail and rigor.
Experience working in dynamic, fast‑changing environments.
Autonomy, resourcefulness, and a proactive approach to problem solving.
Strong team spirit and collaborative leadership skills.
For candidates located in Quebec, bilingualism is required considering the necessity to interact on a regular basis with English speaking colleagues across the country.
No Canadian work experience required however must be eligible to work in Canada
#LI-Hybrid
Il s'agit d'un nouveau rôle au sein de notre équipe en plein croissance | This role is a new member of our growing team.
