BI Developer – Power BI & Fabric

Title: BI Developer – Microsoft Power BI & Fabric Role: : Full Time Location: Toronto, Canada About: At OSI Digital Inc, we accelerate our client’s digital transformation journey by delivering modern data solutions, enabling them to unlock the full potential of their data with scalable cloud platforms, intelligent analytics, and AI-driven solutions.

With deep expertise across data engineering, cloud platforms, advanced analytics, and AI/ML, our teams bring both technical mastery and business acumen to every engagement. Role Summary: We are seeking a Senior Business Intelligence Developer with strong expertise in Power BI, SQL, and Microsoft Fabric to design and deliver enterprise-grade analytics solutions.

The ideal candidate will have a minimum of 3+ years of hands-on Power BI experience, strong SQL skills, and working knowledge of Microsoft Fabric components. This role requires excellent communication skills, adaptability, intellectual curiosity, and a strong drive to take ownership of complex data challenges.

The candidate must be comfortable engaging directly with business stakeholders and delivering high-impact analytics solutions. Key Responsibilities: Design, develop, and maintain Power BI dashboards, reports, and semantic models with a strong focus on usability, scalability, and performance. Build enterprise-ready datasets with robust data modeling (star schema, relationships, aggregations, calculation groups, DAX optimization). Implement Row-Level Security (RLS) and Object-Level Security (OLS). Write advanced SQL queries (joins, CTEs, window functions, query optimization) to support analytical workloads. Develop reusable views, stored procedures, and transformation logic for analytics consumption. Develop and support solutions leveraging Microsoft Fabric including OneLake, Lakehouse/Warehouse, Dataflows Gen2, Data Factory pipelines, and semantic models. Design scalable ELT pipelines and data transformations aligned with modern Lakehouse architecture patterns. Support Direct Lake, Import, and Hybrid architectures based on business requirements and performance needs. Translate business requirements into technical design documents and scalable analytics solutions. Conduct requirement gathering sessions, workshops, and working meetings with cross-functional teams. A highly motivated and adaptable BI professional with exceptional communication skills, capable of translating complex technical concepts into clear, business-focused insights while confidently engaging with senior leadership and cross-functional stakeholders. Required Qualifications: Minimum 3+ years of hands-on Power BI development experience (Power BI Desktop and Service) and Microsoft Fabric (Lakehouse, Data Factory, Dataflows Gen2, Warehouse, OneLake). Bachelor’s degree in computer science, Engineering, or a related technical field.

A master’s degree in a relevant field is highly preferred. Strong proficiency in DAX, Power Query (M), data modeling, and semantic layer design. Strong SQL development skills with experience working on large datasets and data modeling. Experience integrating data from SQL Server, Azure SQL, APIs, cloud services, and SaaS platforms. A proactive, ownership-driven team player with a strong appetite for challenges, able to manage multiple priorities in fast-paced environments, collaborate effectively across teams, and continuously evolve with emerging data and analytics technologies. Preferred / Plus Qualifications Experience with Snowflake, Databricks, Tableau, or other modern analytics platforms. Familiarity with Azure ecosystem (ADLS, Synapse, Azure SQL, Functions). Experience with Python or other scripting languages for automation and analytics. Experience building CI/CD pipelines for Power BI or Fabric projects. Microsoft certifications (PL-300, Fabric-related certifications) are a plus. Powered by JazzHR