We are looking for a Data and Reporting Specialist to join a government organization in Worcester, Massachusetts in a Contract position. This in-person opportunity is well suited for an early-career candidate who enjoys working with data, building reports, and supporting teams with clear, accurate insights. The role focuses on maintaining reliable information, preparing recurring and ad hoc reporting, and contributing to data visibility for operational and program-related decisions.
Responsibilities:
- Partner with department staff to clarify reporting requests and translate business needs into practical data outputs.
- Prepare and refine reports, scorecards, and dashboards using Excel and Power BI to support day-to-day operations and decision-making.
- Gather information from spreadsheets, databases, and internal platforms, then input and organize it for consistent use across reporting activities.
- Review datasets for completeness and accuracy by correcting errors, standardizing formats, and maintaining dependable records.
- Produce scheduled and one-time analyses that highlight trends, exceptions, and performance patterns for various teams.
- Assist with maintaining reporting databases and support improvements that make recurring reporting more efficient and repeatable.
- Record reporting methods, source definitions, and workflow steps to strengthen consistency, auditability, and knowledge sharing.
- Work with housing and finance teams to analyze Section 8 program data, reconcile reporting with financial records, and resolve discrepancies.
- Create KPI dashboards that track measures such as voucher usage, lease-up progress, budget performance, and funding utilization.
- Contribute to compliance-related reporting by helping verify data quality and preparing information required by oversight or regulatory bodies.
- At least 2 years of experience in data analysis, reporting, or a closely related analytical role.
- Proficiency with Microsoft Excel, including advanced functions used for reporting and data management.
- Hands-on experience creating reports or dashboards in Microsoft Power BI.
- Understanding of core data concepts such as data models, database structure, warehousing, mining, and segmentation.
- Strong analytical ability with careful attention to detail, accuracy, and data integrity.
- Ability to write queries, prepare reports, and communicate findings clearly to a range of stakeholders.
- Effective interpersonal and customer service skills with the ability to collaborate across departments.
- Bachelor’s degree in business, management, or a related field is preferred.