Management Consultant - Data Analytics

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

Job summary

PCI Professional Services LLC seeks a Management Consultant in Washington, DC, for a hybrid role. The candidate will design and enhance interactive Power BI dashboards, analyze large datasets, and create executive-level reports to inform leadership decisions.

Collaboration with program managers and client leadership will translate findings into actionable guidance. Required are a Bachelor’s degree and 3+ years in data analytics or BI consulting, with strong Excel, Power Query, and Power BI

Qualifications

• Bachelor's degree in a related field.
• 3+ years of experience in data analytics or BI consulting.
• Proven experience building dashboards and visualizations with Power BI.
• Ability to translate data into actionable recommendations for executives.
• Strong communication and multi-priority management in client-facing settings.

Responsibilities

• Design, develop, maintain, and enhance interactive Power BI dashboards and reports.
• Analyze large datasets to identify trends, indicators, risks, and opportunities.
• Develop KPIs, scorecards, metrics, and executive reporting products.
• Validate data, ensure quality, and perform data cleansing.
• Create recurring and ad hoc leadership reports and presentations.
• Develop data models and visualizations to communicate insights.
• Document data sources, rules, calculations, and methodologies.
• Gather requirements from stakeholders and translate to technical solutions.
• Support data integration, automation, and reporting improvements.
• Leverage Power Platform tools to improve accessibility and efficiency.

Skills

Power BI dashboards

Data analytics

Executive reporting

KPI development

Stakeholder management

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;}

Location: Washington DC, DC

Remote Status: Hybrid

Job Id:162-HHS

# of Openings:1

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.