Data Analyst 3

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. To learn more, visit www.publicconsultinggroup.com.

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.

Services:
Teaching

Learning Solutions

Data Systems

IT Solutions

Financial Solutions

Equity in Education

Equitable Education

Recovery Services

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. manner. This position also leads independent projects that advance process improvements and operational effectiveness.

Duties and Responsibilities 
Reporting & Analytics 
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 
Data Quality 
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 
Team Collaboration 
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 
Tools and Processes 
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 
 
Required Skills 
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 
 
Qualifications 
Bachelor’s degree preferred or additional relevant years’ experience required 
Mid-level: 2-5 years in reporting, analytics, data integration or related roles 
Strong understanding of Federal Data & Reporting and Compliance Standards 

Compensation:
Compensation for roles at Public Consulting Group varies depending on a wide array of factors including, but not limited to, the specific office location, role, skill set, and level of experience.  As required by applicable law, PCG provides a reasonable range of compensation for this role. In addition, PCG provides a range of benefits for this role, including medical and dental care benefits, 401k, PTO, parental leave, bereavement leave.

Range: $73,000 - $90,000
#LI-AH1
#LI-remote

PCG does not sponsor newly hired foreign national workers for work authorization, including H-1B sponsorship.

EEO Statement:

Public Consulting Group is an Equal Opportunity Employer dedicated to celebrating diversity and intentionally creating a culture of inclusion. We believe that we work best when our employees feel empowered and accepted, and that starts by honoring each of our unique life experiences. At PCG, all aspects of employment regarding recruitment, hiring, training, promotion, compensation, benefits, transfers, layoffs, return from layoff, company-sponsored training, education, and social and recreational programs are based on merit, business needs, job requirements, and individual qualifications.

We do not discriminate on the basis of race, color, religion or belief, national, social, or ethnic origin, sex, gender identity and/or expression, age, physical, mental, or sensory disability, sexual orientation, marital, civil union, or domestic partnership status, past or present military service, citizenship status, family medical history or genetic information, family or parental status, or any other status protected under federal, state, or local law. PCG will not tolerate discrimination or harassment based on any of these characteristics. PCG believes in health, equality, and prosperity for everyone so we can succeed in changing the ways the public sector, including health, education, technology and human services industries, work.