About the role
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.
Originally posted on Himalayas
