Sr Data Analyst

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 works as part of a deadline-oriented, fast-paced team consisting of consulting and operations staff that works together to provide superior service to states and large school districts in the areas of special education management systems, data warehousing, federal claiming, and other programs. This role is responsible for executing data migration and integration tasks, validating data quality, and supporting the implementation of data systems. The analyst will work independently to review, format, import/export, transform, validate, and model data to support strategic and operational decision-making.

Overall Responsibilities:   

The 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 states and large school districts in the areas of special education management systems, data warehousing, federal claiming, and other programs. This role is responsible for executing data migration and integration tasks, validating data quality, and supporting the implementation of data systems. The analyst will work independently to review, format, import/export, transform, validate, and model data to support strategic and operational decision-making.

Position Requirements:

• Data Migration & Integration. The Data Analyst must have demonstrated experience performing complex data migrations and integrations across multiple systems and formats, including flat files, databases, and APIs. This includes validating data accuracy, resolving discrepancies, and ensuring seamless data flow between systems.
• Data Analysis. The Data Analyst will profile data sets, identify patterns or anomalies, map data to internal schemas, document validation and transformation rules, and design and execute import, transformation, and export processes.
• Data Engineering. This role requires an understanding of programming logic. The Data Analyst will write scripts, queries, formulas, and procedures using tools such as MS Access or similar to automate ETL processes.
• Documentation. The Data Analyst will ensure that all data projects have clearly documented scope, requirements, and validation criteria to support data engineering and quality assurance.
• Communication Skills. The Data Analyst must communicate effectively with team members and stakeholders, presenting findings and gathering requirements to ensure alignment and clarity.
• Project Management. The Data Analyst will manage their own tasks and timelines, collaborating with internal stakeholders to ensure successful delivery of data-related projects.

Specific Responsibilities

• Executes and validates software implementation activities including data migration, data integration, and site preparation.  
• Writes advanced SQL queries and performs complex data mining techniques to capture appropriate data.
• Conducts data quality assurance and validation.
• Reviews data analysis and prepares materials and agendas for client meetings.
• Assists strategic customers in submitting electronic data and uploading the data into our systems.
• Creates and maintains data dictionaries, data flow diagrams, etc. for reports and related functions