Impress employers and recruiters.
Choose from hundreds of resume examples.
Impress employers and recruiters.
Choose from hundreds of resume examples.
Tailor your resume to this Data Analyst & Reporting Specialist role.
Rezi rewrites your resume against Guidacent's job description. Free.
Tailor your resume to this Data Analyst & Reporting Specialist role.
Rezi rewrites your resume against Guidacent's job description. Free.
Don't guess if your resume is good enough.
See how it scores against the Data Analyst & Reporting Specialist posting at Guidacent — free, in seconds.
Don't guess if your resume is good enough.
See how it scores against the Data Analyst & Reporting Specialist posting at Guidacent — free, in seconds.
About the Role
Guidacent is seeking a Data Analyst & Reporting Specialist to support a public sector client's Cost of Service Study. This role involves leading data collection, validation, reconciliation, workbook development, and reporting across various cost categories. The specialist will collaborate with consultants to organize data, support cost model development, identify data gaps, document assumptions, and ensure analysis traceability. This position is critical for developing structured workbooks, supporting cost allocation analysis, and preparing reporting outputs for executive findings and recommendations.
Responsibilities
- Support the development and maintenance of the Cost Data Collection Workbook.
- Gather, organize, and structure financial, HR/payroll, contract, licensing, procurement, infrastructure, and operational data.
- Collect data for labor, vendor, consulting, licensing, maintenance, software, hardware, cloud infrastructure, miscellaneous, and overhead cost categories.
- Maintain clear documentation of data sources, assumptions, definitions, and limitations.
- Validate completeness, accuracy, and consistency of source data.
- Identify data gaps, inconsistencies, and limitations.
- Support reconciliation of cost data to agency financial records and document unreconciled variances.
- Assist in validating allocation assumptions, cost drivers, units of measure, and service-level data inputs.
- Support development of service-level cost models.
- Assist with analysis of direct, indirect, shared, and overhead costs.
- Support rate comparison analysis by organizing current rate, revenue, cost, surplus, shortfall, and variance data.
- Help prepare supporting analysis for cost drivers, variance explanations, cost recovery gaps, and rate adequacy findings.
- Develop and maintain Excel-based analytical workbooks with formulas, documentation, and traceability.
- Prepare tables, charts, summaries, and supporting exhibits for various reports.
- Support creation of reporting materials for agency leadership presentations.
- Ensure work products are organized, editable, agency-accessible, and suitable for review.
- Work directly with the Principal Consultant to support day-to-day analysis, data requests, model updates, and reporting needs.
- Coordinate with the Government Cost Allocation SME to ensure data inputs support approved allocation methodologies.
- Support the Project Manager by providing status updates on data collection progress, data gaps, and analytical workstream risks.
- Maintain organized files, version control, assumption logs, and supporting documentation.
Requirements
- Bachelor's degree in Finance, Accounting, Business Analytics, Economics, Data Analytics, Information Systems, Public Administration, or a related field.
- Three to seven years of experience in financial analysis, data analysis, reporting, business intelligence, accounting support, or consulting analytics.
- Strong experience working with financial, operational, staffing, vendor, contract, or budget data.
- Advanced Microsoft Excel skills, including formulas, pivot tables, structured workbooks, lookups, data validation, and model support.
- Experience collecting, cleaning, validating, reconciling, and documenting complex datasets.
- Ability to translate raw data into clear analytical outputs, tables, summaries, and reporting exhibits.
- Strong attention to detail and ability to maintain traceability between source data, assumptions, analysis, and final deliverables.
- Strong written and verbal communication skills.
Skills
- Microsoft Excel
- Data Collection
- Data Validation
- Data Reconciliation
- Reporting
- Financial Analysis
- Cost Allocation
- Rate Analysis
- Budgeting
- Financial Forecasting
- Power BI
- Tableau
- SQL
- Access
- Business Intelligence
- Data Management
Location
- Public Sector Client Location
Work Type
- Full-time
Experience Level
- 3-7 years
Education Level
- Bachelor's degree
About the Company
- Guidacent supports public sector clients.