Data Architect

Brandt Group of Companies; Regina; On-site; CAD 90,000 - 130,000; Full time

Job summary

Brandt Group of Companies is seeking a Data Engineer to design, implement, and optimize data solutions using PowerBI, Azure, and AI technologies. The role focuses on building robust data pipelines, ensuring data accuracy, and enabling business intelligence for stakeholders.

You will work on data architecture, ETL/ELT pipelines, and secure data governance to support analytics initiatives across the organization.

Responsibilities

• Data Architecture & Strategy: Lead architectural design, data modeling, and implementation of scalable data processing systems within Azure Data ecosystem.
• Data Engineering & Optimization: Architect and maintain robust data pipelines to extract, transform, and load data into Azure Data Factory and Azure Data Lake Storage.
• Business Intelligence & Security: Implement data security measures, including encryption, access controls, and data masking; feed PowerBI models to create dashboards.

Skills

Data architecture

SQL

Performance tuning

Data governance

ETL/ELT design

Data security

BI analytics

Tools

PowerBI

Azure Data Factory

Azure Data Lake Storage

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.

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.