Senior ETL Developer - Data and Analytics

kdc/one; Quebec, Longueuil; On-site; CAD 80,000 - 120,000; Full time

Job summary

Join a forward-thinking company as a Senior ETL Developer, where you'll lead the design and implementation of data-driven solutions. This role involves collaborating with stakeholders to develop insights that drive business decisions, establishing standards for data architecture, and modernizing the data stack towards cloud solutions. If you are passionate about data management and analytics, and thrive in a dynamic environment, this opportunity is perfect for you. Contribute to innovative projects and make a significant impact in a diverse team dedicated to excellence in the beauty and personal care industry.

Qualifications

• 7+ years of experience in ETL development and data management.
• 5+ years with Microsoft SQL products and relational databases.

Responsibilities

• Lead D&A solution development and establish deployment standards.
• Design and implement ETL pipelines and ensure data quality.

Skills

SQL knowledge including T-SQL

Data modeling principles

Project coordination and management

Organizational skills

Big data technologies

Cloud Data warehousing tools

Effective communication skills

Problem-solving

Learning new technology

Education

Bachelor's or Master's degree in relevant field

Tools

Microsoft SQL Suite (SSIS)

PowerBI

Git

Job description

Senior ETL Developer - Data and Analytics

kdc/one Corporate Longueuil, 375 boul Roland-Therrien, Longueuil, Quebec, Canada Req #4371

Monday, February 3, 2025

KDC is a network of best-in-class custom formulators and manufacturers of color cosmetics, skincare, haircare, bath & body, fragrance, deodorant, home, health, industrial, and auto care products. KDC delivers high-touch innovation, operational excellence, and speed to market to well-known and emerging beauty, personal, and specialty companies from coast to coast. KDC has its head office in Longueuil, Québec. In addition, KDC has 10 operating facilities located throughout North America. Altogether, the company employs nearly 4,800 talented and dedicated employees in North America.

Job Summary:

As the Senior ETL Developer at kdc/one, you will be responsible for designing, developing, implementing, and maintaining D&A solutions. This includes collaborating with internal and external stakeholders and partners in the end-to-end process of developing data-driven insights to support business decisions. You will also be responsible for establishing development and deployment standards and helping align current and future D&A solutions to such standards. You will interact with external partners to ensure new development and deployment standards are consistently applied and followed.

Essential Duties and Responsibilities:

• Leading D&A Solution development, deployment, and maintenance: Gathers business requirements for BI tools and translates them into technical specifications. This also involves determining which solutions will be designed and built internally vs. externally.
• Establishing development standards: Ensures development and deployment standards are implemented and followed to ensure consistency across D&A Projects, data management, data architecture, and data infrastructure.
• ETL Development: Design, develop, implement, and expand ETL pipelines by performing Extract, Transformation, and Load activities. This also includes investigating data issues within ETL pipelines, communicating and notifying end-users, and proposing solutions to address the issues.
• Data Governance: Assist with assessing and designing the data governance and data management framework across the organization.
• Data Quality: Establish, design, and implement procedures for data quality tracking and improvement by working in collaboration with business stakeholders. This also includes working with the business to deliver accurate, high-quality data in the D&A solutions.
• Dashboarding and Reporting: Design, develop, and maintain dashboards and reports that provide data-driven insights to support business decisions. This also involves supporting the business in correcting data quality issues at the source.
• Strategy And Planning: Develops short-term tactical D&A solutions to help achieve long-term objectives aligned with D&A Strategy and D&A roadmap.
• D&A Architecture: Assist in designing scalable and maintainable data architecture. This includes work on modernizing the current kdc/one data stack towards a cloud data warehouse solution.

Qualifications:

Education Required:

• A bachelor’s or master’s degree in business administration, computer science, data science, or a related field, or equivalent work experience. Academic qualifications or professional training and experience are also desirable.

Experience Required:

• A minimum of 7 years of relevant experience in ETL development and data management.
• A minimum of 5 years of relevant experience with Microsoft SQL suite of products (SSIS, etc.).
• A minimum of 5 years of relevant experience with relational and dimensional databases.
• Familiarity with PowerBI and Git.

Skills Required:

• SQL knowledge including T-SQL, performance-tuning, indexing, etc.
• Knowledge of data modeling principles.
• Ability to coordinate and manage resources for a specific project.
• Demonstrated organizational skills: time management and planning.
• Familiar with big data technologies and modern Cloud Data warehousing tools.
• Knowledge of trends and developments in the fields of data management and data analytics.
• Effective written and oral communication skills. Bi-lingual (French/English) preferred.
• Passionate about problem-solving.
• Demonstrated ability to learn new technology and tools.

KDC-ONE is an equal opportunity employer and does not discriminate on the basis of race, religion, color, national origin, age, sex, gender, disability, or any other characteristic protected by law. I understand that employment with KDC-ONE Company is at-will, meaning that I or KDC-ONE Company may terminate my employment at any time, or for any reason consistent with applicable state or federal law. I understand that KDC-One requires the successful completion of a drug and/or alcohol test as a condition of employment.