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 solid 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
#J-18808-Ljbffr
📌 Data Engineer (Toronto)
🏢 BBI
📍 Toronto