Analyst, Databases

Reliance Home Comfort; Toronto; Hybrid; CAD 90,000 - 120,000; Full time

Benefits offered by this job

Competitive pay

Benefits plan

Career growth

Diversity & inclusion award

Job summary

Reliance Home Comfort is seeking an Analyst, Databases to help evolve our Enterprise Data Strategy and architecture. You will work on ETL, data movement, and detailed technical designs, collaborating with vendors and internal teams to deliver scalable data solutions.

You will contribute to database design, tuning, and performance, while supporting SDLC and agile processes. The role emphasizes leadership in projects and offshore coordination.

Qualifications

• 5+ years of application development, configuration, and support experience.
• Knowledge of Enterprise Service Bus (ESB) tools and Azure Pipelines.
• Experience with large-scale, high-availability enterprise applications.

Responsibilities

• Supports and evolves the Enterprise Data Strategy and Architecture.
• Applies ETL and data movement solutions to support target data models.
• Develops architecture and technical design documentation and data flows.
• Leads design efforts with vendors and internal partners.

Skills

SQL

C#

JAVA

Python

REST API

ETL

Data modeling

DB architecture

Json

Azure services

Education

College diploma or university degree in computer science or information systems

Tools

Azure Data Factory

Azure Databricks

Azure Synapse Analytics

Azure SQL Database

MS SQL SSIS/SSRS

Git/GitHub

Job description

Find Your Limitless with Reliance

By joining Reliance as an Analyst, Databases, you’ll become an important Team Member and will be provided with the tools you need to succeed. We have ambitious growth plans and are looking for Team Members who want to grow with us. At Reliance, we pride ourselves on the fact that we provide limitless opportunities for growth and we encourage it by rewarding our Team Members for their success in many ways. If you’re ready to find your limitless – join us!

What do we offer?

• The tools you need to succeed – including the tools for the job as well as training and development programs
• A successful and knowledgeable team to be part of and learn from
• Competitive base pay plus the ability to earn more tied to your success – the only limit is your potential

• A great benefits plan for you / your family
• Career paths so you can advance in the company
• Awarded Canada’s Most Admired Corporate Cultures with a proudly diverse and inclusive team

What will you do?

• Supports and contributes to evolving the Enterprise Data Strategy and Architecture
• Working knowledge of traditional database systems applying ETL and data movement solutions to support target data models.
• Ability to enhance and develop detailed architecture and technical design documentation and transitional and data flows
• Ability to work as a lead both independently and / or as a team member to solution design, including work by Vendors & Internal Partners
• Maintain COTS (Commercial off-the-shelf) applications including interfaces, configuration, database tuning and GUI
• Monitor vendor bulletins, sites, publication and users group for enhancements and release.
• Manage features and enhancement to mobile and web user applications
• Provide 2ndlevel support and triage assigned tickets based on priorities.
• Analyzing and improving current system integrations and migration strategies
• Identifying, debugging, and advising on system errors or architecture issues
• Work with project team members and business analysts to understand requirements and design solutions to support the project requirements
• Understand the software development life cycle, involve, and support each stage of SDLC
• Support offshore team overseeing all development activities.
• Ability to work in an Agile environment. Analyze issues with other team members and respond quickly to other business needs within the deadlines.
• Ability to communicate end to end data outcomes to all levels of the team hierarchy.
• Knowledge and know-how to troubleshoot potential issues and resolution
• Performs code reviews and makes sure development team is following standards. Ensures proper Test Coverage and Unit Testing is performed. Identify ways to utilize platform to improve productivity and make recommendations to support an organization scaling at a rapid pace
• Provide technical leadership, setting best practices (e.g., integration and application development, deployment, testing, iterative refinement).
• Self-sufficient, self-starters & quick learners on understanding Reliance’s current integration environment.

What do you bring?

• College diploma or university degree in the field of computer science, information systems
• 5+ years of application development, configuration, and support experience
• Excellent understanding of application development environments, techniques, and the key operational activities to maintaining enterprise level applications.
• Knowledge on Enterprise Service Bus (ESB) Tools and Azure Pipelines
• Experienced with Azure Data tools such as Azure Storage accounts, Azure Data Factory, Azure Databricks, Azure Automation Accounts, Azure Key vault, Azure Synapse Analytics, Azure SQL Database, Azure Analysis Services and Azure Fabric Services.
• Experienced with MS SQL SSIS, MS SQL SSRS, oData, SOAP/REST API’s, BLOG storage, Runbooks, Notebooks, Functions and code version control GIT / GitHub and DevOps
• Knowledgeable C#, Microsoft ASP.NET Web Forms, JAVA, Phyton, Json
• Demonstrated experience working with large-scale, high-availability applications.
• Experience in Database Design and development with Business Intelligence using SQL Server 2016/2019, Integration Services (SSIS), DTS Packages, SQL Server Analysis Services (SSAS), DAX, OLAP Cubes, Star Schema and Snowflake Schema.
• Used Azure download/upload tasks to download and upload blobs.
• Create automated workflows with the help of triggers, runbooks and ETL sequence.
• Excellent time and workload management skills.
• Good knowledge of System Development Life Cycle (SDLC).
• Knowledge database structuring, optimization, tuning, analysis, and recommendation.
• Design, develop and implement complex database systems, programs, and applications
• Provide thought leadership with scoping solution design for process improvements, ERD diagrams, Database architecture, and documentation.
• Excellent interpersonal and team leadership skills
• Team player with good logical reasoning ability, coordination and able to complete projects independently.
• Can act as a mentor to their fellow team members
• Fluent in written and spoken English
• Experience driving continuous improvement

Why Reliance?

As a leader in home services and energy efficient solutions for over 60 years, Reliance Home Comfort® (Reliance) is committed to being the Destination of Choice by delivering exceptional experiences for customers seeking comfort and team members seeking a rewarding, inclusive workplace. With over 2 million customer relationships, Reliance is a trusted source and has become one of Canada’s largest providers of water heaters, furnaces, heat pumps, air conditioners, water purification, plumbing, protection plans, smart home, electrical, and EV chargers. Headquartered in Toronto, Reliance employs a workforce of over 2,700 Team Members across 28 branches in Canada and two locations in the United States. Reliance has been certified as a Great Place to Work in 2024 and has been recognized as one of Canada's Most Admired Corporate Cultures by Waterstone Human Capital, for eight consecutive years since 2016. Reliance remains focused on sustainability, workplace safety, diversity, inclusivity, and prudent governance.

This posting is for an existing vacancy.

We use AI enabled tools to support parts of our selection process; however, every hiring decision is reviewed and finalized by our people.

Reliance Home Comfort is an equal opportunity employer. We welcome and encourage applications from candidates of all backgrounds including minorities and those with disabilities. Accommodations are available on request for candidates taking part in all aspects of the selection process.

For more information, please visit www.reliancehomecomfort.com.