Database Analyst

Overview

Design and implement enterprise data solutions, ETL, BI, and Azure architecture.

Key Responsibilities

• data lineage
• vendor management
• resource planning
• data architecture
• etl support
• code review

Tasks

-Creation of technical documentation and data lineage designs -Engages and works effectively with 3rd party vendors. -Collaborates with the PMO, SMEs, and stakeholders to perform assessments in establishing resource, commitments, and efforts to establish priorities and workload management. -Act as the subject matter expert around complex data structures and the ability to enhance the data to be integrated across the enterprise. -Participation in each phase of development including requirements gathering, planning-analysis-design, architect-build-deploy and support. -Support team to investigate issues with the existing ETL process. -Supports and contributes to evolving the Enterprise Data Strategy and Architecture -Code review to ensure the database developments follow corporate coding standards and industry best practice.

Requirements

• azure
• power bi
• sql
• data architecture
• etl
• agile

What You Bring

-Understand Data Models, datasets and business/technical requirements to work as a lead both independently and / or as a team member to solution design, including work by Vendors & Internal Partners. -2 + years of experience Architecting and delivering solutions using the Azure Data platforms. -Ability to develop and implement end-to-end data solutions (storage, integration, processing, visualization) -Ability to apply data mining, modelling and extractions techniques in order to translate operational and applicational based system data into the desired enterprise data solution. -Proficient in Azure Analysis Services and Power BI -Excellent interpersonal and team leadership skills -Fluent in understanding of concepts surrounding data mapping, data quality, and data architecture. -Strong communication skills -Experience in Agile (Scrum) project methodology and practices -Exposure and working knowledge of ETL and migrating large data sets from varying sources. -Proficient in with SQL, DAX and/or Python -Ability to communicate end to end data outcomes to all levels of the team hierarchy. -Experience in creating and enhancing data models and metadata management. -Working knowledge of traditional database systems applying ETL and data movement solutions to support target data models. -Fluent in written and spoken English. -5+ years of Data Architecture and BI enablement experience -Knowledgably with data visualization, BI and reporting tools (Power BI)

People Also Searched For

Benefits

-Career paths so you can advance in the company -The tools you need to succeed – including the tools for the job as well as training and development programs -Competitive base pay plus the ability to earn more tied to your success – the only limit is your potential -A variety of perks for high-performing Team Members including the chance to win and be part of our annual President’s Club trip to a tropical destination -A great benefits plan for you / your family

About Reliance Home Comfort

-Born from a utility's water‑heater arm in 1999, the company has grown into a full‑service home‑comfort provider operating across Canada and parts of the U.S. -Backed by a HK-based holding, it handles rental, sale, installs, and maintenance of water heaters, furnaces, AC, plumbing, electrical, smart-home, EV chargers. -Typical projects range from next‑day furnace or water‑heater installs to all‑season protection plans covering HVAC, plumbing, and electrical maintenance. -Specialists in residential and commercial sectors, it also serves utility‑style needs via rental and protection‑plan models. -Unusually, it pioneered utility‑style rental contracts in Canada, locking customers into long‑term service agreements. -While praised for its 24/7 service and protection plans, it’s also known for aggressive sales tactics and high‑cost rental contracts.

Sector Specialisms