Sr Data and Reporting Analyst

About the role

The Data Integration Analyst 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.

Responsibilities

• 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
• Auxiliary support for 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
• 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
• Auxiliary support for pushing data to downstream systems such as data warehouses via SFTP or other methods
• Maintain file delivery processes and troubleshoot issues related to file transfers and timing
• 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
• Auxiliary support for gathering and documenting data-related requirements and client needs
• Auxiliary support for 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
• Auxiliary support for 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
• 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

Pay

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

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.