Sr Data and Reporting Analyst

Public Consulting Group•US OK Remote, OK

1d•$90,000 - $100,000•Hybrid

About The Position

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.

Requirements

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

Nice To Haves

Exposure to education data frameworks (e.g., Ed-Fi, SIF, CEDS, or similar) preferred
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

Responsibilities

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