Senior Power BI Developer - US

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.

• You are recognized as a trusted Power BI technical resource who combines development expertise, data quality discipline, and strong client collaboration.

Why Join FormativGroup

FormativGroup is a PE-backed technology consulting and implementation partner helping organizations modernize complex business platforms, improve delivery outcomes, and scale technology solutions that support long-term growth. We partner with clients across strategy, solution design, implementation, and ongoing support to help move critical initiatives from vision to execution. Our teams bring deep technical expertise, delivery discipline, and a collaborative approach to every engagement.

At FormativGroup, you'll work with people who are practical, collaborative, and focused on solving meaningful business and technology problems. We're growing, which means you'll have opportunities to contribute ideas, work closely with experienced leaders, and help shape how we deliver for clients.

Employment Eligibility

• This is a U.S.-based remote role with potential client travel.

• To be considered for this position, candidates must reside in one of the following U.S. states: AR, AZ, CA, CO, CT, DE, FL, GA, IA, ID, IL, IN, KS, KY, MA, MD, MI, MN, MO, NC, NH, NJ, NV, NY, OH, OK, OR, PA, TN, TX, VA, WI, or Washington, DC.

• Candidates residing outside these states are not currently eligible for consideration.

• Applicants must be authorized to work for any employer in the U.S.

• FormativGroup is unable to sponsor or assume sponsorship of an employment visa for this position.

• Not open to 3rd party/C2C engagement

We are committed to pay equity and transparency. The compensation range for this position represents our good faith estimate of the range we reasonably expect to pay for this role at the time of posting. The actual compensation offered will be determined based on factors such as the candidate’s experience, skills, education, work location, and internal equity. 

In addition to base pay, employees may be eligible for discretionary bonuses, commissions, or other incentive programs, as well as a comprehensive benefits package that includes medical, dental, vision, 401(k), paid time off, etc. 

Estimated Compensation Range:

$30—$40 USD

FormativGroup operates within the critical middle layer of business technology, where applications and systems connect infrastructure to business processes. We are specialists who help the middle market take full advantage of their technology investments with deep, industry-centric expertise, all in one place, to unify fragmented systems. With deep technical expertise across cloud architecture, system integration, AI, and data strategy, we bridge the gap between business goals and modern platforms.  

FormativGroup is an equal opportunity employer providing opportunities to applicants and employees without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.

ADA Specifications: Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this position. 

#formativgroupcareers #WorkWithUs

Click here to view our Privacy Policy