Senior SQL Developer

JOB DESCRIPTION

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.