Data Analytics and Automation Analyst

Located in Montreal, Quebec, the Canadian company Groupe Marcelle is a leader in the cosmetics industry. With the highest standards of quality and excellence, Groupe Marcelle develops, manufactures, and distributes care and makeup products and accessories with a portfolio of four brands: Marcelle, Watier, Annabelle and CW Beggs and Sons.

At Groupe Marcelle we believe in an environment where passion can be expressed, creative minds lead to exceptional innovation, audacity and focus are a pillar of great success and acts of empowerment, collaboration and humanity are widely encouraged. Because our purpose is to “Cultivate beauty in our world”, we strive to care for you, people and the environment. We are looking for professionals who will exemplify these values and bring energy and commitment to results.

Join a company with more than 350 employees in the cosmetics field and play a key role in the organization.

Groupe Marcelle is currently seeking a Data Analytics and Automation Analyst for a permanent full-time position.

Reporting to the Manager, Business Intelligence, the successful candidate will contribute to the development, maintenance, and continuous improvement of our data and automation solutions. They will participate in the development of data pipelines, the integration of new data sources, the enhancement of our data warehouse, and the automation of business processes using SQL, Python, and automation technologies.

This role also offers the opportunity to contribute to the evolution of our automation capabilities through emerging artificial intelligence approaches, including the potential development of intelligent workflows and AI agents.

A CAREER SIGNED GROUPE MARCELLE

At Groupe Marcelle, we dare to grow together and fully invest ourselves to build a future worthy of our Canadian pride.

Work Location

• 400 Sainte-Croix Avenue, Saint-Laurent (Quebec)

• Hybrid work mode – minimum three (3) days per week in the office

Why choose Groupe Marcelle?

• A growing Canadian company

• A stimulating environment where boldness, empowerment, and partnership are encouraged

• A human and committed team made up of passionate people moving forward together

Benefits matching your talent

• Competitive base salary

• Flexible hours promoting work-life balance, including the possibility of leaving earlier on Fridays

• Medical and dental insurance

• Health and wellness spending account

• Retirement plan and Tax-Free Savings Account (TFSA)

• Telemedicine services

• Employee Assistance Program

• Performance bonuses

• Paid holidays during the Christmas season

• Paid time off for your birthday

• Employee discounts on all Groupe Marcelle products, including exclusive previews of new launches

• Free access to our on-site gym at headquarters

Exclusive head office benefits

• Large free outdoor parking lot (paid indoor parking option available)

• Easily accessible by foot from Du Collège metro station

YOUR RESPONSIBILITIES WILL BE

• Participate in the development, maintenance, and optimization of data pipelines and ETL/ELT processes supporting our analytics environment

• Develop SQL queries to extract, transform, integrate, and validate data from various sources

• Use Python for data manipulation, script development, system integration, and process automation

• Participate in the integration of new internal and external data sources into our data environment

• Contribute to the development and evolution of our data warehouse, including fact tables, dimensions, business rules, and integration processes

• Develop, maintain, and enhance business process automation solutions to reduce manual tasks, improve operational reliability, and increase team efficiency

• Analyze existing processes and identify automation opportunities using the technologies and approaches best suited to business needs

• Collaborate with Finance and various business units to understand their processes, identify improvement opportunities, and develop tailored solutions

• Contribute to the evolution of our automation strategy and progressively explore the use of generative artificial intelligence and AI agents to automate certain business processes

• Participate in the development of solutions that enable system integration through APIs and other data exchange mechanisms

• Perform analyses and validations to ensure data quality, consistency, and reliability

• Participate in identifying and resolving issues related to data, interfaces, and automated processes

• Implement or enhance monitoring, logging, and control mechanisms to ensure the reliability of automated processes

• Collaborate with the BI team to maintain the data ecosystem supporting the organization's analytics and reporting solutions

• Document data pipelines, scripts, automations, business rules, and developed solutions

• Stay current on emerging technologies in data engineering, automation, and artificial intelligence, and recommend improvement opportunities aligned with organizational needs

WE WOULD LIKE TO MEET YOU IF YOU HAVE

• Bachelor's degree in Computer Science, Software Engineering, Information Systems, Business Intelligence, or a related field

• 1 to 3 years of experience in data development, data integration, business intelligence, automation, or a related field

• Strong proficiency in SQL and ability to develop and optimize queries on relational databases

• Solid knowledge of Python, particularly for data manipulation, scripting, and automation

• Good understanding of database concepts, ETL/ELT processes, and data integration and transformation

• Experience with Microsoft SQL Server or another relational database platform

• Knowledge of REST APIs, web services, and data exchange formats such as JSON

• Strong interest in process automation and leveraging technology to improve operational efficiency

• Knowledge of Git or another version control system is considered an asset

• Experience with a process automation platform or automation tools is considered an asset

• Experience with, or a strong interest in, generative artificial intelligence, LLM APIs, AI workflows, or AI agents is considered an asset

• Experience with business intelligence tools such as IBM Cognos Analytics, Power BI, or similar platforms

• Knowledge of IBM Planning Analytics (TM1) is considered an asset

AND IF YOU ARE

• Curious and passionate about technology, with a strong desire to learn and experiment with new tools

• Analytical and solution-oriented, with strong problem-solving skills

• Equally interested in data, automation, and development

• Self-motivated and capable of working independently while enjoying collaboration within a small team

• Detail-oriented and committed to delivering high-quality, reliable solutions

• Proactive in identifying manual tasks and opportunities for automation

• Able to understand business processes and determine the most effective ways to simplify them through technology

• Comfortable working with business users and translating technical concepts into clear, accessible language

• Motivated to further develop skills in data engineering, Python, automation, and artificial intelligence

• Interested in growing within a role whose responsibilities and technologies will continue to evolve alongside advances in AI and automation

The task and responsibilities listed above are summaries and indicatives.

TO APPLY

We invite interested individuals to use our online recruitment module by submitting an application to https://dayforcehcm.com/CandidatePortal/en-US/groupemarcelle.

DIVERSITY AND INCLUSION

Groupe Marcelle wants to offer equal employment opportunities to all. It invites women, members of visible and ethnic minorities, Aboriginals, and persons with disabilities to apply. Groupe Marcelle is also committed to pursuing the integration of diversity and making it a source of enrichment and pride for all its employees.

The use of the masculine gender in this document refers to both men and women.

Groupe Marcelle thanks all candidates for their interest; however only those selected to continue in the process will be contacted.

To learn more about our company, feel free to visit our LinkedIn page: https://www.linkedin.com/company/groupe-marcelle