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 12 Test 12 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
