Power BI Developer

This is a fully remote position, open to applicants in United States.

📋 Description

• Establish Power Platform environments (Development / Testing / Production) utilizing Dataverse, DLP policies, and authorized connectors.

• Set up Power BI and Fabric workspaces according to each environment, including capacity allocation and naming standards.

• Provision an SQL database (Azure SQL or Fabric SQL) to manage structured scorecard data.

• Configure security groups, service principals/service accounts, and source control for solutions and reports.

• Audit existing data sources and substitute unstructured spreadsheets with structured data entries.

• Create Fabric pipelines and dataflows to systematically load, cleanse, and validate data according to a set schedule.

• Design a star-schema semantic model to serve as the primary source for reporting.

• Develop Power Automate flows for scorecard requests, reminders, approvals, and escalations.

• Implement automated data-quality assurance checks with exception routing directed to data owners.

• Integrate AI functionalities where beneficial to extract data from submitted documents, draft lessor summaries, or respond to scorecard status inquiries.

• Collaborate with business stakeholders to define the metric catalog, including KPI definitions, formulas, thresholds, and responsible parties.

• Create Power BI reports that encompass portfolio overviews, lessor scorecards, trends, and detailed drill-downs.

• Set up email notifications and subscriptions to alert for threshold violations and management updates.

• Develop Power App views for operational users to submit, review, and take action on scorecards.

• Implement role-based access control, including workspace roles, Dataverse security roles, and Power BI row-level security.

• Establish monitoring for pipeline and refresh activities with failure alerts, usage statistics, and adoption tracking.

• Create ALM procedures with deployment pipelines and change management protocols.

• Provide documentation, runbooks, and knowledge transfer to Microsoft owners.

⛳️ Requirements

• Practical experience with Power Apps, Power Automate, Dataverse, and Power BI.

• Familiarity with Microsoft Fabric (pipelines, dataflows, lakehouse/warehouse) and SQL.

• Proficient data modeling abilities, including star-schema design and DAX.

• Understanding of Power Platform governance, security, and ALM best practices.

• Capability to collaborate directly with business stakeholders to define metrics and requirements.

🏝️ Benefits

• Competitive salary and performance-based bonuses.

• Opportunities for professional development and training.

• Flexible working hours and remote work options.

• Comprehensive health and wellness benefits.