[Remote] Sr Data and Reporting Analyst

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.ResponsibilitiesMonitor and manage recurring data imports and exports, including nightly and scheduled processesTroubleshoot failed imports and data issues, identifying root causes and supporting resolutionPerform manual data corrections and file adjustments to resolve data inconsistenciesSupport setup and maintenance of data imports for students, users, caseloads, events, and assessmentsAssist with API data flow monitoring and issue resolutionExecute and support data import, transformation, and export processesIdentify and resolve data quality issues such as duplicate records, missing fields, and validation errorsProfile and review data sets to identify patterns, inconsistencies, or gapsSupport data clean-up efforts, including student identifiers, user records, and contact dataReview incoming and outgoing data files to ensure accuracy and completenessAssist in testing, validation, and QA of data integrations and reporting outputsApply data standards and naming conventions to ensure consistency across imports, exports, and reporting outputsSupport 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 extractsPull, format, and prepare data for client requests and internal useAssist with pushing data to downstream systems such as data warehouses via SFTP or other methodsMonitor file delivery processes and troubleshoot issues related to file transfers and timingDevelop foundational knowledge of reporting tools (e.g., Business Objects) to support data extraction and collaborationRespond to client and internal requests related to data imports, exports, and reportingParticipate in troubleshooting discussions with clients and internal teams to resolve data issuesCommunicate data findings, issues, and resolutions clearly to both technical and non-technical audiencesAssist in gathering and documenting data-related requirements and client needsSupport client meetings through preparation of data summaries, findings, or supporting materialsDocument standard operating procedures for data imports, exports, transformations, and troubleshootingMaintain data dictionaries, data flow diagrams, and supporting documentation where applicableIdentify opportunities to improve data processes, reduce manual effort, and increase reliabilitySupport knowledge sharing across the team to improve consistency and scalabilitySkills5+ years of experience in data support, data operations, or data analysisExperience working with data files (CSV, Excel) and file transfer methods (e.g., SFTP)Basic to intermediate SQL skills, including querying, filtering, and joining dataStrong analytical skills with the ability to review, organize, and interpret dataExperience with data validation, transformation, or import/export processesFoundational understanding of data standards, data structures, and interoperability conceptsDemonstrated ability to apply data standards and naming conventions to ensure consistency across imports, exports, and reporting outputsAbility to support and follow defined data structures and standards used across systems and integrationsStrong attention to detail and ability to identify data inconsistencies and anomaliesAbility to troubleshoot issues and follow problems through to resolutionStrong organizational skills with the ability to manage multiple priorities and deadlinesEffective written and verbal communication skills across technical and non-technical stakeholdersAbility to work independently while contributing to a collaborative, team-oriented environmentExposure to education data frameworks (e.g., Ed-Fi, SIF, CEDS, or similar)Experience with Student Information Systems (SIS) or education data environmentsFamiliarity with reporting or BI tools (e.g., Power BI, SSRS, Business Objects)Exposure to APIs, data integrations, or ETL processesExperience with tools such as JIRA, Zendesk, or similar ticketing systemsExperience documenting data processes, requirements, or workflowsInterest in developing advanced data analysis, automation, or scripting skillsBenefitsMedical and dental care benefits401kPTOParental leaveBereavement leaveCompany OverviewPublic 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/.