caferemote
OneForma

Power BI Developer

Remote United States Full-time $85K / year Posted 9 days ago
Apply now
Work from
United States
Contract
Full-time
Salary
$85K / year
Posted
11 November 2026
Apply by
10 January 2027

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.

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

Requirements

  • 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

About OneForma

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.

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.

Discussion

No comments yet. Ask a question or share a tip about this role.

Apply now

More jobs from OneForma

View company →

AI Research Engineer: Vision AI / VLM / Physical AI

OneForma
Remote United States Full-time $90K / year

About Centific Centific is a frontier AI data foundry that curates diverse, high-quality data, using our purpose-built technology platforms to empower the…

18h ago Data

Research Scientist, LLM Evaluation & Post-Training

OneForma
Remote United States Full-time $150K – $300K / year

About Centific Centific is a frontier AI data foundry that curates diverse, high-quality data, using our purpose-built technology platforms to empower the…

2 days ago Data

Principal Research Scientist – Vision AI, Simulation & Physical AI

OneForma
Remote United States Full-time $200K – $300K / year

About Centific Centific is a frontier AI data foundry that curates diverse, high-quality data, using our purpose-built technology platforms to empower the…

12 days ago Data

AI Research Engineer: Vision AI / VLM / Physical AI-1

OneForma
Remote United States Full-time $180K – $240K / year

About Centific Centific is a frontier AI data foundry that curates diverse, high-quality data, using our purpose-built technology platforms to empower the…

12 days ago Data

Similar remote jobs

Browse all →

AI Safety Expert - Bilingual

mercor
Remote United States Contract $17 – $25 / hour

About the job Mercor connects elite creative and technical talent with leading AI research labs. Headquartered in San Francisco, our investors include Benchmark , General Catalyst , Peter…

just now Data

Senior AI & Transformation Enablement Specialist

Datasite
Remote United States Full-time $83K – $141K / year

About us Datasite is the essential infrastructure for M&A. Also comprising Grata, Blueflame AI, and Sherpany, we help dealbreakers find opportunities, manage transactions, and make key…

1h ago Data

Business Analyst III Claims, DRG

Centene Corporation
Remote United States Full-time $70K – $126K / year

Position Purpose: Perform various analysis and interpretation to link business needs and objectives for assigned function. Key Details: Must be authorized to work in the U.S. without the…

1h ago Data

Functional Consultant – Epicor Kinetic (Operations & Supply Chain) – 100% Remote

TeccWeb
Remote United States Full-time

About Teccweb Teccweb is an Epicor Service Partner specializing in the implementation and optimization of Epicor Kinetic for mid-market manufacturers and distributors across North America.…

1h ago Data

Product Owner

Dev Partners
Remote Philippines Full-time

💻 We Are Hiring- Product Owner | 100% Remote We are seeking an experienced Product Owner to oversee and coordinate the ongoing maintenance, enhancement, and continuous improvement of an…

2h ago Data

Mechanical Engineer III

DLB Associates
Remote United States Full-time $105K – $135K / year

DLB Associates is a premier engineering and consulting firm specializing in innovative, mission-critical solutions across hyperscale data centers, advanced infrastructure, and…

2h ago Data

Get remote jobs the moment they are posted

Choose your categories and skills. We push matching jobs to your device. No email, ever.