About the role
Brandt is seeking a highly skilled and motivated Data Engineer to join our dynamic team. The ideal candidate will have a strong background in designing, implementing, and optimizing data solutions using PowerBI, Azure, and AI technologies. As a Data Engineer, you will play a crucial role in developing and maintaining efficient data pipelines, ensuring data accuracy, and contributing to business intelligence initiatives.
Duties and Responsibilities
Data Architecture & Strategy
- Data Solution Design: Lead the architectural design, data modeling, and implementation of highly scalable data processing systems within the Azure Data ecosystem.
- Strategic Advisement: Partner with senior management and internal stakeholders to define data strategies, establish benchmarks, and translate complex business requirements into robust technical specifications.
- Enterprise Capability Advancement: Drive the maturity of our enterprise data stack, defining best practices for data organization, governance, and architecture.
Data Engineering & Optimization
- Advanced SQL & Performance Tuning: Act as the team's primary SQL authority. Proactively identify, troubleshoot, and optimize inefficient queries, fine-tune execution plans, and ensure optimal database performance.
- ETL/ELT Pipeline Development: Architect and maintain robust, scalable data pipelines to extract, transform, and load data from disparate sources into Azure Data Factory and Azure Data Lake Storage.
- Workflow Streamlining: Continuously monitor and optimize data workflows to reduce processing times, minimize compute costs, and improve overall system efficiency.
Business Intelligence & Security
- Data Security & Governance: Implement strict data security measures, including encryption, robust access controls, and data masking to safeguard sensitive enterprise information.
- PowerBI & Analytics Integration: Architect the data models that feed PowerBI, enabling the creation of interactive, high-performance dashboards that provide actionable insights to stakeholders.
#LI-ONSITE
Required Skills
-**Deep SQL Mastery:**Expert-level proficiency in SQL (T-SQL preferred). Must have hands-on experience with query optimization, execution plan analysis, indexing strategies, complex joins, window functions, and CTEs. -**Data Modeling:**Strong background in relational and dimensional data modeling (Kimball/Inmon methodologies), data warehousing, and data dependencies across enterprise systems. -**Azure Ecosystem:**Deep expertise in Azure Data Factory, Azure SQL Database, and Azure Data Lake Storage. -**Programming & BI:**Highly proficient in Python and PowerBI (including DAX and Power Query optimization). -**Emerging Tech:**Familiarity with integrating machine learning models and AI tools into existing data workflows is a strong asset.
Required Experience
- 5–10 years of proven experience in Data Architecture, with a heavy emphasis on Microsoft Azure technologies.
- Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent enterprise experience).
- Demonstrated ability to break down complex, ambiguous processes and explain highly technical concepts to non-technical senior leadership.
About Brandt Group of Companies
The Brandt Group of Companies — headquartered in Regina, Saskatchewan, Canada – is a privately owned manufacturing and distribution company that serves a growing international audience in industries such as agriculture, construction, forestry, rail, mining, steel, transportation, material handling, and energy. The company has 6000+ employees and more than 180 locations in Canada, USA, Australia, and New Zealand. Brandt is one of Canada’s largest privately owned companies and is among an elite group of Platinum Club members of Canada’s Best Managed Companies.
Le Groupe d'entreprises Brandt, dont le siège social est situé à Regina, Saskatchewan, Canada, est une entreprise privée de fabrication et de distribution qui dessert un public international croissant dans des secteurs tels que l'agriculture, la construction, la foresterie, le rail, les mines, l'acier, le transport, la manutention et l'énergie. L’entreprise compte plus de 6000 employés et plus de 180 sites au Canada, aux États-Unis, en Australie et en Nouvelle-Zélande. Brandt est l'une des plus grandes entreprises privées du Canada et fait partie du groupe d'élite des membres du Club Platine des sociétés les mieux gérées du Canada.
Similar jobs you might like
About the role
Brandt is seeking a highly skilled and motivated Data Engineer to join our dynamic team. The ideal candidate will have a strong background in designing, implementing, and optimizing data solutions using PowerBI, Azure, and AI technologies. As a Data Engineer, you will play a crucial role in developing and maintaining efficient data pipelines, ensuring data accuracy, and contributing to business intelligence initiatives.
Duties and Responsibilities
Data Architecture & Strategy
- Data Solution Design: Lead the architectural design, data modeling, and implementation of highly scalable data processing systems within the Azure Data ecosystem.
- Strategic Advisement: Partner with senior management and internal stakeholders to define data strategies, establish benchmarks, and translate complex business requirements into robust technical specifications.
- Enterprise Capability Advancement: Drive the maturity of our enterprise data stack, defining best practices for data organization, governance, and architecture.
Data Engineering & Optimization
- Advanced SQL & Performance Tuning: Act as the team's primary SQL authority. Proactively identify, troubleshoot, and optimize inefficient queries, fine-tune execution plans, and ensure optimal database performance.
- ETL/ELT Pipeline Development: Architect and maintain robust, scalable data pipelines to extract, transform, and load data from disparate sources into Azure Data Factory and Azure Data Lake Storage.
- Workflow Streamlining: Continuously monitor and optimize data workflows to reduce processing times, minimize compute costs, and improve overall system efficiency.
Business Intelligence & Security
- Data Security & Governance: Implement strict data security measures, including encryption, robust access controls, and data masking to safeguard sensitive enterprise information.
- PowerBI & Analytics Integration: Architect the data models that feed PowerBI, enabling the creation of interactive, high-performance dashboards that provide actionable insights to stakeholders.
#LI-ONSITE
Required Skills
-**Deep SQL Mastery:**Expert-level proficiency in SQL (T-SQL preferred). Must have hands-on experience with query optimization, execution plan analysis, indexing strategies, complex joins, window functions, and CTEs. -**Data Modeling:**Strong background in relational and dimensional data modeling (Kimball/Inmon methodologies), data warehousing, and data dependencies across enterprise systems. -**Azure Ecosystem:**Deep expertise in Azure Data Factory, Azure SQL Database, and Azure Data Lake Storage. -**Programming & BI:**Highly proficient in Python and PowerBI (including DAX and Power Query optimization). -**Emerging Tech:**Familiarity with integrating machine learning models and AI tools into existing data workflows is a strong asset.
Required Experience
- 5–10 years of proven experience in Data Architecture, with a heavy emphasis on Microsoft Azure technologies.
- Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent enterprise experience).
- Demonstrated ability to break down complex, ambiguous processes and explain highly technical concepts to non-technical senior leadership.
About Brandt Group of Companies
The Brandt Group of Companies — headquartered in Regina, Saskatchewan, Canada – is a privately owned manufacturing and distribution company that serves a growing international audience in industries such as agriculture, construction, forestry, rail, mining, steel, transportation, material handling, and energy. The company has 6000+ employees and more than 180 locations in Canada, USA, Australia, and New Zealand. Brandt is one of Canada’s largest privately owned companies and is among an elite group of Platinum Club members of Canada’s Best Managed Companies.
Le Groupe d'entreprises Brandt, dont le siège social est situé à Regina, Saskatchewan, Canada, est une entreprise privée de fabrication et de distribution qui dessert un public international croissant dans des secteurs tels que l'agriculture, la construction, la foresterie, le rail, les mines, l'acier, le transport, la manutention et l'énergie. L’entreprise compte plus de 6000 employés et plus de 180 sites au Canada, aux États-Unis, en Australie et en Nouvelle-Zélande. Brandt est l'une des plus grandes entreprises privées du Canada et fait partie du groupe d'élite des membres du Club Platine des sociétés les mieux gérées du Canada.