Power BI Developer

About Centific

Centific is a frontier AI data foundry that curates diverse, high-quality data, using our purpose-built technology platforms to empower the Magnificent Seven and our enterprise clients with safe, scalable AI deployment. Our team includes more than 150 PhDs and data scientists, along with more than 4,000 AI practitioners and engineers. We harness the power of an integrated solution ecosystem-comprising industry-leading partnerships and 1.8 million vertical domain experts in more than 230 markets-to create contextual, multilingual, pre-trained datasets; fine-tuned, industry-specific LLMs; and RAG pipelines supported by vector databases. Our zero-distance innovation™ solutions for GenAI can reduce GenAI costs by up to 80% and bring solutions to market 50% faster.

Our mission is to bridge the gap between AI creators and industry leaders by bringing best practices in GenAI to unicorn innovators and enterprise customers. We aim to help these organizations unlock significant business value by deploying GenAI at scale, helping to ensure they stay at the forefront of technological advancement and maintain a competitive edge in their respective markets.

About Job

Overview

We are seeking a Power Platform and Fabric professional to design, build, and deliver an end-to-end lessor scorecard solution. The role replaces manual, spreadsheet-based scorecard tracking with a structured, automated, and secure reporting system, and hands it over to Microsoft owners with full documentation.

Key Responsibilities

1. Environment Setup

· Stand up Power Platform environments (Dev / Test / Prod) with Dataverse, DLP policies, and approved connectors

· Configure Power BI and Fabric workspaces per environment, including capacity and naming conventions

· Provision a SQL database (Azure SQL or Fabric SQL) for structured scorecard data

· Set up security groups, service principals / service accounts, and source control for solutions and reports

2. Data Integration (ETL)

· Inventory current data sources (Excel trackers, SharePoint lists, emails, existing systems)

· Replace free-form spreadsheets with structured data entry (Power Apps / Forms into Dataverse or SQL)

· Build Fabric pipelines and dataflows to load, clean, and validate data on a schedule

· Design a star-schema semantic model (lessor, property, period, metric) as the single source for reporting

3. Automation and AI

· Build Power Automate flows for scorecard requests, reminders, approvals, and escalations

· Implement automated data-quality checks with exception routing to data owners

· Where it adds value, apply AI capabilities (e.g., Copilot Studio, AI Builder) to extract data from submitted documents, draft lessor summaries, or answer questions on scorecard status

4. Metrics and Reporting

· Define the metric catalog with business stakeholders: KPI definitions, formulas, thresholds, and owners

· Develop Power BI reports, including portfolio overview, lessor scorecard, trends, and drill-down

· Configure email alerts and subscriptions for threshold breaches and periodic management packs

· Build Power App views for operational users to submit, review, and act on scorecards

5. Monitoring and Access Control

· Implement role-based access (workspace roles, Dataverse security roles, row-level security in Power BI)

· Set up pipeline and refresh monitoring with failure alerts, plus usage and adoption tracking

· Establish ALM with deployment pipelines (Dev → Test → Prod) and change control

· Deliver documentation, runbooks, and knowledge transfer to Microsoft owners

Required Skills

· Hands-on experience with Power Apps, Power Automate, Dataverse, and Power BI

· Experience with Microsoft Fabric (pipelines, dataflows, lakehouse/warehouse) and SQL

· Strong data modeling skills, including star-schema design and DAX

· Familiarity with Power Platform governance, security, and ALM practices

· Ability to work directly with business stakeholders to define metrics and requirements

Salary: $85K/Annum

Centific is an equal-opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, ancestry, citizenship status, age, mental or physical disability, medical condition, sex (including pregnancy), gender identity or expression, sexual orientation, marital status, familial status, veteran status, or any other characteristic protected by applicable law. We consider qualified applicants regardless of criminal histories, consistent with legal requirements.