Microsoft BI Consultant

About Cambay Solutions:

Cambay Solutions is a Microsoft Solutions Partner specializing in Azure, Dynamics 365, Microsoft 365, Power Platform, and Cloud Modernization. Recognized as one of the 50 Most Promising Microsoft Solutions Providers by CIO Review and certified as a Great Place to Work®, we help organizations transform their business through People, Process, and Technology.

About the Role

We are looking for an experienced Microsoft BI Consultant with strong Microsoft Fabric expertise to design, develop, and implement modern Business Intelligence and data analytics solutions for our clients.

The ideal candidate will have strong hands-on experience with Power BI, Microsoft Fabric, SQL, data modeling, ETL/ELT, semantic models, and enterprise reporting. The consultant will work closely with business stakeholders, data engineers, architects, and technical teams to translate business requirements into scalable and actionable BI solutions.

Microsoft Fabric experience should include working with capabilities such as OneLake, Lakehouse, Fabric Data Warehouse, Data Factory, Dataflows Gen2, semantic models, and Power BI.

Key Responsibilities

Business Intelligence & Power BI

Design, develop, and deploy enterprise-grade Power BI reports, dashboards, and analytical solutions.

Develop complex DAX measures, calculated columns, KPIs, and business logic.

Build optimized Power BI semantic models using star schema and dimensional modeling principles.

Implement appropriate connectivity modes including Import, DirectQuery, and Direct Lake where applicable.

Develop interactive dashboards and reports that provide actionable business insights.

Optimize Power BI reports, datasets, DAX queries, and overall report performance.

Implement Row-Level Security (RLS) and other Power BI security requirements.

Microsoft Fabric

Design and implement end-to-end analytics solutions using Microsoft Fabric.

Work with OneLake, Lakehouse, Fabric Data Warehouse, Data Factory, Dataflows Gen2, notebooks, and Power BI.

Develop and manage Fabric Lakehouse and Warehouse solutions for enterprise analytics.

Build data ingestion and transformation pipelines using Fabric Data Factory.

Develop ETL/ELT workflows using pipelines, Copy Jobs, Dataflows Gen2, SQL, and other Fabric capabilities. (Microsoft Learn )

Develop curated data layers to support reporting, analytics, and business intelligence.

Work with Fabric semantic models and establish reusable business metrics and definitions.

Support migration of traditional BI/data warehouse workloads to Microsoft Fabric.

Assist in designing modern Lakehouse and Warehouse architectures based on business and technical requirements.

Work with OneLake to support centralized and governed enterprise data analytics. (Microsoft Learn )

Data Engineering & Integration

Develop data integration solutions from multiple sources including SQL Server, Azure services, APIs, Excel, SharePoint, Dynamics 365, and other enterprise applications.

Design and implement scalable ETL/ELT processes.

Develop data transformation workflows using SQL, Power Query/M, Dataflows Gen2, and Fabric pipelines.

Work with incremental loads, CDC, data cleansing, transformation, and data quality processes.

Collaborate with data engineers to ensure reliable and performant data pipelines.

SQL & Data Modeling

Write complex T-SQL queries, stored procedures, views, and functions.

Design enterprise data models, dimensional models, data marts, and analytical datasets.

Develop and optimize relational data warehouse structures.

Analyze and troubleshoot data quality and performance issues.

Apply appropriate data modeling patterns for BI and reporting workloads.

Consulting & Client Engagement

Work directly with clients and business stakeholders to understand reporting and analytics requirements.

Conduct requirement-gathering and discovery workshops.

Translate business requirements into technical BI/Fabric solutions.

Provide recommendations on BI architecture, data modeling, reporting, and analytics strategy.

Create technical documentation, solution designs, data models, and implementation plans.

Present solutions and demonstrations to technical and business stakeholders.

Provide technical guidance and mentoring to junior BI developers.

Required Skills

Must Have

10+ years of experience in Microsoft Business Intelligence / Data Analytics.

Strong hands-on experience with Power BI.

Strong experience with DAX and Power Query/M.

Strong SQL/T-SQL skills.

Experience designing data models and star schemas.

Hands-on experience with Microsoft Fabric.

Experience with Fabric Lakehouse and/or Fabric Data Warehouse.

Experience with Fabric Data Factory / Pipelines / Dataflows Gen2.

Understanding of OneLake and modern data architecture. (Microsoft Learn )

Experience developing enterprise dashboards and analytical solutions.

Strong understanding of ETL/ELT concepts and data integration.