Financial Data Analyst

Company: Heartland ConsultingEmployment Type: Full-Time / Anticipated Future OpportunitiesLocation: Remote, Hybrid, or On-Site depending on contract requirementsPosition SummaryHeartland Consulting is seeking Financial Data Analysts for anticipated federal contract opportunities involving budget execution, financial analysis, reporting, reconciliation, data visualization, and process automation.Ideal candidates will combine hands-on financial or budget analysis experience with strong technical skills in Excel, Power BI, Power Query, financial systems, and workflow automation.Key ResponsibilitiesAnalyze financial, budget, and operational data to support management decision-making.Track obligations, commitments, expenditures, execution rates, and other financial metrics.Develop and maintain Status of Funds, variance, reconciliation, and financial tracking reports.Reconcile transactions and identify discrepancies across financial systems and data sources.Develop dashboards and reporting solutions to provide visibility into budget execution and financial performance.Automate recurring financial reports, notifications, approvals, and data collection processes.Develop financial models and recurring reporting tools using Excel and Power Query.Support financial data validation and reconciliation activities.Document financial processes, automated workflows, and reporting procedures.Support audit readiness and internal control activities.Work with budget officers, resource managers, program managers, and other stakeholders.Desired Software & Systems ExperienceCandidates should have hands-on experience with financial analysis tools and one or more federal or DoD financial systems.Primary ToolsMicrosoft Excel – advanced formulas, financial analysis, and reconciliationPower Query – data cleanup, transformation, and recurring reportingMicrosoft Power BI – financial dashboards and reportingMicrosoft Power Automate – workflow and reporting automationFederal / DoD Financial SystemsExperience with one or more of the following is highly desirable:DEAMSGFEBSDTSCheckbookPegasysExperience with SQL or Tableau is a plus.Preferred QualificationsExperience with federal or DoD financial management, budget execution, resource management, or financial analysis.Experience using financial systems of record and reconciling information across multiple systems.Advanced Microsoft Excel skills.Experience developing Power BI dashboards and financial reports.Experience automating financial or administrative processes.Strong analytical, organizational, and communication skills.Bachelor's degree in finance, accounting, business, data analytics, or a related field preferred.BenefitsHeartland Consulting offers a competitive benefits package for eligible employees, which may include:Medical, dental, and vision insuranceRetirement savings optionsProfessional development and training opportunitiesCareer growth opportunities across federal and commercial programsSpecific benefits and eligibility may vary based on position, employment status, and contract requirements.Equal Employment OpportunityHeartland Consulting is an Equal Opportunity Employer. Employment decisions are made without regard to race, color, religion, sex, national origin, age, disability, genetic information, protected veteran status, or any other characteristic protected by applicable federal, state, or local law.