Analyst, Databases

Reliance Home Comfort

Toronto

Hybrid

CAD 90,000 - 130,000

Full time

13 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Benefits plan for you and family
Career growth opportunities
Awarded Canada’s Most Admired Cultures

Job summary

Reliance Home Comfort is seeking an Analyst, Databases to contribute to evolving the enterprise data strategy and architecture. The role focuses on ETL, data movement, and supporting target data models using Azure data services and SQL Server BI.

The candidate will lead solution design with vendors and internal partners, maintain COTS applications, and drive improvements across data integrations while operating in an Agile environment.

Qualifications

  • College diploma or university degree in computer science, information systems
  • 5+ years of application development, configuration, and support experience
  • Excellent understanding of application development environments and SDLC
  • Experience with ESB Tools and Azure Pipelines
  • Experience with large-scale, high-availability applications
  • Fluent in written and spoken English

Responsibilities

  • Supports and contributes to evolving 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 both independently and with vendors/partners on solution design
  • Maintains and tunes COTS applications, interfaces, and GUIs
  • Monitors vendor bulletins and publishes relevant updates
  • Manages features and enhancements to mobile and web apps
  • Provides 2nd-level support and triages tickets by priority
  • Analyzes and improves system integrations and migration strategies
  • Debugs architecture issues and collaborates with project teams to design solutions
  • Understands SDLC and supports all stages of development
  • Supports offshore team activities and agile environment
  • Communicates end-to-end data outcomes to all team levels
  • Performs code reviews and ensures test coverage and quality standards
  • Provides technical leadership and best practices for integration and deployment
  • Self-sufficient, quick learner on Reliance’s integration environment

Skills

5+ years app development
Azure Data tools
ESB Tools
SQL Server BI
English fluency
Leadership

Education

College diploma or university degree in computer science or information systems

Tools

Azure Data Factory
Azure Databricks
Azure Synapse
Azure SQL Database
SSIS/SSRS
Git/GitHub & DevOps

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.

#LI-Hybrid

#LI-SS1

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Specialist, Marketing Data & Web Operations
Specialist, Marketing Data & Web Operations

Reliance Home Comfort • Toronto

Hybrid
CAD 65,000 - 95,000
A great benefits plan for you / your f
Career paths so you can advance in the
Analyst, Lifecycle Marketing
Analyst, Lifecycle Marketing

Reliance Home Comfort • Toronto

Hybrid
CAD 75,000 - 120,000
Benefits plan
Career growth
Hybrid work environment
+1
Manager, Digital Marketing
Manager, Digital Marketing

Reliance Home Comfort • Toronto

On-site
CAD 90,000 - 120,000
Competitive base pay
Benefits plan for you and family
Career paths and development
+1
Service Manager, Operations
Service Manager, Operations

Reliance Home Comfort • Richmond Hill

On-site
CAD 90,000 - 120,000
Competitive base pay
Training & development programs
Benefits plan for you & family
+3
Service Manager, Operations
Service Manager, Operations

Reliance Home Comfort • Edmonton

Hybrid
CAD 90,000 - 130,000
Competitive base pay
Comprehensive benefits
Career advancement
+2
Home Comfort Advisor
Home Comfort Advisor

Reliance Home Comfort • Winnipeg

On-site
CAD 40,000 - 60,000
Tools for job
Training programs
Benefits plan
+3
Home Comfort Advisor
Home Comfort Advisor

Reliance Home Comfort • Kelowna

On-site
CAD 42,000 - 60,000
Training programs
Career paths
Benefits plan
+2
Inside Sales Representative, Sales
Inside Sales Representative, Sales

Reliance Home Comfort • Greater Sudbury

On-site
CAD 42,000 - 70,000
Benefits plan for you and family
Career paths and advancement
President's Club trip eligibility
+1
Warehouse Associate
Warehouse Associate

Reliance Home Comfort • Maple Ridge

On-site
CAD 25,000 - 30,000
Tools and fully stocked trucks with on
Competitive wages with commissions/bon
Tuition reimbursement and apprentice
+2
Administration Clerk, Operations
Administration Clerk, Operations

Reliance Home Comfort • Kelowna

On-site
CAD 36,000 - 48,000
Competitive base pay
Benefits plan for you and family
Career paths and growth
+2