Sr Data and Reporting Analyst
Job in
Salem, Marion County, Oregon, 97311, USA
Listed on 2026-06-03
Listing for:
Public Consulting Group
Full Time
position Listed on 2026-06-03
Job specializations:
-
IT/Tech
Data Analyst, Data Engineer, Database Administrator, Data Warehousing
Job Description & How to Apply Below
-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 .
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…
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×