What are the responsibilities and job description for the Senior Business Intelligence/Data lead (Power BI) position at M Powered Strategies?
Based in Falls Church, VA, MPS is a Small Business, dedicated to empowering our clients through innovative change management services, with a focus on organizational effectiveness. Founded by a former Peace Corps volunteer, our consultants have served executives in the federal sector for over a decade, working on several high-profile initiatives. We pride ourselves on being experienced consultants, trusted advisers, and reliable partners. As a designated Employer of National Service, our core value is a commitment to public service.
Senior Business Intelligence/Data lead (Power BI)
M Powered Strategies (MPS) is seeking a Senior Business Intelligence (BI) / Data Lead to support a federal consulting engagement focused on building a sustainable data and reporting capability for a globally distributed agency.
This role will lead data assessment, data structuring, and Power BI dashboard development efforts. The ideal candidate combines strong hands-on technical skills with the ability to work directly with stakeholders to translate operational needs into practical, maintainable data solutions.
*This is not a pure engineering role — success requires comfort working with incomplete or inconsistent data, collaborating with non-technical stakeholders, and designing solutions that can be sustained by a small internal team.
Key Responsibilities
- Lead data discovery, inventory, and profiling across multiple systems (e.g., SharePoint, Excel, enterprise systems)
- Assess data quality and define approaches to improve usability and accessibility
- Design and implement data structures and transformations to support reporting needs
- Develop Power BI dashboards, including data models, DAX calculations, and visualizations
- Translate business and operational requirements into actionable reporting logic
- Collaborate with stakeholders to define KPIs, metrics, and reporting views
- Support development of a practical, maintainable data framework
- Document data definitions, transformation logic, and dashboard structures
- Support user validation and iterative refinement of dashboards
- Contribute to training and knowledge transfer to enable client self-sufficiency
Work Structure & Expectations
This role supports a phased consulting engagement with variable level of effort over time:
- Months 1–4 (Data & Requirements Phase): ~70–80% utilization
- Months 5–8 (Dashboard Development Phase): ~60–70% utilization
- Months 9–12 (Sustainment Phase): ~20–30% utilization
Work will be primarily remote, with occasional travel (including limited international travel).
Required Qualifications
- 5–10 years of experience in business intelligence, data analytics, or data-focused consulting
- Strong hands-on experience with Power BI (dashboard development, data modeling, DAX)
- Experience working with Microsoft data environments (Excel, SharePoint, Power Platform; Azure experience a plus)
- Experience working with incomplete, inconsistent, or decentralized data sources
- Ability to translate business requirements into BI and reporting solutions
- Strong communication skills and ability to work with non-technical stakeholders
- Experience supporting U.S. federal clients or similar complex organizations
Preferred Qualifications
- Experience with data governance, data quality, or data standardization efforts
- Experience supporting operational, facilities, or asset management data environments
- Experience working with geographically distributed or international organizations
- Familiarity with SQL or other data transformation tools
- Experience supporting training or knowledge transfer activities
MPS does not discriminate on the basis of race, color, religion (creed), gender, gender identity or expression, age, national origin (ancestry), disability, marital status, sexual orientation, or military status in any of its business activities including recruiting and selection. We are committed to providing a diverse, inclusive and welcoming environment for employees, volunteers, subcontractors, vendors, and clients.