Public Consulting Group

Sr Data Analyst - Education

Job Locations US
Posted Date 1 week ago(6/14/2024 3:51 PM)
Job ID
# of Openings
Operation Support
Regular Full-Time
Practice Area
Education Services


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 six 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 





Duties and Responsibilities:




  • Works with internal and external clients to identify analytical requirements.
  • Writes advanced SQL queries and perform complex data mining techniques to capture appropriate data.
  • Produces reports, dashboards, and data visualizations to satisfy client requirements.
  • Automates business processes with Power Apps and Flows.
  • Documents processes and procedures used to produce reports.
  • Performs business analysis to identify opportunities for business improvement.
  • Interprets results of data analysis to business users.
  • Leads special projects, including delegation and validation of tasks to other team members.
  • Liaises with IT team on regarding data governance and requirements of the data warehouse.
  • Participates in an Agile team as a Team Member.





Required / Desired Experience: 




  • Bachelor's degree (Required).
  • 4+ years' work experience in Data Analysis



Required Skills:



  • T-SQL (complex queries, joins, unions, creating tables, etc.).
  • Reporting Services & Report Builder.
  • Power BI.
  • DAX.
  • SQL Server (SSMS, SSIS).
  • Microsoft Power Apps.
  • Microsoft Flow.
  • Excel (PivotTables, various functions like VLOOKUP, SUMIFS, etc.)
  • R and M a plus.
  • Strong understanding of relational databases and data warehouses.
  • Microsoft Office.
  • Critical thinking and problem solving.




Remote Work Statement: 




This position is a remote, work from home position. PCG is a remote-friendly organization and is committed to creating a culture where remote work remains a vital part of the company’s success. To be successful in a remote work role at PCG, you must:




  • be available during your set working hours
  • have a safe, private, and distraction-free environment in which to complete your work, and
  • be able to give your full attention to the completion of your PCG job duties




Some travel to the office or elsewhere may be required for team meetings, client meetings, etc.










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 the following reasonable range of compensation for this role: $70,000 - $90,000 and a potential discretionary bonus of up to 10%. In addition, PCG provides a range of benefits for this role, including medical and dental care benefits, 401k, PTO, parental leave, bereavement leave.

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.


Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed