Senior Financial Management Data Engineer

Join Guidehouse Inc. as a Senior Financial Management Data Engineer supporting financial management and IT programs for the Department of Homeland Security (DHS). This onsite role in Washington, DC combines data engineering, governance, and analytics to help improve decision-making across financial and operational systems. In addition to impactful work, you will have access to a comprehensive benefits package and professional development support.

Salary: USD 113,000 to 188,000 per year. Travel: None.

What you will do

• Access data sources, establish data connections, and develop ingestion and integration solutions using APIs, databases, file-based interfaces, and enterprise platforms.
• Aggregate, clean, and organize datasets from disparate sources, and perform quality assurance on those processes.
• Design and implement data integration, mapping, and standardization frameworks, including configurable business rules and data crosswalks for interoperability, reconciliation, and reporting.
• Manipulate large datasets and perform data mining and structuring using open-source tools such as SQL, Python, and PySpark to identify patterns and generate new insights.
• Build data modeling processes, create algorithms and predictive models, and conduct ad hoc or exploratory analysis, including advanced analytics, predictive modeling, and machine learning.
• Maintain data governance and ensure data quality assurance standards are met.
• Help define 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 documentation, and tracking and following up on action items.
• Deliver client services and also support business development, internal initiatives, and ongoing professional development.

Required qualifications

• Ability to OBTAIN and MAINTAIN a Federal or DoD “PUBLIC TRUST”; candidates must obtain approved adjudication prior to onboarding. Active Public Trust or Suitability is 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 analytics 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 modeling, machine learning, and artificial intelligence

Technologies you may work with

• 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 and support

• 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

Nice to have

• Experience collaborating in a team environment and working independently
• Ability to identify and address client needs, build relationships, prioritize work, and communicate potential conflicts
• Professional communication across technical and management audiences, including external clients
• Experience facilitating meetings and presenting 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