Management Consultant - Data Analytics

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

Job summary

PCI Professional Services LLC in Washington, D.C. is seeking a Management Consultant to design and deliver interactive Power BI dashboards and reporting solutions.

The role focuses on turning complex datasets into actionable insights for executive leadership, with a hybrid work arrangement reporting to the Program Manager. The ideal candidate has experience in data analytics, BI development, and stakeholder communication, and will develop KPIs, scorecards, and executive briefs to drive

Qualifications

• Bachelor's degree in 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.

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.

Skills

Data analytics

KPI development

Stakeholder management

Executive reporting

Presentation skills

Process improvement

Client engagement

Strong communication

Education

Bachelor's degree in Data Analytics, Business Administration, Statistics, Information Systems, Public Administration, Computer Science, or a related field

Tools

Power BI

Power Query

Power Apps

Excel

Job description

#gnewtonJobDescription #gnewtonJobLocation, #gnewtonJobDescription #gnewtonJobLocationInfo {display: table-cell !important;}

Remote Status: Hybrid

PCI Professional Services is seeking a Management Consultant for an upcoming opportunity in Washington, D.C. This position is hybrid and will report to the Program Manager.

Position Overview

The ideal candidate possesses strong analytical skills, experience working with complex datasets, and the ability to translate technical findings into clear, actionable recommendations for executive stakeholders. This individual will work closely with program managers, communications specialists, and client leadership to develop reporting solutions that improve transparency, facilitate decision-making, and drive operational improvements.

Key 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.

Strategic & Program Support

• 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.

Stakeholder Engagement

• 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.

Required 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.

Preferred Qualifications

• Experience supporting federal government clients.
• Familiarity with acquisition, procurement, workforce, financial, or operational data.
• Experience with Power Apps and Power Automate.
• Knowledge of data governance, performance measurement, and business process improvement practices.
• Experience supporting senior executive stakeholders.

Desired Skills

• Power BI
• Data Analytics
• KPI and Metrics Development
• Power Platform
• Advanced Excel
• Executive Reporting
• Strategic Communications
• Process Improvement
• Stakeholder Management
• Presentation Development

PCI Federal (PCIF) and its subsidiaries are an equal-opportunity employer. PCIF does not discriminate on the basis of age, sex, race, national origin, religion, marital status, sexual orientation or identity, Veterans or Disability status.

Preference may be extended to qualified Native American Indian candidates in accordance with applicable federal law.