data engineer Toronto
Job description
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. The Data Engineer is 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:
- Retrieve data from various systems via multiple protocols and methodologies including SFTP, RESTful API, event streams, etc.
- Design, develop, and support existing reports and dashboards in Power BI and SSRS.
- Design and develop databases components such as tables, stored procedures, triggers.
- Support production relational and non-relational databases.
- Ensure reports and databases meet defined IT standards and performance requirements.
- Assist in the development and enforcement of data governance policies.
- Assist in scoping and planning for new sources of data ingestion, new report development, etc.
- Experience in the Microsoft Azure ecosystem (CosmosDB, Azure Synapse, Azure Data Lake). Azure Functions an asset.
- SQL Server Integration Services (SSIS)
- SQL Server Reporting Services (SSRS)
- Microsoft Business Intelligence (Power BI)
- Highly proficient SQL Query writing with experience tuning for performance.
- Database normalization and design.
- Store Procedures, User functions, Triggers, Auditing.
- Retrieving data from diverse sources including, RESTful API’s, S3 buckets, Azure Blob storage, CSV, SFTP, custom files, etc.
- Experience with various source control systems, GitHub, Bitbucket, Azure DevOps, TFS etc.
- 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.
- MuleSoft API development experience is an asset
- Understanding of analytical process.
- Familiar with the software development life cycle.
- Familiar with Agile development practices.
- Familiarity with retail, wholesale, or accounting applications.
- Excellent oral and written communication skills.
- Solid analytical capabilities.
- Ability to work independently and as part of a team.
- Be able to work in a fast-paced environment.
- Willing to take initiative and obtain required resources while working as part of a team.
- A generous clothing allowance and employee discount
- Comprehensive medical and dental coverage
- Fully remote work within Canada
About Roots Canada
CEO: Jim Gabel
Revenue: $100 to $500 million (USD)
Size: 1001 to 5000 Employees
Type: Company - Private
Website: www.roots.com
Year Founded: 1973
