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.

• 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 One Lake, 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.

• Minimum 3+ years of hands‑on Power BI development experience (Power BI Desktop and Service) and Microsoft Fabric (Lakehouse, Data Factory, Dataflows Gen2, Warehouse, One Lake).

• 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.

• 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.