Microsoft Fabric Data Engineer

BBI; Toronto; On-site; CAD 90,000 - 130,000; Full time

Job summary

BBI is seeking a Data Engineer to design, build, and support scalable analytics solutions on the Microsoft Fabric platform. You will translate evolving business needs into trusted data products and shape our modern BI strategy.

In this role you will partner with stakeholders, craft Fabric-based models and pipelines, and ensure solutions are secure, cost-effective, and high-performing. You will mentor teams and contribute to enterprise analytics efforts across Azure services.

Qualifications

• Bachelor's degree or equivalent experience required.
• 5+ years delivering enterprise analytics and data engineering on Microsoft platforms.
• Strong experience with Microsoft Fabric and modern Azure analytics services.
• Certifications in Microsoft Azure / Fabric preferred.
• Solid foundation in data ingestion, transformation, storage, and warehousing; CI/CD and DevOps experience.

Responsibilities

• Partner with stakeholders to translate business requirements into Fabric-based data models and pipelines.
• Design and evolve a scalable, enterprise analytics architecture using Microsoft Fabric.
• Collaborate with infrastructure, security, Dynamics, and external teams to deliver governed analytics solutions.
• Lead design workshops, capture outcomes, and document requirements and data models.
• Develop high-performance data engineering components for large structured and semi-structured data.
• Build lakehouse and semantic models aligned with standards and best practices.
• Support governance, administration, and operational health of the Fabric platform.
• Define test strategies, data validation, and performance tuning.

Skills

Stakeholder collaboration

Data ingestion

Data transformation

Data warehousing

CI/CD

DevOps

Governance

Architectural design

Mentoring

Performance tuning

Education

Bachelor's degree in information systems, Computer Science, Software Engineering, or equivalent experience

Tools

Microsoft Fabric

Azure Analytics Services

Data Factory

Pipelines

Dataflow Gen1/Gen2

Apache Airflow

Azure DevOps

GitHub

Job description

The Data Engineer is responsible for designing, building, and supporting scalable, secure, and high-performance analytics solutions on the Microsoft Fabric platform. This role combines strong technical depth with business acumen to translate evolving business needs into trusted data products.

The individual will play a key role in shaping and executing our clients modern BI and analytics strategy.

Roles and Responsibilities

Partner closely with stakeholders to translate business requirements into Fabric-based data models, pipelines, and analytical solutions

• Contribute to the end-to-end design and evolution of a scalable enterprise analytics architecture using Microsoft Fabric
• Collaborate with Business SMEs and technical teams (Infrastructure, Security, Dynamics, external) to design and deliver sustainable, governed analytics solutions
• Assist with preparation and facilitation of design workshops with documented outcomes (requirements, design, data models)
• Ensure solutions are scalable, secure, cost-effective, and aligned with data & ai strategy
• Design and develop high-performance data engineering components capable of processing large volumes of structured and semi-structured data
• Build reusable, enterprise-grade data models (Lakehouse and semantic models) aligned with architectural standards and best practices
• Contribute to administration, governance, and operational health of the Microsoft Fabric platform
• Define and execute test strategies, including data validation, performance tuning, and data profiling
• Monitor Fabric pipelines, data refreshes, and workloads, proactively troubleshoot and resolve issues
• Own incident resolution and day-to-day sustainment of Fabric analytics solutions
• Utilize Microsoft Analytics tools for seamless integration and efficient user interface development to enhance overall user experience
• Optimize SQL, Spark, and DAX queries for performance and scalability
• Mentor analytics, functional and business teams on Microsoft Fabric capabilities, patterns, and best practices
• Contributes to work effort estimation for new and enhanced project opportunities
• Strong hands-on experience as a Data Engineer on Microsoft Fabric and Azure platforms, including:
• Fabric Lakehouse/Warehouse/Event House/ Materialized Lake view
• Fabric Ingestion (Data Factory, Pipelines, Dataflow Gen1, Dataflow Gen2, Copy Job, Notebooks, EventStream, Spark Job Definition, Spark structure streaming)
• Fabric Orchestration (Apache Airflow)
• Experience with Azure analytics services, including:

Qualifications

• Bachelor's degree in information systems, Computer Science, Software Engineering, or equivalent experience
• 5+ years of hands-on experience delivering enterprise analytics and data engineering solutions on Microsoft platforms
• Strong experience engineering solutions on Microsoft Fabric and modern Azure analytics services, with understanding and working knowledge of other industry-standard analytics and data engineering tools.
• Microsoft Azure / Fabric certifications
• Strong foundation in:
• Data ingestion and integration
• Data transformation and orchestration
• Data storage, data lakes, and lakehouse architecture
• Data warehousing and dimensional modeling
• Experience with CI/CD, DevOps, and source control (Azure DevOps, GitHub)
• Understanding of administration, security, and governance for Microsoft analytics platforms
• Experience with enterprise delivery methodologies (Agile/ Waterfall) and estimation practices
• Robust understanding of Optimization techniques to improve ingestion process