Note: The job is a remote job and is open to candidates in USA. 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. The Sr Data and Reporting Analyst role focuses on supporting data integration, data quality, and reporting efforts, ensuring data accuracy and alignment with client requirements while working as part of a fast-paced team.
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
Skills
- 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
- Exposure to education data frameworks (e.g., Ed-Fi, SIF, CEDS, or similar)
- 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
Benefits
- Medical and dental care benefits
- 401k
- PTO
- Parental leave
- Bereavement leave
Company Overview
Public Consulting Group is a consulting company offering management consulting services to public sector organizations and entities. It was founded in 1986, and is headquartered in Boston, Massachusetts, USA, with a workforce of 1001-5000 employees. Its website is http://www.publicconsultinggroup.com/.