Senior Analytics Data Engineer

**Proudly Canadian-owned, Enercare is committed to providing the best services, solutions and advice to make customer's homes as comfortable as they can be. With Enercare Advantage, we provide affordable clean air and water solutions for homes and workplaces. We are committed to operating in an environmentally responsible way, including keeping as much waste out of landfills as possible, and giving back to the communities where we live and work. Enercare is about putting people first by listening to our customers, continuous improvement and making our organization a destination for building people's careers.

Come and join one of North America's largest home and commercial services and energy solutions companies We offer comprehensive benefits, a DC Pension Plan and savings match plan. If you are passionate about joining an organization committed to delivering 5 Star Customer Service, we would love to hear from you.
**Role: Senior Analytics Data Engineer

Status: Full-Time, Regular

Reports to: Senior Manager, Data Strategy & Analytics

Location: Markham*
*Summary
Reporting to Senior Manager, Data Strategy & Analytics, you will play a key role in a highly visible team within the organization to advance our business as we execute our data strategy. This is a great opportunity for an individual with a passion for using data to drive insights, presenting key learnings and delivering transformational outcomes to our business. We are looking for an exceptional Senior Analytics Data Engineer, who could help us to take our data engineering and analytics reporting process to the next level.

Responsibilities

• Design, implement, and optimize scalable and secure Data Pipelines using Azure Data Factory, Azure SQL Server, Fabric Pipelines, Lakehouse, and Warehouse architectures.
• Implement and manage CI/CD/CT pipelines for data workflows, utilizing Azure DevOps, Git integration and Deployment Pipelines.
• Develop and optimize Database Objects (tables, stored procedures, views, and ETL processes to support data ingestion, transformation, and delivery.
• Ensure high availability, performance, and cost-efficiency of data systems through capacity management, monitoring, and optimization.
• In partnership with IT Cloud Ops team architect, design and manage Azure resources including Function Apps, Azure Key Vault, Azure Storage, Integration Runtime, and Entra ID.
• Support the migration of legacy processes to modern cloud-based solutions (e.g., VM Task Scheduler, Power Automate Flows).
• Analytics management of AI Services & Advanced Analytics. (such as Azure AI Foundry, AI Search, Vector DB, etc.)
• Collaborate with cross-functional teams to Integrate MLOps/AIOps frameworks, feature stores, model deployment with IT Cloud Ops, and experimentation.
• Analytics architect and support Power BI semantic modeling, dashboard development, and centralized/self-serve reporting with industrial best practices in Microsoft Fabric Platform.
• Champion analytics data engineering best practices, including code reviews, testing, and documentation.
• Ensure data security, quality, and compliance across all environments.
• Support and mentor cross-functional teams of data engineers, developers, and business developers.
• Ensure seamless integration with version control systems, particularly Git, to manage code changes and collaboration.
• Insightful understanding of Data Science and MLOps is a strong asset.

Qualifications

• 5+ years hands on experience with Azure, SQL Server, ADF Data Pipeline, ETL, and Power BI
• 5+ years of experience in developing integration solutions using Microsoft Azure Application Integration environment. Including utilization in Logic Apps, Function Apps, Functions, Service Bus, and API Management
• Proficiency in SQL, Python, DAX, and other relevant programming languages.
• Experience in data modelling and visualization; working with different data schemas and BI implementation methodologies.
• Business domain knowledge in one or more of the following: Sales, Call Centre Operations, Billing and Collections, Accounting and Finance is a plus.
• Knowledge of Microsoft Fabric is a plus.
• Knowledge of deployment pipelines and CI/CD practices using Azure DevOps.
• Excellent oral and written communications skills.

Enercare is an equal opportunity employer. We are committed to equal employment opportunity regardless of race, colour, ancestry, national origin, religion, sex, age, sexual orientation, gender identity, citizenship, marital status, disability, pregnancy, military status, protected veteran status or other characteristics protected by applicable law. Enercare's recruitment process includes accommodation for applicants with disabilities in accordance with applicable provincial accessibility laws and regulations. All accommodations will take into account the applicant's accessibility needs due to disability and are available upon request.