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.