Data Analyst 3

Public Consulting Group•Charlotte, NC

20h•Remote

About The Position

Public Consulting Group LLC (PCG) is a leading public sector solutions implementation and operations improvement firm that partners with health, education, and human services agencies to improve lives. Founded in 1986, PCG employs approximately 2,000 professionals throughout the U.S.—all committed to delivering solutions that change lives for the better. The firm is a member of a family of companies with experience in all 50 states, and clients in three Canadian provinces and Europe. PCG offers clients a multidisciplinary approach to meet challenges, pursue opportunities, and serve constituents across the public sector. Our Education team offers consulting services and technology solutions to help schools, school districts, and state education agencies/ministries of education promote student success, improve programs and processes, and optimize financial resources. We work with clients to ensure all students have what they need to succeed. The Data Analyst 3 supports business decision-making by developing and maintaining reporting solutions that transform complex data into actionable insights. This role ensures data accuracy, integrity, and consistency across systems while monitoring ongoing data feeds and resolving data quality issues. The analyst responds to ad hoc analysis requests, contributes to user acceptance testing, and presents findings clearly to both internal stakeholders and clients. This position also leads independent projects that advance process improvements and operational effectiveness.

Requirements

Advanced proficiency in Excel (pivot tables, formulas, data analysis)
Experience with reporting tools (e.g. SAP (Business Objects), SQL, Power BI)
Knowledge of SQL for querying databases
Strong analytical and problem-solving skills
Excellent attention to detail
Effective communication and presentation skills
Flexible, self-starter possessing intellectual curiosity
Organizational and time management skills
Commitment to exceptional client service
Bachelor’s degree preferred or additional relevant years’ experience required
2-5 years in reporting, analytics, data integration or related roles
Strong understanding of Federal Data & Reporting and Compliance Standards

Responsibilities

Design, develop, and maintain scalable, well-documented reports, dashboards, and data visualizations
Translate business questions into structured analytical approaches and reporting solutions
Develop recurring reports and monitoring views that reduce reliance on ad hoc requests
Conduct quantitative and qualitative analysis using Business Objects or other similar tools to analyze trends, patterns, and performance metrics
Present findings to team members and clients regarding system reporting and functionality
Evaluate and recommend enhancements to tools, report designs, and system capabilities that improve efficiency and reduce manual effort
Monitor ongoing data feeds and ensure data accuracy, integrity, and consistency
Investigate and resolve data quality issues
Apply data standards, business rules, and data validation controls
Maintain and improve documentation for reports, data sources, and business logic
Partner with business, operational, and technical stakeholders to clarify reporting requirements and success criteria
Serve as a key liaison between internal teams and clients, tailoring communication to the audience for technical, operational, and leadership stakeholders
Support ad hoc reporting and analysis requests
Actively participate in user acceptance testing procedures in areas of assigned focus and responsibility
Recommend data-driven improvements to operational data processes and reporting practices
Share knowledge and best practices with peers and support team learning efforts
Provide Tier 2 data integration and reporting support via Zendesk
Perform special projects independently upon request or in support of independent initiatives