Senior Financial Management Data Engineer

The Senior Financial Management Data Engineer will support data collection, transformation, integration, and analysis for financial management and IT programs within the Department of Homeland Security (DHS). The role focuses on building ingestion and integration solutions, maintaining data governance and quality, and enabling decision support through analytics and client service delivery.

Location

• Washington, DC (onsite)

Compensation

• USD 113,000 - 188,000 per yearly

Key Responsibilities

• Access data sources, establish data connections, and develop 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, and perform quality assurance for these processes.
• 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.
• Manipulate large datasets and perform data mining and structuring of raw data using open source tools such as SQL, Python, and PySpark to identify patterns and generate new information that supports organizational decision-making.
• Develop data modeling processes, create algorithms and predictive models, and conduct ad hoc or exploratory analysis to support data-driven decision-making, including advanced analytics techniques such as predictive modeling and machine learning.
• Ensure data governance and quality assurance standards are met.
• Define data quality metrics related to the quality of data ingested into Databricks.
• Organize and lead client meetings, including scheduling; drafting and delivering agendas and meeting minutes; providing and archiving required documentation; and documenting, tracking, and following up on action items.
• Deliver client services while also supporting business development, internal firm initiatives, and ongoing professional development.

Requirements

• 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. Active PUBLIC TRUST or suitability is preferred.
• Bachelor's degree
• 3 or more years of data experience
• Experience performing data analytics to address management and operational challenges
• Proficiency in data analytic tools such as SQL, Python, R, and Databricks
• Proficiency in the Microsoft Suite, especially MS PowerPoint, MS Word, and MS Excel
• Prior experience with statistical analysis, predictive modeling, machine learning, and artificial intelligence

Technologies

• 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

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

Travel and Clearance

• Travel required: None
• Clearance required: Ability to Obtain Public Trust

Job Family

• Data Science Consulting

Nice to Have

• Collaborating in a team environment and working independently when needed.
• Identifying and addressing client needs, building relationships with clients, and demonstrating flexibility in prioritizing and completing tasks, including communicating potential conflicts to a supervisor.
• Communicating effectively to various audiences, including different levels of management and external clients, in a professional environment.
• Facilitating meetings and presenting topics to diverse groups of 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 Microsoft Azure, AWS, or similar environments.
• Experience with Microsoft Power Platform (Power BI, Power Apps, Power Automate) and SharePoint.