Senior SQL Developer
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're looking for a Senior SQL Developer, to join our growing team in Marketing!
Reporting to the Database Marketing Manager, the Senior SQL Developer contributes to achieving objectives by ensuring the preparation and execution of relationship marketing campaigns. You will be responsible for SQL programming (under Oracle & Snowflake), data extraction, list and segment creation, coordination, timelines and process documentation.
Additionally, you will leverage your deep business domain knowledge, computing and analytical skills to ensure the evolution of the relationship marketing database environment.
You will propose improvements to the data structure and processes and will actively participate in the development, programming, maintenance, and continuous improvement of this environment, while adhering to data security guidelines.
Key Responsibilities:
Data Extraction and Programming:
Program and perform data extractions for relationship marketing activities (email, postal, and telemarketing) primarily using SQL, meeting the requirements of various stakeholders and adhering to deadlines.
Actively participate in the design, programming, implementation, and maintenance of data processing processes (Oracle & Snowflake ) for campaign production, results tracking, and reporting.
Data Modeling and Optimization:
Understand, analyze, and document the business needs of the department, as well as operational and data processing processes.
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 the impacts of changes on 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 that systems are optimal and meet business standards by performing analyses, making recommendations, and developing evaluations.
Develop and implement data quality checks to identify and resolve data inconsistencies, duplicates, and errors.
Continuous Improvement:
Foster a culture of continuous improvement within the team by identifying and implementing innovative solutions to enhance data engineering practices.
Stay updated with the latest trends and advancements in programming, big data technologies, IA and marketing analytics.
Qualifications:
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 with strong knowledge of relational databases (Oracle & Snowflake)).
Knowledge of Power BI is an asset.
Excellent analytical and synthesis skills, with a strong attention to detail and rigor.
Experience in dynamic and constantly evolving 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
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.