Senior Power BI Developer - US

FormativGroup; United States; Remote; USD 120,000 - 160,000; Full time

Job summary

FormativGroup is seeking a Senior Power BI Developer to design, build, and optimize enterprise reporting solutions. You will work closely with business stakeholders to deliver secure, reliable BI environments, dashboards, and data visualizations that enable informed decision-making.

You will lead BI development, validate data, and establish best practices while collaborating across technical teams. The role blends hands-on development with leadership, documentation, training, and knowledge

Qualifications

• 5+ years of advanced hands-on Power BI development experience.
• Experience designing complex Power BI reports, dashboards, and visuals.
• Knowledge of data modeling, DAX, and performance optimization.

Responsibilities

• Design, configure, and maintain a stable Power BI Service environment for enterprise reporting.
• Develop and enhance interactive dashboards, reports, and data visualizations for business users and executives.
• Build complex custom visuals and UI aligned with specifications.
• Perform data validation, reconciliation, and quality assurance across datasets.
• Design and optimize data models and reporting logic to support BI solutions.
• Develop data refresh strategies across enterprise sources including Azure SQL Server.
• Implement reporting security, RBAC, and governance controls.
• Collaborate with developers and business teams to improve functionality and performance.
• Gather requirements and document reporting needs for technical discussions.
• Create technical documentation, guides, and support materials.
• Lead Power BI training and knowledge transfer sessions.

Skills

Power BI development

Data modeling

DAX

Power Query

Azure SQL Server

Security & governance

Stakeholder communication

Tools

Azure SQL Server

Power BI Service

Microsoft Fabric

Power BI Dataflow

Job description

Are you an experienced Power BI Developer who enjoys transforming complex data into meaningful insights and intuitive reporting solutions? If you bring advanced dashboard development expertise, strong data validation skills, and the ability to design secure, reliable reporting environments while collaborating directly with business stakeholders, we'd love to connect with you!

About the role

The Senior Power BI Developer role is focused on designing, developing, and optimizing enterprise reporting solutions that turn complex data into accurate, accessible, and actionable business intelligence.

As part of FormativGroup's Data & Analytics Practice, you'll support the development of a stable, scalable Power BI Service environment, building advanced dashboards, custom visualizations, and reporting capabilities that support critical business operations and decision-making.

You'll work closely with business users, technical teams, and client leadership to gather requirements, validate data, improve reporting functionality, and establish best practices. This role combines hands-on Power BI development with technical leadership, documentation, training, and knowledge transfer.

What You'll Work On

As a Senior Power BI Developer, you will:

• Design, configure, and maintain a stable, secure, and reliable Power BI Service environment supporting enterprise reporting requirements.
• Develop and enhance interactive Power BI dashboards, reports, and data visualizations for business users and executive stakeholders.
• Build complex custom Power BI visualizations and user interfaces aligned with business and technical specifications.
• Perform comprehensive data validation, reconciliation, and quality assurance across multiple datasets to ensure reporting accuracy and consistency.
• Design and optimize data models, calculations, and reporting logic to support reliable business intelligence solutions.
• Develop and maintain data refresh strategies integrating Azure SQL Server and other enterprise data sources.
• Implement reporting security, accessibility, role-based access, and data governance controls aligned with organizational standards.
• Partner with developers and technical teams to improve reporting functionality, optimize performance, and establish Power BI development best practices.
• Gather and document business requirements, identify opportunities for reporting enhancements, and facilitate technical discussions with stakeholders.
• Develop comprehensive technical documentation, reporting specifications, user guides, and support manuals.
• Lead Power BI training sessions, mentoring, and collaborative development activities with business users and technical teams.
• Validate report functionality, performance, accessibility, and compliance with client requirements.
• Provide regular project status reporting, including daily progress updates, milestones, risks, and deliverables.
• Support testing, deployment, troubleshooting, and ongoing optimization of Power BI reporting solutions.
• Conduct knowledge transfer sessions to support long-term reporting maintenance, platform adoption, and internal team capabilities.

What You’ll Bring

You will likely be successful in this role if you have:

• 5+ years of advanced hands-on Power BI development experience, including enterprise dashboards, reporting solutions, and Power BI Service administration.
• Strong experience designing complex Power BI reports, interactive dashboards, and custom visualizations.
• Advanced knowledge of Power BI data modeling, DAX, Power Query, and reporting performance optimization.
• Experience integrating Power BI with Azure SQL Server and other enterprise data sources.
• Strong experience performing data validation, reconciliation, and quality assurance across multiple datasets.
• Experience configuring Power BI Service environments, including workspace management, security, access controls, and data refresh strategies.
• Understanding of reporting governance, accessibility requirements, and enterprise data security practices.
• Experience gathering business requirements, facilitating technical meetings, and translating reporting needs into effective Power BI solutions.
• Strong technical documentation skills, including development specifications, reporting manuals, and knowledge transfer materials.
• Experience leading Power BI training, mentoring, and collaborative development sessions.
• Ability to communicate effectively with technical teams, business users, and senior leadership.
• Strong presentation and facilitation skills across both formal and informal stakeholder settings.
• Strong analytical thinking, troubleshooting abilities, and attention to detail.
• Experience managing deliverables, tracking milestones, and providing project status updates directly to clients.

How You Work

The ideal candidate will:

• Take ownership of reporting solutions from requirements gathering through development, validation, deployment, and ongoing optimization.
• Approach complex data and reporting challenges with analytical discipline, attention to accuracy, and a commitment to reliable business intelligence.
• Communicate technical concepts clearly to both technical and non-technical stakeholders, including senior leadership.
• Collaborate effectively with developers, business users, and client teams to continuously improve reporting functionality and usability.
• Bring a structured, proactive approach to documentation, project reporting, technical training, and knowledge transfer.

Bonus Points If You Have

• Experience validating student loan data, including forbearance information, is highly preferred.
• Experience supporting financial services, student lending, education finance, or government reporting environments.
• Experience developing advanced Power BI custom visuals or specialized user interface components.
• Familiarity with Microsoft Fabric, Azure Data Factory, or other Azure data integration technologies.
• Experience implementing Power BI row-level security (RLS), governance standards, and enterprise reporting controls.
• Experience optimizing large-scale Power BI datasets, semantic models, and scheduled refresh processes.
• Experience supporting reporting modernization, data migration, or enterprise business intelligence initiatives.
• Microsoft Power BI or related Microsoft data platform certifications.

What Success Looks Like

Power BI Service operates as a stable, secure, and reliable environment supporting business-critical reporting.

Dashboards, reports, and custom visualizations meet business requirements while delivering accurate, meaningful insights.

Data validation processes strengthen reporting accuracy, consistency, and stakeholder confidence.

Reporting performance, security, accessibility, and refresh processes align with client standards and operational needs.

Business users and technical teams benefit from effective documentation, training, and knowledge transfer.

Project milestones, reporting deliverables, and stakeholder communications are managed consistently and transparently.