Financial Management Data Analyst

Guidehouse•Arlington, VA

About The Position

Guidehouse is seeking a Data Analyst to support financial management and information technology programs. The role transforms complex business and financial data into insights that support mission execution, operational effectiveness, and strategic decision-making. The analyst works with financial, operational, and technical stakeholders to improve enterprise data accessibility, usability, and value, contributing to more efficient reporting, better performance visibility, and informed management decisions within financial management functions. The work takes place in dynamic, fast-paced client environments and calls for adaptability, initiative, critical thinking, and collaboration across financial management and technology teams. The role also supports client services, business development, internal firm initiatives, and ongoing professional development.

Requirements

Ability to obtain and maintain a Federal or DoD Public Trust; approved Public Trust adjudication is required before onboarding.
Bachelor's degree.
At least five years of consulting or financial services industry experience supporting data analytics, data engineering, business intelligence, financial management modernization, or reporting initiatives.
Experience assessing business processes, identifying opportunities to improve data, reporting, and analytics capabilities, and recommending solutions.
Experience architecting and developing reporting, visualization, and analytic solutions to improve client efficiency, capabilities, and performance.
Experience querying and manipulating data using SQL and/or Python.
Experience establishing integrations and data pipelines between interfacing data sources and systems.
Experience developing dashboards, reports, or visualizations using Power BI or similar business intelligence tools.
Experience developing, refining, and presenting training materials to support end-user adoption.
Understanding of data quality, data governance, and data management principles in the federal compliance landscape.
Experience integrating, cleaning, and validating datasets from multiple sources.
Proficiency with Microsoft Excel and the broader Microsoft Office Suite.

Nice To Haves

Active Public Trust or suitability.
Experience supporting federal financial management, budgeting, accounting, audit, or CFO organizations.
Familiarity with federal financial management concepts, financial data, KPIs, budget execution reporting, and management reporting processes.
Experience building machine-learning predictive models and analytics solutions to forecast budget, obligation, contract, and risk-based financial outcomes.
Experience with federal ERP systems such as Oracle Financials, OneStream, or Concur.
Experience working in or supporting clients in federal housing or mortgage markets.
Experience developing automated reporting or data transformation workflows.
Exposure to cloud analytics environments such as Databricks.
Experience in consulting, government, or professional services.
Experience with Agile delivery methodologies and project teams.
Power BI or similar analytics certification.
Experience creating executive-level dashboards and visualizations communicating financial performance, resource utilization, operational metrics, or organizational priorities.
Experience with Databricks or comparable cloud-based data platforms to transform, manage, or analyze data.

Responsibilities

Access financial data sources, establish data connections, and preprocess data for analysis.
Aggregate, clean, and organize datasets from disparate sources, and perform quality assurance.
Manipulate large financial datasets, mine data, and structure raw financial and operational data using tools such as SQL and Python to identify patterns and generate insights for financial decision-making, performance reporting, and resource allocation.
Design financial data modeling processes and conduct ad hoc and exploratory analysis to support data-driven decisions about financial performance and budget execution.
Develop dashboards and reports that communicate data-based insights, trends, and metrics clearly and concisely to executives.
Ensure financial data governance, integrity, and quality assurance standards are met in support of reliable reporting and federal compliance requirements.
Organize and lead client meetings, including scheduling, preparing and delivering agendas and minutes, providing and archiving documentation, and tracking and following up on action items.
Support technical upskilling of Federal staff by developing and presenting training materials, desk guides, and similar resources so staff can operate solutions independently.
Deliver client services while supporting business development, internal firm initiatives, and ongoing professional development.