Financial Management Data Analyst

Guidehouse•McLean, VA

3d•$74,000 - $124,000

About The Position

Guidehouse is seeking a Data Analyst to join its Defense and Security Segment in support of financial management and information technology programs within the Department of Homeland Security. 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, supporting more efficient reporting, stronger performance visibility, and informed management decisions. The position supports financial management transformation by helping modernize business processes, enhance organizational performance, strengthen transparency and accountability, and support compliance with federal laws, regulations, and reporting requirements. Projects are dynamic and take place in fast-paced client environments; team members are expected to adapt, think critically, take initiative, and collaborate across financial management and technology teams. The role also involves client service, business development support, internal firm initiatives, and ongoing professional development. Travel is required up to 10%.

Requirements

Must be able to obtain and maintain a Federal or DoD Public Trust; approved Public Trust adjudication is required before onboarding.
Bachelor's degree in Data Analytics, Data Science, Computer Science, Information Systems, Engineering, Statistics, Finance, Mathematics, Economics, or a related quantitative field.
At least one year 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 working with 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 working with Agile delivery methodologies and project teams.
Tableau Desktop certification or similar analytics certifications.
Experience creating executive-level dashboards and data visualizations communicating financial performance, resource utilization, operational metrics, or organizational priorities.

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, conduct 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 perform ad hoc and exploratory data analysis to support decisions related to 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 ensure accuracy and consistency across reporting environments.
Organize and lead client meetings, including scheduling, preparing and delivering agendas and meeting minutes, providing and archiving documentation, and documenting, tracking, and following up on action items.
Deliver client services while supporting business development, internal firm initiatives, and ongoing professional development.