Senior ETL Developer - Data and Analytics

KDC/One; Longueuil; On-site; CAD 90,000 - 120,000; Full time

Job summary

A leading company in the beauty and personal care industry seeks a Senior ETL Developer to design and implement data solutions. The role involves collaborating with stakeholders to develop insights, establish standards, and ensure data quality. The ideal candidate will have extensive experience in ETL development, data management, and a strong understanding of data architecture.

Qualifications

• Minimum 7 years of relevant experience in ETL development and data management.
• Minimum 5 years of experience with Microsoft SQL suite of products.

Responsibilities

• Lead D&A solution development and maintenance.
• Design, develop, and implement ETL pipelines.
• Establish data governance and quality procedures.

Skills

SQL

Data Modeling

Problem Solving

Time Management

Communication

Education

Bachelor’s or Master’s degree in Business Administration

Computer Science

Data Science

Tools

PowerBI

Git

Job description

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 emergingbeauty, 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 nearly4,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 of establishing development and deployment standards and to help align current and future D&A solutions to such standards. You will also be interacting with external partners to make sure 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 deployments 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 the 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 for improvement by working in collaboration with the 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 are providing 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 also includes work on modernizing 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 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, 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 othercharacteristic 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.