Public-Trust Financial Data Analyst

Guidehouse; Arlington (VA); On-site; USD 74,000 - 124,000; Full time

Benefits offered by this job

Medical, Rx, Dental & Vision Insurance

Paid Holidays

401(k) Retirement Plan

Professional development & learning

Job summary

Guidehouse is seeking a Data Analyst to join our Defense and Security segment, supporting the Department of Homeland Security. You will transform complex financial and operational data into actionable insights to improve reporting, decision-making, and resource allocation.

You will work with financial, operational, and technical stakeholders to ensure data quality, governance, and regulatory compliance, while contributing to business development and project delivery in fast-paced client

Qualifications

• Bachelor's degree in data analytics, data science, CS, IS, eng, stats, finance, math or related field; 1+ years in data analytics or reporting.
• Experience querying/manipulating data with SQL.
• Experience scripting and data analysis with Python or similar.
• Experience with Databricks or cloud data platforms to transform/manage data.
• Experience building dashboards/reports with Tableau or Power BI.
• Understanding of data quality, governance and federal compliance.
• Experience integrating and validating data from multiple sources.
• Proficiency with Excel and MS Office.

Responsibilities

• Access data sources, establish connections, and pre-process data for analysis.
• Aggregate, clean and organize datasets; QA data quality.
• Analyze large financial data sets using SQL/Python to generate insights for decisions.
• Design data models and perform ad hoc analyses to support budgeting and performance reporting.
• Ensure data governance and integrity for reliable federal reporting.
• Collaborate with stakeholders; lead meetings and document action items.
• Support BD efforts and internal initiatives while delivering client services.

Skills

SQL

Python

Databricks

BI dashboards

Excel

Data governance

Analytical skills

Communication

Education

Bachelor's degree in a quantitative field

Tools

Databricks

Power BI

Tableau

Job description

Guidehouse is seeking a Data Analyst to join our Defense and Security segment, supporting the Department of Homeland Security. You will transform complex financial and operational data into actionable insights to improve reporting, decision-making, and resource allocation.

You will work with financial, operational, and technical stakeholders to ensure data quality, governance, and regulatory compliance, while contributing to business development and project delivery in fast-paced client