Business object Power BI Consultant

Job title: Business object Power BI

Location: Mississauga-Ontario-CA

Job Description:

This is a hands-on engineering leadership role The candidate will be expected to personally build pipelines and notebooks develop PySpark solutions implement CICD review code manage deployments troubleshoot failures and support production workloads.

Expert level hands-on experience designing building deploying and supporting enterprise grade Microsoft Fabric solutions The candidate must independently develop solutions and resolve production issues.

Required Skills

Microsoft Fabric Platform

• Fabric Workspace Management One Lake Lakehouse and Fabric Warehouse SQL Analytics Endpoint Semantic Models Medallion Architecture One Lake Shortcuts Good to have understanding of workspace security RBAC and governance

Data Engineering Development

• PySpark Python Spark SQL and TSQL Fabric Notebooks Delta Tables and Delta Lake dimensional data modeling metadata driven frameworks data transformation validation and business rule implementation

Data Integration Ingestion

• Fabric Data Factory Pipelines Dataflow Gen2 metadata driven ingestion batch and incremental loads CDC patterns API and file based ingestion SharePoint and SFTP ingestion integration with Oracle cloud and external sources

Consumption Data Access

• Fabric SQL Endpoints REST and GraphQL APIs external application integration reverse ETL Semantic Models and enterprise reporting Power BI SharePoint file drop and distribution email based delivery and notifications external file exchange and data sharing patterns

DevOps CICD Release Management

• Fabric Git integration source control and branching CICD pipeline implementation deployment pipelines automated code promotion DEV SIT UAT and PROD environment management build validation release automation and rollback support

Hands-on Leadership Support

• Active participation in solution design coding code reviews testing deployment troubleshooting performance optimization and L3 production support technical leadership client interaction and mentoring of Fabric engineering teams.

We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, citizenship status, age, disability, genetic information, protected veteran status, or any other characteristic protected by applicable law. https://www.e-verify.gov/sites/default/files/everify/posters/IER_RighttoWorkPoster.pdf