At i360technologies, we deliver business consulting and technology solutions that support the mission of federal agencies. We are seeking a Financial Data & Reporting Analyst to transform financial and workload data into reliable billing inputs, recurring reports, and decision-ready analysis for a federal shared services program. The right candidate brings advanced SQL and Excel, FASS cost analysis experience, and a disciplined approach to data quality.
Position Summary
Transform and reconcile financial and operational data into reliable customer billing inputs, recurring reports, dashboards, and decision-ready analyses.
PWS criteria coverage: Primary: FASS data analysis and the Mid-Level core skills (advanced SQL, Power BI or Tableau, financial data modeling, QA validation). Supporting: ABC modeling, SOPs and technical writing. The resume must state this role and the PWS criteria the candidate covers.
Key Responsibilities
- Gather, extract, clean, transform, and reconcile financial and workload data from Government-approved systems and files for Customer Billing Model (CBM)/ Cost Management Module (CMM) reporting.
- Build and maintain repeatable data extracts, advanced Excel workbooks, financial reports, dashboards, and quality checks.
- Prepare monthly customer activity reports, support monthly model calculations, and validate data for Customer Price Volume Index (CPVI), Financial and Accounting Shared Services (FASS) reassessments, and fiscal-year-end reporting.
- Analyze unusual balances, data gaps, mismatches, and trends; document findings and coordinate corrections with data owners.
- Maintain data definitions, reporting logic, version control, support documentation, and auditable links from source records to published outputs.
- Explain analyses and support the Team Lead and financial modeling lead in addressing reporting and customer questions.
Required Qualifications
- Bachelor's degree in accounting, finance, business administration, information management, IT, computer science, data analytics, or related field.
- Three to six years of experience in financial reporting, SQL development, data analytics, or audit support.
- Demonstrated experience in performing data analyses of Financial and Accounting Shared Services (FASS) costs, including data extraction, transformation, and reporting using advanced Excel functions, data visualization tools, and other relevant data analysis platforms.
- Advanced SQL and Excel; experience with Power BI or Tableau, financial data modeling, and data quality/QA validation.
- Ability to perform data extraction, transformation, reconciliation, and produce accurate repeatable reporting.
- Clear written communication and experience documenting data definitions and reporting procedures.
Preferred Qualifications
- Federal financial systems, shared services cost reporting, or audit-ready reporting.
- Experience with customer billing or cost allocation data.
- Master's in accounting, finance, data science, or a related field.
- Demonstrated experience in activity-based cost (ABC) modeling and cost model development.
- Writing/technical writing experience crafting user guides and technical requirement materials, writing Standard Operating Procedures (SOPs), and documenting business processes and workflows
Security & Eligibility Requirements
- Must be able to pass a federal background investigation to obtain and maintain a federal Public Trust (suitability) clearance
- U.S. Citizenship required (no visa sponsorship available)
Benefits
- Referral Bonus
- (401k) Matching
- Holidays – Eleven
- Technology Reimbursement
- Short-Term & Long-Term Disability
- Life Insurance (Basic, Voluntary & AD&D)
- Paid Time Off (0-3 years - 15 Days PTO | 3+ years 20 Days)
- 80% Employer Paid Health Care Plan (Medical, Dental & Vision)
Equal Opportunity Employer Minority/Female/Veteran/Disability
All qualified applicants will receive consideration for employment regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or status within any other protected group.
Only direct applicants will be considered. Submissions from recruiting or staffing firms will not be accepted.