Sr Data and Reporting 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
This role supports data integration, data quality, and reporting efforts for the Oklahoma statewide project, with additional support across Mid-South clients. The position focuses on executing and maintaining data processes, including monitoring imports and exports, troubleshooting data issues, and supporting reporting and data delivery needs.
The Data Integration Analyst works as part of a fast-paced, deadline-driven team to ensure data is accurate, timely, and aligned with system and client requirements. This role combines hands-on data operations with foundational data analysis, requiring both technical execution and the ability to interpret and validate data.
This position is primarily remote with occasional travel (10–30%) for client meetings and team collaboration.
Data Integration and Operations
Monitor and manage recurring data imports and exports, including nightly and scheduled processes
Troubleshoot failed imports and data issues, identifying root causes and supporting resolution
Perform manual data corrections and file adjustments to resolve data inconsistencies
Support setup and maintenance of data imports for students, users, caseloads, events, and assessments
Assist with API data flow monitoring and issue resolution
Execute and support data import, transformation, and export processes
Data Quality, Analysis, and Validation
Identify and resolve data quality issues such as duplicate records, missing fields, and validation errors
Profile and review data sets to identify patterns, inconsistencies, or gaps
Support data clean-up efforts, including student identifiers, user records, and contact data
Review incoming and outgoing data files to ensure accuracy and completeness
Assist in testing, validation, and QA of data integrations and reporting outputs
Apply data standards and naming conventions to ensure consistency across imports, exports, and reporting outputs
Support adherence to defined data structures and standards used across systems and integrations, including interoperability frameworks (e.g., Ed-Fi, SIF, or similar)
Reporting and Data Delivery
Support generation and delivery of recurring reports, including state reporting files and client-specific extracts
Pull, format, and prepare data for client requests and internal use
Assist with pushing data to downstream systems such as data warehouses via SFTP or other methods
Monitor file delivery processes and troubleshoot issues related to file transfers and timing
Develop foundational knowledge of reporting tools (e.g., Business Objects) to support data extraction and collaboration
Client Support and Collaboration
Respond to client and internal requests related to data imports, exports, and reporting
Participate in troubleshooting discussions with clients and internal teams to resolve data issues
Communicate data findings, issues, and resolutions clearly to both technical and non-technical audiences
Assist in gathering and documenting data-related requirements and client needs
Support client meetings through preparation of data summaries, findings, or supporting materials
Process Improvement and Documentation
Document standard operating procedures for data imports, exports, transformations, and troubleshooting
Maintain data dictionaries, data flow diagrams, and supporting documentation where applicable
Identify opportunities to improve data processes, reduce manual effort, and increase reliability
Support knowledge sharing across the team to improve consistency and scalability
Qualifications and Expectations
5+ years of experience in data support, data operations, or data analysis
Experience working with data files (CSV, Excel) and file transfer methods (e.g., SFTP)
Basic to intermediate SQL skills, including querying, filtering, and joining data
Strong analytical skills with the ability to review, organize, and interpret data
Experience with data validation, transformation, or import/export processes
Foundational understanding of data standards, data structures, and interoperability concepts
Demonstrated ability to apply data standards and naming conventions to ensure consistency across imports, exports, and reporting outputs
Ability to support and follow defined data structures and standards used across systems and integrations
Exposure to education data frameworks (e.g., Ed-Fi, SIF, CEDS, or similar) preferred
Strong attention to detail and ability to identify data inconsistencies and anomalies
Ability to troubleshoot issues and follow problems through to resolution
Strong organizational skills with the ability to manage multiple priorities and deadlines
Effective written and verbal communication skills across technical and non-technical stakeholders
Ability to work independently while contributing to a collaborative, team-oriented environment
Preferred Qualifications
Experience with Student Information Systems (SIS) or education data environments
Familiarity with reporting or BI tools (e.g., Power BI, SSRS, Business Objects)
Exposure to APIs, data integrations, or ETL processes
Experience with tools such as JIRA, Zendesk, or similar ticketing systems
Experience documenting data processes, requirements, or workflows
Interest in developing advanced data analysis, automation, or scripting skills
Role Focus and Scope
Primary focus on supporting the State of Oklahoma statewide project
Additional support across Mid-South clients as needed
Emphasis on execution, data quality, and operational reliability
Opportunity to grow into more advanced data analysis, integration, and client-facing consulting responsibilities over time
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: $90,000 - $100,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.