Data Analytics Consultant: Power BI & Exec Insights

PCI Professional Services; Washington (District of Columbia); Hybrid; USD 90,000 - 150,000; Full time

Job summary

PCI Professional Services seeks a Management Consultant - Data Analytics in Washington, DC, to deliver data-driven insights, executive reporting, and dashboard development for a federal health client. The role focuses on Power BI dashboards and analytics products to support leadership visibility into performance and initiatives.

You will translate complex data into actionable recommendations, collaborate with program managers and client leadership, and help drive operational improvements through

Qualifications

• Bachelor's degree in Data Analytics, Business Administration, Statistics, Information Systems, Public Administration, Computer Science, or a related field.
• 3+ years of experience in data analytics, business intelligence, reporting, or related consulting support.
• Demonstrated experience developing dashboards and visualizations using Power BI.
• Experience analyzing and interpreting data to support organizational decision-making.
• Strong proficiency with Microsoft Excel, Power Query, and data visualization best practices.
• Experience creating executive‑level reports, briefings, and presentations.
• Strong written and verbal communication skills.
• Ability to manage multiple priorities in a client‑facing environment.

Responsibilities

• Design, develop, maintain, and enhance interactive Power BI dashboards and reports.
• Analyze large, complex datasets to identify trends, performance indicators, risks, and opportunities.
• Develop key performance indicators (KPIs), scorecards, metrics, and executive reporting products.
• Perform data validation, data quality reviews, and data cleansing activities.
• Create recurring and ad hoc reports to support leadership decision-making.
• Develop data models, visualizations, and analytical products that effectively communicate business insights.
• Document data sources, business rules, calculations, and reporting methodologies.
• Gather business requirements from stakeholders and translate them into technical reporting solutions.
• Support data integration, automation, and reporting improvement initiatives.
• Leverage Microsoft Power Platform tools, including Power BI, Power Query, and Power Apps, to improve data accessibility and reporting efficiency.
• Recommend enhancements to existing dashboards and reporting processes.
• Maintain dashboard functionality and support ongoing updates and data refresh activities.
• Develop executive briefings, presentations, visual products, and analytical summaries.
• Support program performance management activities through data collection, analysis, and reporting.
• Prepare leadership-ready communications that clearly convey analytical findings and recommendations.
• Assist with strategic planning, process improvement, and organizational performance initiatives.
• Support stakeholder meetings by preparing reports, presentations, meeting materials, and follow-up action items.
• Collaborate with client leadership, subject matter experts, and cross-functional teams to identify business needs and reporting priorities.
• Present findings and recommendations to technical and non-technical audiences.
• Provide user support and training related to dashboard usage and reporting tools.
• Develop user guides, quick-reference materials, and supporting documentation.

Skills

Data Analytics

Power BI

KPI Development

Data Visualization

Executive Reporting

Stakeholder Management

Process Improvement

Excel

Education

Bachelor's degree in Data Analytics / related field

Tools

Power Apps

Power Query

Power Platform

Excel

Job description

PCI Professional Services seeks a Management Consultant - Data Analytics in Washington, DC, to deliver data-driven insights, executive reporting, and dashboard development for a federal health client. The role focuses on Power BI dashboards and analytics products to support leadership visibility into performance and initiatives.

You will translate complex data into actionable recommendations, collaborate with program managers and client leadership, and help drive operational improvements through