Financial Management Data Engineer

Guidehouse Inc.; McLean (VA); On-site; USD 113,000 - 188,000; Full time

Benefits offered by this job

Medical, Rx, Dental & Vision Insurance

401(k) Retirement Plan

Tuition Reimbursement

Mobility Stipend

Employee Referral Program

Job summary

Guidehouse Inc. is seeking a Financial Management Data Engineer to collect, transform, integrate, and analyze data in support of DHS Financial Management mission goals and decision-making.

This onsite role in McLean, VA focuses on building data ingestion and integration capabilities, applying analytics and predictive approaches, and maintaining data governance and quality for client deliverables. The role requires three+ years of data experience, proficiency in SQL, Python, R, and Databricks,

Qualifications

• Bachelor's degree in a relevant field.
• Three or more years of data experience.
• Experience with data analytics to address management and operational challenges.
• Proficiency with SQL, Python, R, and Databricks.
• Experience with predictive modelling and machine learning.

Responsibilities

• Access data sources by establishing connections and developing data ingestion and integration solutions using APIs, databases, file-based interfaces, and enterprise platforms to support data acquisition and pre-processing for analysis.
• Aggregate, clean, and organize datasets from disparate sources, including quality assurance of these processes.
• Design and implement data integration, mapping, and standardization frameworks with configurable business rules and data crosswalks to support interoperability, reconciliation, and reporting across financial and operational systems.
• Manipulate large data sets, perform data mining, and structure raw data using open-source tools such as SQL, Python, and PySpark to identify patterns that generate new information and insights for decision support.
• Develop data modeling processes and apply algorithms, predictive models, and ad hoc or exploratory data analysis, including advanced analytics techniques such as predictive modeling and machine learning.
• Ensure data governance and quality assurance standards are met.
• Help define data quality metrics tied to the quality of data ingested into Databricks.
• Organize and lead client meetings, including scheduling, drafting and delivering agendas and meeting minutes, archiving required documentation, and documenting, tracking, and following up on action items.
• Deliver client services and support business development, internal firm initiatives, and ongoing professional development.

Skills

Data analytics

SQL

Python

R

Databricks

Machine learning

Client communication

Education

Bachelor's degree

Tools

Power BI

Power Apps

Power Automate

SharePoint

Microsoft Azure

AWS

APIs

Job description

Guidehouse is seeking a Financial Management Data Engineer to collect, transform, integrate, and analyze data in support of DHS Financial Management mission goals and decision-making. This onsite role in McLean, VA focuses on building data ingestion and integration capabilities, applying analytics and predictive approaches, and maintaining data governance and quality for client deliverables.

Responsibilities

• Access data sources by establishing connections and developing data ingestion and integration solutions using APIs, databases, file-based interfaces, and enterprise platforms to support data acquisition and pre-processing for analysis.
• Aggregate, clean, and organize datasets from disparate sources, including quality assurance of these processes.
• Design and implement data integration, mapping, and standardization frameworks with configurable business rules and data crosswalks to support interoperability, reconciliation, and reporting across financial and operational systems.
• Manipulate large data sets, perform data mining, and structure raw data using open-source tools such as SQL, Python, and PySpark to identify patterns that generate new information and insights for decision support.
• Develop data modeling processes and apply algorithms, predictive models, and ad hoc or exploratory data analysis, including advanced analytics techniques such as predictive modeling and machine learning.
• Ensure data governance and quality assurance standards are met.
• Help define data quality metrics tied to the quality of data ingested into Databricks.
• Organize and lead client meetings, including scheduling, drafting and delivering agendas and meeting minutes, archiving required documentation, and documenting, tracking, and following up on action items.
• Deliver client services and support business development, internal firm initiatives, and ongoing professional development.

Requirements

• Ability to obtain and maintain a Federal or DoD “PUBLIC TRUST”; candidates with an ACTIVE PUBLIC TRUST or SUITABILITY are preferred.
• Bachelor's degree.
• Three (3) or more years of data experience.
• Experience performing data analytics to address management and operational challenges.
• Proficiency with data analytic tools including SQL, Python, R, and Databricks.
• Proficiency in Microsoft Suite, with emphasis on MS PowerPoint, MS Word, and MS Excel.
• Prior experience with statistical analysis, predictive modelling, machine learning, and artificial intelligence.

Technologies

• SQL, Python, PySpark, Databricks
• R
• Microsoft PowerPoint, Microsoft Word, Microsoft Excel, Power BI
• Power Apps, Power Automate, SharePoint, Microsoft Power Platform, Microsoft Suite
• MicrosoftAzure, AWS
• APIs, databases, file-based interfaces, enterprise platforms

Benefits

• Medical, Rx, Dental & Vision Insurance
• Personal and Family Sick Time & Company Paid Holidays
• Position may be eligible for a discretionary variable incentive bonus
• Parental Leave and Adoption Assistance
• 401(k) Retirement Plan
• Basic Life & Supplemental Life
• Health Savings Account, Dental/Vision & Dependent Care Flexible Spending Accounts
• Short-Term & Long-Term Disability
• Student Loan PayDown
• Tuition Reimbursement, Personal Development & Learning Opportunities
• Skills Development & Certifications
• Employee Referral Program
• Corporate Sponsored Events & Community Outreach
• Emergency Back‑Up Childcare Program
• Mobility Stipend

Additional Details

• Location: McLean, VA 22102 (onsite)
• Salary range: USD 113,000 - 188,000 per year
• Travel required: Up to 10%
• Clearance required: Ability to Obtain Public Trust

What Would Be Nice to Have

• Experience collaborating in a team environment and working independently.
• Ability to identify and address client needs, build relationships, prioritize tasks, and communicate potential conflicts to a supervisor.
• Professional communication skills across audiences, including management levels and external clients.
• Experience facilitating meetings and presenting topics to diverse functional and technical staff.
• Experience in commercial or public sector consulting firms.
• Prior experience supporting federal finance organizations.
• Experience with cloud-based platforms and services, including MicrosoftAzure, AWS, or similar cloud environments.
• Experience with Microsoft Power Platform tools (Power BI, Power Apps, Power Automate) and SharePoint.

WHAT WOULD BE NICE TO HAVE

Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package aligned with creating a diverse and supportive workplace.