Financial Management Data Engineer

Guidehouse is seeking a Financial Management Data Engineer to build data ingestion, integration, and analytics capabilities that support DHS financial management mission goals and decision-making.

Responsibilities

• Access data sources and establish data connections
• Develop data ingestion and integration solutions using APIs, databases, file-based interfaces, and enterprise platforms for data acquisition and pre-processing
• Aggregate, clean, and organize datasets from disparate sources
• Perform quality assurance on data preparation activities
• Design and implement data integration, mapping, and standardization frameworks
• Create configurable business rules and data crosswalks to support interoperability, reconciliation, and reporting across financial and operational systems
• Work with large datasets for data mining and structuring of raw data
• Use open-source tooling such as SQL, Python, and PySpark to identify patterns and generate new information
• Design data modeling processes and build algorithms and predictive models
• Conduct ad hoc and exploratory data analysis to support data-driven decision-making
• Apply advanced analytics techniques including predictive modeling and machine learning
• Ensure compliance with data governance and quality assurance standards
• Define data quality metrics associated with the quality of data ingested into Databricks
• Organize and lead client meetings, including scheduling, drafting/delivering agendas and meeting minutes, and archiving documentation
• Document, track, and follow up on action items from client engagements
• Deliver client services while supporting business development, internal firm initiatives, and ongoing professional development

Requirements

• Ability to OBTAIN and MAINTAIN a Federal or DoD “PUBLIC TRUST” (ACTIVE PUBLIC TRUST or SUITABILITY preferred)
• Bachelor’s degree
• 3+ 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 with Microsoft Suite, especially PowerPoint, Word, and Excel
• Prior experience with statistical analysis, predictive modeling, machine learning, and artificial intelligence

Technologies

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

Travel Required

• Up to 10%

Clearance Required

• Ability to Obtain Public Trust

Salary

• USD 113,000 - 188,000 per year

Benefits

• Medical, Rx, Dental & Vision Insurance
• Personal and Family Sick Time & Company Paid Holidays
• Potential 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

What Would Be Nice to Have

• Collaborate in a team environment and work independently
• Identify and address client needs, build client relationships, and manage priorities
• Communicate potential conflicts to a supervisor
• Communicate professionally with various audiences, including management and external clients
• Facilitate meetings and present topics to technical and functional staff
• Experience in commercial or public sector consulting firms
• Prior experience supporting federal finance organizations
• Experience with cloud-based platforms and services, including MicrosoftAzure or AWS
• Experience with Microsoft Power Platform (Power BI, Power Apps, Power Automate) and SharePoint