Financial Management Data Engineer

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.