Overview
Software International (SI) supplies technical talent to a variety of clients ranging from Fortune 100/500/1000 companies to small and mid-sized organizations in Canada/US and Europe.
We currently have a long term contract role as a Senior Data Engineers (x2) - Microsoft Fabric with our global SAP consulting client, working at a large CPG clients' locations either in Montreal or Mississauga. This is a hybrid role with some weekly in office visits (2 days onsite).
Role
Senior Data Engineers (x2) - Microsoft Fabric
Type: Contract
Duration: 6 months to start + 6 month extensions
Rate: C2C - open based on overall experience (target range is about $60-90/hr)
Language Requirements: English (French is a nice to have)
Location: Hybrid - Montreal or Mississauga
Role Summary
Our consulting client is seeking 2 Senior Data Engineers to design, build, and optimize scalable data pipelines and data products within our Microsoft Fabric and SAP BW ecosystem. This role will ensure data products are standardized, governed, and AI-ready, serving as the backbone of clients Data Product Foundation. The Senior Data Engineer will collaborate with architects, automation leads, and business teams to deliver high-quality, production-ready data solutions.
Key Responsibilities
- Pipeline Development: Design, build, and maintain efficient, reusable, and scalable ETL/ELT pipelines in Microsoft Fabric, integrating data from SAP BW and other enterprise sources.
- Data Product Engineering: Engineer standardized data products with strong focus on quality, discoverability, and reusability.
- Automation Collaboration: Implement automation patterns and frameworks that accelerate data product creation.
- Data Modeling: Develop and optimize semantic models, star schemas, and data warehouse structures to support reporting and analytics.
- Governance & Quality: Ensure compliance with data governance, lineage, and quality standards; implement observability and monitoring for pipelines.
- Performance Optimization: Troubleshoot and optimize pipelines, ensuring high performance and reliability in production environments.
- Continuous Improvement: Stay current with new features in Microsoft Fabric, SAP integration methods, and modern data engineering practices.
Qualifications
- 10+ years of experience as a Data Engineer, BI Engineer, or similar role.
- Strong expertise in Microsoft Fabric, Data Factory, Power BI, and Data Lakehouse architectures.
- Experience integrating and transforming data from SAP BW and ERP systems.
- Experience with real-time data integration.
- Advanced SQL, Python, Java, C#, KQL, PowerShell scripts for data engineering and automation.
- Proven track record of building and maintaining production-grade data pipelines at scale.
- Familiarity with data governance, lineage, observability, and DataOps for data.
- Strong collaboration skills, with ability to work across technical and business teams.
- Experience in performance tuning and optimization of large-scale data systems.