Senior Financial Management Data Engineer

Guidehouse Inc. is seeking a Senior Financial Management Data Engineer to support data collection, transformation, and analysis for financial management and IT programs within the Department of Homeland Security (DHS). This onsite role in Washington, DC focuses on building reliable data ingestion and integration solutions, strengthening data quality and governance, and enabling decision-making through analytics and client service delivery.

What you’ll do

• Access data sources, establish data connections, and build data ingestion and integration solutions using APIs, databases, file-based interfaces, and enterprise platforms to support acquisition and pre-processing for analysis.
• Aggregate, clean, and organize datasets from multiple sources, and perform quality assurance on these workflows.
• Design and implement data integration, mapping, and standardization frameworks, including configurable business rules and data crosswalks, to support interoperability, reconciliation, and reporting across financial and operational systems.
• Work with large datasets, conduct data mining, and structure raw data using SQL, Python, and PySpark to find patterns and generate new information that supports organizational decision making.
• Develop data modeling processes, create algorithms and predictive models, and perform ad hoc and exploratory analysis, including advanced analytics techniques such as predictive modeling and machine learning.
• Ensure data governance and quality assurance standards are met, including defining data quality metrics for 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 while supporting business development, internal firm initiatives, and ongoing professional development.

Qualifications

• Ability to OBTAIN and MAINTAIN a Federal or DoD “PUBLIC TRUST”; candidates must obtain approved adjudication of their PUBLIC TRUST prior to onboarding with Guidehouse. 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 in data analytic tools including SQL, Python, R, and Databricks.
• Proficiency with the Microsoft Suite, especially MS PowerPoint, MS Word, and MS Excel.
• Prior experience with statistical analysis, predictive modeling, machine learning, and artificial intelligence.

Technology stack

• SQL, Python, R, PySpark, Databricks
• Microsoft PowerPoint, Microsoft Word, Microsoft Excel
• APIs, databases
• Microsoft Azure, AWS
• Power BI, Power Apps, Power Automate, SharePoint
• Microsoft Power Platform

Location and schedule

• Location: Washington, DC (onsite)
• Travel required: None
• Clearance required: Ability to Obtain Public Trust

Compensation and benefits

Annual salary range: USD 113,000 to 188,000 (yearly).

• 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

Job family

• Data Science Consulting

What would be nice to have

• Experience collaborating in a team environment and working independently when needed.
• Ability to identify and address client needs, build relationships, prioritize tasks, and communicate potential conflicts to a supervisor.
• Effective communication with various audiences, including different management levels and external clients.
• Experience facilitating meetings and presenting topics to diverse functional and technical staff.
• Experience supporting commercial or public sector consulting firms.
• Experience supporting federal finance organizations.
• Experience with cloud-based platforms and services such as Microsoft Azure or AWS.
• Experience with Microsoft Power Platform (Power BI, Power Apps, Power Automate) and SharePoint.