Data Engineer Jobs

At Roots, we look for dynamic individuals who are not only interested in retail and fashion, but who enjoy challenges and share our vision for a safer, cleaner, healthier planet. Roots is not only a brand, it’s a culture and lifestyle.

In addition to our customers, an intrinsic part of our success has always been the people who work here. Our clients and customers need to have confidence that our managers and associates at all levels of the organization have the knowledge, skills and competencies to excel. Our company depends on systems and processes that support the continued learning and development of our people. Roots is a company in which you can grow and benefit from the great opportunities often available. All members of our team are encouraged to ‘spread their roots’.

We are currently seeking a Data Engineer who can be nice, will seek inspiration from our roots, can commit to achieving results the right way and loves to think big to join us on our journey.

The Data Engineer is a key member of our Application Development team, reporting directly to the Director of Application Development. T he Data Engineeris responsible for defining, developing, documenting, implementing, and maintaining efficient systems to provide Roots with information and analysis necessary for effective operation and decision-making.

The Date Engineer for Roots will be responsible for and evaluated on the following:

• Assist in the development and enforcement of data governance policies.
• Retrieve data from various systems via multiple protocols and methodologies including SFTP, RESTful API, event streams, etc.
• Ensure reports and databases meet defined IT standards and performance requirements.
• Design, develop, and support existing reports and dashboards in Power BI and SSRS.
• Support production relational and non-relational databases.
• Assist in scoping and planning for new sources of data ingestion, new report development, etc.
• Design and develop databases components such as tables, stored procedures, triggers.

Top candidates for the Data Engineer role will have the following technical skills:

• Post-secondary education in computer science, software, or computer engineering, applied math, physics, statistics, or a related field combined with a minimum of 5 years of experience in developing and maintaining medium to large-scale databases.
• Microsoft Business Intelligence (Power BI)
• Retrieving data from diverse sources including, RESTful API’s, S3 buckets, Azure Blob storage, CSV, SFTP, custom files, etc.
• Highly proficient SQL Query writing with experience tuning for performance.
• SQL Server Integration Services (SSIS)
• Store Procedures, User functions, Triggers, Auditing.
• Database normalization and design.
• Experience with various source control systems, GitHub, Bitbucket, Azure DevOps, TFS etc.
• SQL Server Reporting Services (SSRS)
• Experience in the Microsoft Azure ecosystem (CosmosDB, Azure Synapse, Azure Data Lake). Azure Functions an asset.
• MuleSoft API development experience is an asset

Top candidates for the Data Engineer role will have the following interpersonal skills:

• Solid analytical capabilities.
• Ability to work independently and as part of a team.
• Excellent oral and written communication skills.
• Familiar with the software development life cycle.
• Understanding of analytical process.
• Familiarity with retail, wholesale, or accounting applications.
• Familiar with Agile development practices.
• Willing to take initiative and obtain required resources while working as part of a team.
• Be able to work in a fast-paced environment.

The Data Engineer role is eligible for:

• Fully remote work within Canada
• A generous clothing allowance and employee discount
• Comprehensive medical and dental coverage

Founded in 1973, Roots Canada is a publicly held Canadian lifestyle brand that sells apparel, leather bags, small leather goods, footwear and active athletic wear with over 100 retail stores in North America and Asia.

Apply Now