Microsoft Fabric Solution Architect

Raise; Toronto; On-site; CAD 90,000 - 150,000; Full time

Job summary

Raise is seeking a Microsoft Fabric Solution Architect to design and deliver BI solutions in Toronto. You will build and maintain Power BI semantic layers, dashboards, and reports, while modelling data and datasets using Fabric tools.

You will work closely with business analysts to translate requirements into technical specs and document knowledge for the project team. The ideal candidate holds a CS degree with 5+ years in BI development, and has Fabric PL-600/PL-700 certs or equivalents.

Qualifications

• University degree in Computer Science or equivalent plus 5+ years’ BI development experience.
• Microsoft Fabric PL-600 or PL-700 certification and/or equivalent is required.
• MicroStrategy certification is an asset.
• Extensive hands-on experience building BI solutions: semantic layers, dashboards and reports with Power BI.
• Experience configuring and administering Power BI environments and deployment pipelines.
• Experience with large enterprise BI projects using Azure, Synapse, and data warehousing.
• Knowledge of SQL Server 2019+ and data modelling techniques.
• Familiarity with Azure DevOps and project documentation standards.
• Strong communication, analytical and problem-solving skills.
• Ontario accessibility requirements knowledge is a plus.

Responsibilities

• Design, develop, maintain BI platforms and related solutions.
• Develop Power BI semantic layer, dashboards, and reports.
• Model data and create datasets using Power BI and Fabric tools.
• Support end users of Power BI solutions.
• Collaborate with analysts to translate requirements into technical specs.
• Document knowledge and provide time estimates for work.
• Produce project documentation per PMO standards.
• Contribute to other project tasks as assigned.

Skills

BI development

Power BI

Data modelling

Requirements analysis

Documentation

Time estimation

Education

University degree in Computer Science or equivalent

Tools

Microsoft Power BI

Microsoft Fabric

MicroStrategy

SQL Server

Azure Synapse

Azure DevOps

Job description

Microsoft Fabric Solution Architect

• Pay Rate: Flexible
• Location: Toronto, Ontario
• Contract Length: 12 Months

Responsibilities

• Work with the Business Intelligence & Analytics team in designing, developing, maintaining the Business Intelligence and Enterprise Data platforms and associated solutions.
• Responsible for designing, developing, maintaining, and documenting Microsoft Power BI semantic layer, dashboards, and reports.
• Responsible for modelling data, designing, and creating datasets using Microsoft Power BI and Microsoft Fabric Tools.
• Responsible for supporting end users with the Microsoft Power BI.
• Work closely with the business analyst(s), and other team members to understand, and deliver on, requirements.
• Convert business requirements to technical specifications.
• Research, document, and share knowledge with the project team.
• Provide accurate time estimates for work to be undertaken.
• Create project documentation according to the Project Management Office Standards.
• Work on other project tasks as assigned.

Skills and Certifications

Mandatory Requirements

• A university degree in Computer Science, or the equivalent, combined with directly related experience in a business or computer related discipline. Minimum of 5 years’ experience working as a Business Intelligence developer.
• Microsoft’s Fabric PL-600 or PL-700 certification and/or equivalent is required.

Other Skills / Certifications Required

• MicroStrategy professional certification is an asset.
• Extensive hands-on experience developing business intelligence solutions; semantic layers, schemas, dashboards, and reports using Microsoft Power BI.
• Experience configuring and administering Microsoft Power BI environments and implementing deployment pipelines.
• Experience working as a BI developer on large Enterprise projects using Microsoft Azure, Synapse, and database related services coupled to Microsoft Power BI
• Hands-on experience developing business intelligence solutions; data cubes, schemas, dashboards and reports using MicroStrategy 2020 or later is an asset.
• Experience working with SQL Server 2019 or later.
• Good understanding of data modelling techniques relates to interfacing BI platforms to data warehouse solutions.
• Experience working with Azure DevOps.
• Well-developed interpersonal, oral, and written communication skills, strong analytical and problem-solving skills.
• Must have or rapidly acquire a comprehensive knowledge of the Ontario Human Rights Code and Related Orders including disability accommodation and accessibility requirements pertaining to passengers and employees.

Deliverables

Self-serve Analytics, Dashboards and Reporting

• Business Enterprise
  • SAP Finance, Payroll, HR
  • Legacy Payroll
  • Maximo
  • VISION
• BI / Reporting and Analytics
  • Time and Attendance reporting
  • Vacancy & Absenteeism reporting
  • Self-serve Analytics Combining Attendance, Payroll and Finance Data
  • Legacy Payroll Banked Reporting
  • Payroll Sub-Ledger Report and Self-Serve Analytics
  • BI Tool Training
• BI Reports Migration of MicroStrategy to MS Power BI

Looking for meaningful work? We can help!

Raise is an established hiring firm with over 65 years of experience. We believe strongly in making the world a better place through work, which is why we’re a certified B Corporation and donate 10% of our profits to charity.

We strive to build teams that reflect the diversity of the communities we work in. We encourage all qualified applicants to apply, including people from traditionally underrepresented groups such as women, visible minorities, Indigenous peoples, people identifying as LGBTQ2SI, veterans, and people with visible/nonvisible disabilities.

We have a dedicated webpage for accommodations where you can learn more about what we offer, and request accommodation: https://raise.jobs/accommodations/