Data Architect

Brandt Group of Companies; Regina; On-site; CAD 85,000 - 110,000; Full time

Benefits offered by this job

Competitive compensation

Continuous learning

Advancement opportunities

Comprehensive benefits (health, dental

RRSP / Pension

Job summary

Brandt Group of Companies is seeking a Data Engineer to design, implement, and optimize scalable data pipelines using Azure, PowerBI, and AI technologies. You will drive data architecture, governance, and BI initiatives to deliver accurate insights for decision-makers across Canada, the USA, Australia, and New Zealand.

Ideal candidates will have 5–10 years of experience in data architecture with strong Azure expertise, advanced SQL skills, and proficiency in Python and PowerBI.

Qualifications

• 5–10 years of proven experience in data architecture with a heavy emphasis on Microsoft Azure.
• 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 technical concepts to non-technical senior leadership.
• Deep SQL mastery with expertise in query optimization, execution plans, indexing, joins, window functions, and CTEs.
• Data modeling experience (relational and dimensional, Kimball/Inmon) and data warehousing across enterprise systems.
• Azure ecosystem expertise: Azure Data Factory, Azure SQL Database, and Azure Data Lake Storage.
• Proficiency in Python and PowerBI (DAX and Power Query optimization).
• Familiarity with integrating machine learning models and AI tools into data workflows.

Responsibilities

• Lead architectural design, data modeling, and implementation of scalable data processing systems within Azure.
• Define data strategies with senior management and translate business requirements into technical specifications.
• Advance enterprise data stack by establishing data governance and architecture best practices.
• Develop and optimize robust ETL/ELT pipelines to ingest data into Azure Data Factory and Data Lake Storage.
• Monitor and optimize data workflows to reduce processing times and costs; improve overall system efficiency.
• Architect data models feeding PowerBI dashboards to deliver actionable insights.

Skills

SQL mastery (T-SQL)

Python

PowerBI

Data architecture & modeling

Education

Bachelor's degree in CS/IT or related field

Tools

Azure Data Factory

Azure SQL Database

Azure Data Lake Storage

Power BI / Power Query

Job description

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.

Who We Are

Brandt is a customer driven company, privately owned and family run, strengthened by diversification and succeeding through specialization. We operate over 170 locations across Canada, the USA, Australia, and New Zealand.

For nine decades, the people of Brandt have stood shoulder-to-shoulder with the hardworking people that we serve. And really, there's no place we'd rather be because just like them, it's when we're working hard and getting things done that we're at our best.

Our success is driven by a passionate belief in the unlimited potential of our company and the ultimate success of our customers and we act on that belief every single day.

That's Powerful Value, Delivered.

What You Will Be Responsible For

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.

What We Look For

• 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.
• 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.

What We Offer

• Competitive compensation: we offer fair, market-based wages that recognize your skills, experience, and contributions.
• Continuous Learning: through on-the-job training and educational opportunities.
• Opportunities for advancement within a growing company that values initiative and teamwork.
• Comprehensive benefits coverage: including health, dental and more to support your wellbeing.
• Retirement savings programs: Pension and RRSP programs to help you invest in your future

When you work for Brandt, we work for you. It's as simple as that.