Sr Data and Reporting Analyst
Public Consulting Group
- # Sr Data and Reporting AnalystApplylocations: UStime type: Full timeposted on: Posted Todayjob requisition id: JR101853Public 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. Founded in 1986, PCG employs approximately 2,000 professionals throughout the U.S.—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 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 ServicesThis 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 processesData 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 collaborationClient 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 materialsProcess 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 scalabilityQualifications 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* 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* 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 environmentPreferred 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 skillsRole 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**Compensation:**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#LI-AH1#LI-remotePCG does not sponsor newly hired foreign national workers for work authorization, including H-1B sponsorship.**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.
- J-18808-Ljbffr Public Consulting Group
Vacancy posted 2 days ago
Similar jobs that could be interesting for youBased on the Sr Data and Reporting Analyst in Brooklyn, NY vacancy
- ...Senior Quant Data Analyst Our client, a global Asset Management firm, is looking for a senior Quant Data Analyst to work closely with research PM to lead the research efforts required for the Strategy. Candidate will gather the high level requirements from the PM,...DataSenior
- ...Data profiling must be strong, Migration Data Analysis Domain- Transaction management and trade life cycle, fixed income, custody, 5-7 years financial experience Should go lower on business side and more on data side,...DataSenior
$41k
...Job Description Data Analyst: Key Responsibilities Data Documentation & Data Dictionary Develop and maintain a comprehensive... ...traceability between data sources, business documents, and reporting systems. Ensure proper documentation of data...DataSeniorFull timeFor contractors- ...NAVA Software solutions is looking for a Sr. MS Purview (Data Governance consultant) Details: Sr. MS Purview (Data Governance consultant) Location: 100% Remote : Must work in EST time zone Duration: 6-12 months Candidate will assist...DataSeniorRemote work
- ...Data Management And Governance Risk This role will be responsible for evaluating data management practices and governance frameworks to ensure alignment with industry practice and applicable regulatory expectations. This role involves conducting detailed assessments...DataSenior
- ...choose not to reply to this survey. It will be maintained in the company's personnel database solely for use in required government reporting, internal diversity reporting, and other legitimate business purposes. ","questions":[{"id":45201,"name":"How would you describe...DataSeniorH1bWork at officeRelocationWork visa
$47k - $165k
...Data Visualization Expert Advanced BA - Visualize data and be able to create dashboards and present it well Based on the data set, and the audience (senior management vs analysts), be able to determine the right representation from the library of charts (should...DataSeniorFull time- A health services organization in Pennsylvania is seeking a Data Analyst to collect and analyze data, generating meaningful reports to meet customer needs. The ideal candidate will have 5-10 years of relevant experience, particularly with end-user reporting tools, and a...DataSeniorWork at office
- Public Consulting Group is seeking a Sr Data and Reporting Analyst to support data integration and quality for the Oklahoma statewide project. The role, primarily remote with some travel, requires a strong background in data operations, analysis, and SQL skills. Candidates...DataSeniorRemote job
- ...About the job Sr. Data Analyst The Senior Data Analyst will process, analyze, interpret, and distribute statistical related data... ...Uses statistical methods to analyze data and generate useful reports Identifies and recommends new ways to streamline data processes...DataSeniorWork at office
- Vaco is searching for a Senior Reporting Associate/Analyst in New York, NY. This position manages Assets Under Management (AUM) reporting and collaborates with various stakeholders to ensure accurate data delivery. The ideal candidate will have experience in financial reporting...DataSeniorRemote work
- Hines is seeking a Senior Analyst in Sustainability Reporting to oversee ESG performance data analysis and reporting processes. The role involves coordinating with teams globally to support compliance and significant reporting deliverables. Ideal candidates will have a...DataSeniorWork at officeRemote work1 day per week
- ...insurance organization in New York is seeking a Senior Regulatory Reporting Analyst. The role focuses on collaborating with various functions to... ...regulatory reporting. Candidates should possess strong data analysis and advanced Excel skills, along with experience in...DataSenior
$138k - $181.65k
...THE POSITION Our roster has an opening with your name on it FanDuel is looking for a Senior Data Governance Analyst to drive data literacy across FanDuel. In addition to the specific responsibilities outlined above, employees may be required to perform other such...DataSeniorTemporary workLocal areaWorldwide- ...Contract / Full-time Job Overview We are seeking an experienced Data Analyst with strong expertise in Tableau and Excel to support business... ...and the ability to translate complex data into meaningful reports and visualizations. Key Responsibilities Develop and maintain...DataSeniorFull timeContract workRemote work
- ...Sr. Data Analyst Procom is a leading provider of professional IT services and staffing to businesses and governments in Canada. With... ...roll-out Provide custom datasets for analysis and ad hoc reporting Participate in control reporting and data governance development...DataSeniorPermanent employmentContract workFor contractorsH1b
- A leading insurance organization in New York is seeking a Senior Regulatory Reporting Analyst to ensure accurate and timely reporting of data to insurance regulatory bodies. The successful candidate will have strong data analysis and Excel skills, along with experience...DataSenior
- Senior Regulatory Reporting Analyst, Long Island City City, NY, Tampa or Charlotte, NC (Hybrid) Contract Duration: 8+ Months Required Skills... ...Will Be Doing Ensure Regulatory Capital and MCS Target Ratios data accuracy are consistent with legal entity’s financials,...DataSeniorContract work
$48k - $169k
...Job Description Responsibilities Analyze data requirements and identify disparate data sources required for consolidation... ...wholesale loans/lending business OR Capital Markets or Finance or Risk Reporting Strong hands on experience with database and SQL is required...DataSeniorFull timeShift work$95k - $115k
...work authorization). We are seeking a results-driven Senior Data Analyst to join our Merchandising, Planning, Allocation &... ...findings and strategic recommendations to leadership through reports and presentations Utilizing SQL, Power BI and other analytical...DataSeniorTemporary workH1bWork at officeFlexible hours- ...Description VAST Data is looking for a Sr. Data Analyst Sales to join our growing team! This is a great opportunity to be part of one of the... ...(RevOps) to develop analytical solutions that improve reporting systems, data quality, and processes. This role will drive...DataSenior
$95k - $115k
...with confidence. Job Description Summary: The Sr Data Analyst partners with stakeholders across P&C Operations (... ...Designs, develops, and maintains dashboards (Power BI), reports, and data products for use throughout P&C Operations using the...DataSeniorWork experience placementWork at officeLocal area$40 - $60 per hour
Data QA Analyst - 100% Remote (EST Hours) The client is looking for a Data QA Analyst to join the Data Partnership team at a large North Carolina healthcare system. To be successful, the candidate should be an expert in data profiling, root‑cause analysis, and creating...DataSeniorRemote jobHourly payContract workWork experience placement$100k - $115k
Sr. Data Analyst, Customer Reporting (Remote, U.S.) Join to apply for the Sr. Data Analyst, Customer Reporting (Remote, U.S.) role at PulsePoint . There's likely a reason you've taken the time out of your busy day to review this opportunity at PulsePoint. Maybe you're...DataSeniorRemote job$98.96k - $148.44k
Responsibilities Support the analysis and submission of reports to various constituencies (local regulators, SEC, Fed, OCC, etc.) based... ...development of process efficiencies and improvement efforts as well as data quality improvement projects Interpret policies, guidelines,...DataSeniorWork at officeLocal area$72.7k
Company: Job Description: Job Summary This job collects, validates, analyzes, and organizes data into meaningful computerized reports by manipulating and extracting data to meet customer needs, generates reports through mainframe and/or PC applications by utilizing established...DataSeniorWork at officeLocal area$90k - $130k
Gen II Fund Services is seeking a financial analyst to support investor relations and accounting for a mid-market private equity client. This role includes tasks such as quarterly data reporting for limited partners and assisting with fundraising requests. The ideal candidate...DataSenior$106k - $124k
...customers and communities. National Grid is hiring a Senior Analyst, Parent Financial Reporting & Analytics. This hybrid role is located in our Brooklyn,... ...reviewing discrepancies to produce accurate and credible data. Partners closely with jurisdiction business partners to...DataSeniorLocal areaFlexible hours- Sr. Product Analyst (Data Product / Business & Technical) Contract Duration: 6+ months Engagement Type: Contract | Hybrid Location: New York... ...products in a complex enterprise environment. This is not a reporting role. You will act as the bridge between business...DataSeniorHourly payContract workLocal area
$140k - $160k
COMPANY Canoe Intelligence TITLE Sr. Data Analyst, Private Markets LOCATION New York City (hybrid) or fully remote in the United States... ...documents. You will bridge the gap between Limited Partner (LP) reporting needs and machine learning, ensuring our models evolve to...DataSeniorWork at officeLocal areaRemote workWork from homeHome officeFlexible hours
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Sr Data and Reporting Analyst. Be the first to apply!
Related searches
- entry level data analyst no experience Brooklyn, NY
- data analyst Brooklyn, NY
- neuroscience data analyst Brooklyn, NY
- data protection analyst Brooklyn, NY
- entry level information security analyst Brooklyn, NY
- information security analyst Brooklyn, NY
- remote data analyst Brooklyn, NY
- data analyst supply chain analytics Brooklyn, NY
- senior data governance analyst Brooklyn, NY
- data analyst excel Brooklyn, NY

