Staff Data Engineer (Azure/Databricks)

About the Company Our client is a leading Canadian energy organization with a strong presence across Ontario. They operate critical infrastructure that supports millions of customers and drives economic growth. Why Work Here Our client is engaging in ongoing transformation and investing in cutting-edge technologies and modernizing operations to meet the evolving needs of the energy sector. By joining, you will be part of an organization that values collaboration, professional development, and making a meaningful impact on the future of clean energy. About the Opportunity Architect, design, and oversee implementation of modular and scalable ELT/ETL pipelines and infrastructure. Design curated, business centric data models that provide a single source of truth for reporting and analytics. Collaborate with infrastructure and security teams to ensure data protection in transit and at rest. Establish and enforce code templates for pipeline delivery across structured, semi-structured, and unstructured datasets. Develop modeling guidelines for facts, dimensions, aggregates, and slowly changing dimensions. Optimize join performance and extensibility across multi-domain physical and semantic models. Transform data into semantic layers that align with business language and usability. Partner with analysts, scientists, engineers, and architects to deliver pipelines feeding enterprise data marketplaces. Introduce new technologies through research and proof-of-concepts, preparing production-ready designs. Work with Microsoft Azure tools including Data Factory, Data Lake, SQL Databases, Synapse, Databricks, Purview, and Power BI. Contribute within agile SCRUM frameworks, supporting backlog development and iterative delivery. Document architecture and designs, ensuring clarity and traceability. Design solutions for batch, near-real-time, event-driven, and streaming data requirements. Ensure orchestration of pipeline execution meets latency expectations and dependency management. Approve production deployments and provide Tier 3 support for troubleshooting. Guide teams in building models optimized for KPIs, operational feedback, and machine learning predictability. About You Bachelor’s degree in computer science, Software Engineering, or a related field (advanced education in data engineering, AI, or ML is an asset). 6–8 years of experience in data modeling, data warehouse design, and solution architecture in Big Data environments. Proven expertise in designing data models to solve business problems and specifying pipeline design patterns. Experience guiding data lake ingestion and modeling projects in cloud environments (Azure and Databricks). Strong background in relational and in-memory modeling, including star and snowflake schemas. Experience designing event-driven, near-real-time, or streaming data solutions across structured and unstructured sources. Advanced knowledge of data pipeline optimization, low-latency processing, and creation of common data models. Strong analytical and problem-solving skills, with a focus on scalability, performance, and maintainability. Excellent communication and leadership skills, with the ability to mentor and influence cross-discipline teams. Pay Range $87.58 - $97.58/hr How to Apply Click the “Apply Now” button and follow the instructions to submit your resume. Please know that we only accept documents in MS Word or Rich Text formats. When referencing this job, quote #480608. You must currently reside within the Greater Toronto Area and be permitted to work in Canada to be considered for this opportunity. A recruiter will be in touch with you if your profile meets our client’s requirements for this role. Determining compensation for this role (and others) at Vaco/Highspring depends upon a wide array of factors including but not limited to the individual’s skill sets, experience and training, licensure and certifications, office location and other geographic considerations, as well as other business and organizational needs. With that said, as required by local law in geographies that require salary range disclosure, Vaco/Highspring notes the salary range for the role is noted in this job posting. The individual may also be eligible for discretionary bonuses, and can participate in medical, dental, and vision benefits as well as the company’s 401(k) retirement plan. Additional disclaimer: Unless otherwise noted in the job description, the position Vaco/Highspring is filing for is occupied. Please note, however, that Vaco/Highspring is regularly asked to provide talent to other organizations. By submitting to this position, you are agreeing to be included in our talent pool for future hiring for similarly qualified positions. Submissions to this position are subject to the use of AI to perform preliminary candidate screenings, focused on ensuring minimum job requirements noted in the position are satisfied. Further assessment of candidates beyond this initial phase within Vaco/Highspring will be otherwise assessed by recruiters and hiring managers. Vaco/Highspring does not have knowledge of the tools used by its clients in making final hiring decisions and cannot opine on their use of AI products.

EEO Notice

Vaco by Highspring is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race (including but not limited to traits historically associated with race such as hair texture and hair style), color, sex (includes pregnancy or related conditions), religion or creed, national origin, citizenship, age, disability, status as a veteran, union membership, ethnicity, gender, gender identity, gender expression, sexual orientation, marital status, political affiliation, or any other protected characteristics as required by federal, state or local law.

Vaco by Highspring and its parents, affiliates, and subsidiaries are committed to the full inclusion of all qualified individuals. As part of this commitment, Vaco by Highspring and its parents, affiliates, and subsidiaries will ensure that persons with disabilities are provided reasonable accommodations. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact HR@vaco.com.

Vaco by Highspring also wants all applicants to know their rights that workplace discrimination is illegal.

Representation Notice

By submitting to this position, you agree that you will be giving Vaco by Highspring the exclusive right to present your as a candidate for the foregoing employment opportunity. You further agree that you have represented information about yourself accurately and have not affirmatively misrepresented your qualifications. You also agree to maintain as confidential, to the fullest extent permitted by law, any information you learn from Vaco by Highspring about the position and you will limit disclosure of information about the position only to the extent necessary to perform any obligations in furtherance of your application. In exchange, Vaco by Highspring agrees to exercise reasonable efforts to represent you through all solicitation, job screening and resume dispersal.

For residents of Ontario, Canada: Based on Highspring’s discussions with its Client, Highspring’s understanding is that this position for employment is a current vacancy (either through Highspring as a contractor or with the client directly).

Privacy Notice

Vaco by Highspring and its parents, affiliates, and subsidiaries (“we,” “our,” or “Vaco by Highspring”) respects your privacy and are committed to providing transparent notice of our policies.

• California residents may access Vaco by Highspring HR Notice at Collection for California Applicants and Employees here.
• Virginia residents may access our state specific policies here.
• Residents of all other states may access our policies here.
• Canadian residents may access our policies in English here and in French here.
• Residents of countries governed by GDPR may access our policies here.

Additionally, submissions to this position are subject to the use of AI to perform preliminary candidate screenings, focused on ensuring minimum job requirements noted in the position are satisfied. More details about Vaco by Highspring’s use of AI can be found here (https://www.highspring.com/ai-use-notices/). Further assessment of candidates beyond this initial phase will be conducted by recruiters and hiring managers. Vaco by Highspring does not know and cannot opine on if its client’s use of AI products in hiring.

Pay Transparency Notice

Determining compensation for this role (and others) at Vaco by Highspring depends upon a wide array of factors including but not limited to:

• the individual’s skill sets, experience and training;
• licensure and certification requirements;
• office location and other geographic considerations;
• other business and organizational needs.

With that said, as required by local law, Vaco by Highspring believes that the following salary range referenced above reasonably estimates the base compensation for an individual hired into this position in geographies that require salary range disclosure. The individual may also be eligible for discretionary bonuses.