Overview
Design, develop, and optimize enterprise Power BI reporting solutions that turn complex data into accurate, accessible, and actionable business intelligence, within FormativGroup's Data & Analytics Practice.
What you'll do
- 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 need
- 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.
Nice to have
- Experience validating student loan data, including forbearance information.
- 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.
Details
- Remote, U.S.-based role with potential client travel.
- Candidates must reside in 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.
- Applicants must be authorized to work for any employer in the U.S.; visa sponsorship is not available.
- Not open to 3rd party/C2C engagement.
- Full-time employment.
Read the full description and apply on the company’s own careers page.