Sr Data and Reporting Analyst

Public Consulting Group; United States; On-site; USD 80,000 - 100,000; Full time

Job summary

A leading public sector solutions firm is seeking a Sr Data and Reporting Analyst to join their team. The ideal candidate will manage data projects, perform data analysis, and communicate effectively with clients. This role offers opportunities for leadership and is suited for an experienced analyst comfortable with both high-level analysis and hands-on tasks.

Benefits

Medical Benefits

Dental Benefits

401k

PTO

Parental Leave

Bereavement Leave

Qualifications

• 5+ years data analyst experience, ideally with technical and client-facing responsibilities.
• Experience with K-12, special education, or Medicaid claiming is desired.

Responsibilities

• Manage projects, set scope, and collaborate with stakeholders.
• Profile data sets and document validation and transformation rules.
• Prepare data analysis and agendas for client meetings.

Skills

Analytical Skills

Communication Skills

Project Management

Data Analysis

Attention to Detail

Education

Bachelor’s Degree

Tools

MS Office

Visio

MS Project

Zendesk

JIRA

Python

SQL

SAP Business Objects

Job description

Join to apply for the Sr Data and Reporting Analyst role at Public Consulting Group

Join to apply for the Sr Data and Reporting Analyst role at Public Consulting Group

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.

The Education Data Analyst works as part of a deadline-oriented, fast-paced team consisting of consulting and operations staff that works together to provide superior service to state education agencies and school districts in the areas of special education management systems, data warehousing, federal reporting, and other programs. The Analyst will be responsible for reviewing, formatting, importing/exporting, transforming, validating, or modeling data with the purpose of understanding or drawing conclusions to drive strategic and operational decision-making.

This role is suited for a more experienced analyst who is comfortable handling both high-level data analysis and hands-on tasks like processing imports. Additionally, while this role does not immediately require direct supervision, the ideal candidate should be open to leadership opportunities in the future.

Position Requirements

• Project Management. For smaller projects, the Analyst will manage directly, setting scope, managing schedule, issues, risks, and collaborating with internal and client stakeholders. For larger, more complex projects, the Analyst may work with a dedicated project manager.
• Documentation. The Analyst will be responsible for ensuring that all data projects have clearly documented scope and elaborated requirements to manage and validate data engineering.
• Data Analysis. The Analyst will be expected to profile data sets, recognize the existence or absence of patterns in the data, map to and extend PCG’s Data Schemas, document validation and transformation rules, design and execute import, transformation, and export processes, and explore analytics and visualizations.
• Data Engineering. This role requires an understanding of programming logic, although no experience with a specific programming language is required. The Analyst will be expected to write scripts, queries, formulas, and procedures to automate data ETL processes.
• Communication Skills. The Analyst must communicate well with clients, team members, and ancillary resources. This includes both presenting ideas or findings, as well as drawing out client or team member key concerns or other relevant information.
  
  

Specific Responsibilities

• Maintains data dictionaries, data flow diagrams, etc. for EDPlan processes and related functions
• Ensures client success by working with clients to resolve issues, provide user support, and collaborate with clients in design specifications for report requests.
• Prepares data analysis and agendas for client meetings
• Travels to and presents at status update meetings to clients, as needed
• Documents client discussions, gathers requirements, and engages technical team as it relates to emerging data structure and reporting needs, in close partnership with the project leads
• Software implementation activities including data migration, data integration, site preparation, and project management
• Oversees and performs data QA, testing, and validation
• Assists school districts in uploading the data into our system
  
  

Required Skills

• Strong analytical skills and careful attention to detail, including the ability to analyze and organize data
• Proficiency in MS Office products: Access, Excel, PowerPoint, and Word
• Expertise in creating/using scripts, macros, formulas, and other similar data wrangling skills and techniques
• Excellent organizational, oral presentation, and written communication skills
• Ability to work independently and take ownership of projects while also contributing to team leadership and fostering a collaborative environment
  
  

Preferred Skills

• Previous experience utilizing Visio, MS Project, Zendesk, and JIRA
• Research and project management capabilities
• Previous experience utilizing Python, SQL, SAP Business Objects, SIF Unity, or other data platforms
  
  

Required Experience

• Bachelor’s degree and/or prior data analysis experience
• 5+ years data analyst experience, ideally in a role with both technical and client-facing responsibilities
• Experience with supervising or mentoring team members is a plus, or a willingness to take on leadership in the future
• 1+ years of schools (K-12), special education and/or Medicaid claiming experience is desired
  
  

Salary range: $80,000 - $100,000.



#EDU

The above is intended to describe the general contents and requirements of work being performed by people assigned to this classification. It is not intended to be construed as an exhaustive statement of all duties, responsibilities or skills of personnel so classified.

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 the following reasonable range of compensation for this role below. 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.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Professional Services

Referrals increase your chances of interviewing at Public Consulting Group by 2x

Get notified about new Data Reporting Analyst jobs in United States.

United States $60,800.00-$82,900.00 4 days ago

Data Reporting Business Analyst (Remote - US)

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.