Financial Data Analyst: Power BI Dashboards & Reporting

Heartland Consulting; United States Virgin Islands; Hybrid; USD 75,000 - 110,000; Full time

Benefits offered by this job

Medical, dental, and vision insurance

Retirement savings options

Professional development and training

Career growth opportunities across Fed

Job summary

Heartland Consulting seeks Financial Data Analysts for anticipated federal contract opportunities involving budget analysis, reporting, and data visualization. The role emphasizes hands‑on financial analysis with strong Excel, Power BI, and workflow automation skills.

Ideal candidates will have experience with federal or DoD finance systems and the ability to develop automated reporting tools and dashboards for budget execution and financial performance.

Qualifications

• Hands-on financial or budget analysis experience required.
• Experience with federal or DoD financial systems is highly desirable.
• Advanced Microsoft Excel skills.
• Experience developing Power BI dashboards and financial reports.
• Experience automating financial or administrative processes.
• Strong analytical, organizational, and communication skills.

Responsibilities

• Analyze 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.

Skills

Financial analysis

Budget execution

Data visualization

Workflow automation

Education

Bachelor's degree in finance, accounting, business, data analytics, or related field

Tools

Excel

Power Query

Power BI

Power Automate

SQL

Job description

Heartland Consulting seeks Financial Data Analysts for anticipated federal contract opportunities involving budget analysis, reporting, and data visualization. The role emphasizes hands‑on financial analysis with strong Excel, Power BI, and workflow automation skills.

Ideal candidates will have experience with federal or DoD finance systems and the ability to develop automated reporting tools and dashboards for budget execution and financial performance.