Financial Management Data Analyst

Guidehouse•Arlington, VA

About The Position

Guidehouse is seeking a Data Analyst to support financial management and information technology programs within the Department of Homeland Security. The role is part of the Defense and Security Segment and focuses on transforming complex business and financial data into insights that support mission execution, operational effectiveness, and strategic decision-making. The analyst will work with financial, operational, and technical stakeholders to improve enterprise data accessibility, usability, and value, and to support more efficient reporting, performance visibility, and informed management decisions. The work is dynamic and takes place in fast-paced client environments. Team members are expected to adapt, think critically, take initiative, and collaborate across financial management and technology teams while developing data-driven solutions. The position also includes client service delivery, business development support, participation in internal firm initiatives, and ongoing professional development.

Requirements

Ability to obtain and maintain a Federal or DoD Public Trust; approved adjudication must be obtained before onboarding.
Bachelor's degree in Data Analytics, Data Science, Computer Science, Information Systems, Engineering, Statistics, Finance, Mathematics, Economics, or a related quantitative field.
One or more years of experience supporting data analytics, data engineering, business intelligence, financial management modernization, or reporting initiatives.
Experience querying and manipulating data using SQL.
Experience developing scripts and performing data analysis using Python or a comparable analytics programming language.
Experience using Databricks or comparable cloud-based data platforms to transform, manage, or analyze data.
Experience developing dashboards, reports, or visualizations using Tableau, Power BI, or similar business intelligence tools; preferably supporting budget execution monitoring or executive reporting.
Understanding of data quality, data governance, and data management principles within the federal compliance landscape.
Experience integrating, cleaning, and validating datasets from multiple sources.
Proficiency with Microsoft Excel and the broader Microsoft Office Suite.
Strong analytical, problem-solving, and critical-thinking skills.
Strong written and verbal communication skills, including the ability to explain technical concepts to non-technical audiences.
Ability to work independently and collaborate effectively in a multidisciplinary team environment.

Nice To Haves

Active Public Trust or suitability.
Experience supporting federal financial management, budgeting, accounting, audit, or CFO organizations, preferably within DHS.
Familiarity with federal financial management concepts, financial data, key performance indicators, budget execution reporting, and management reporting processes.
Experience developing automated reporting or data transformation workflows.
Exposure to cloud analytics environments such as Databricks.
Experience in a consulting, government, or professional services environment.
Experience with Agile delivery methodologies and project teams.
Tableau Desktop certification or similar analytics certifications.
Experience creating executive-level dashboards and data visualizations that communicate financial performance, resource utilization, operational metrics, or organizational priorities.

Responsibilities

Access financial data sources, establish data connections, and preprocess data for analysis.
Aggregate, clean, organize, and quality-check datasets from disparate sources.
Manipulate large financial datasets, perform data mining, 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 or exploratory data analysis to support decisions about financial performance and budget execution.
Ensure financial data governance, integrity, and quality assurance standards are met to support reliable reporting and federal compliance requirements.
Help define data quality metrics for data ingested into Databricks to support accuracy and consistency across reporting environments.
Organize and lead client meetings, including scheduling meetings, preparing and delivering agendas and minutes, providing and archiving documentation, and tracking and following up on action items.
Deliver client services while supporting business development, internal firm initiatives, and ongoing professional development.