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, 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.
Key Responsibilities
- Program and perform data extractions for relationship marketing activities using SQL, meeting stakeholder requirements and deadlines.
- Participate in the design, implementation, and maintenance of data processing workflows in Snowflake for campaign production, results tracking, and reporting.
- Understand, analyze, and document the department’s business needs and operational and data‑processing procedures.
- Propose and implement improvements to data structures and processes to optimize efficiency and performance.
- Represent the team in cross‑functional projects to communicate data needs and explain the impact of changes.
- Provide technical guidance and support to team members to leverage data effectively for campaign optimization and decision‑making.
- 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.
- 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.
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.
- 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.
- No Canadian work experience required but must be eligible to work in Canada.
Compensation and Benefits
Salary Range (but Not Limited To): 101,800 - 124,400 (based on a 35‑hour workweek).
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% bonus as part of the compensation package.
Share plan & other savings: up to 12% of salary or more via Employee Share Purchase Plan (ESPP). Intact matches 50% of your net shares.
Defined benefit pension plan offering guaranteed income for life.
Equal Opportunity Employer
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 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 across Canada, originally inhabited by First Nations, Metis and Inuit people.
We have policies to ensure equal access and participation for people with disabilities, including workplace adjustments (accommodations). A copy of applicable policies is available on request.
#J-18808-Ljbffr
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
