Senior ETL Developer - Data and Analytics

Knowlton Development Corporation; 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 design and implement data solutions that drive business insights. In this pivotal role, you will collaborate with stakeholders to gather requirements, establish development standards, and enhance data governance. Your expertise in ETL development, SQL, and data management will help shape the future of data analytics within the organization. This position offers the opportunity to work on exciting projects, modernize data architecture, and contribute to a culture of innovation. If you're passionate about data and eager to make a significant impact, this role is perfect for you.

Qualifications

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

Responsibilities

• Lead D&A solution development and ensure standards are followed.
• Design and implement ETL pipelines and maintain data quality.

Skills

SQL knowledge including T-SQL

Data modeling principles

Project management

Organizational skills

Big data technologies

Data management trends

Communication skills

Problem-solving

Learning new technologies

Education

Bachelor's or Master's degree in related field

Tools

Microsoft SQL Server

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 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 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 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: Develop 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 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 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. Employment with KDC-ONE Company is at-will, meaning that either party may terminate employment at any time, or for any reason consistent with applicable state or federal law. KDC-One requires the successful completion of a drug and/or alcohol test as a condition of employment.