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.

Responsibilities

• Access data sources by establishing data connections and building data ingestion and integration solutions using APIs, databases, file-based interfaces, and enterprise platforms to support data acquisition and pre-processing
• Aggregate, clean, and organize datasets from disparate sources; perform data quality assurance for these activities
• 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
• Work with large datasets using SQL, Python, and PySpark to mine and structure raw data, identify patterns, and generate new information and insights
• Build data modeling processes, algorithms, and predictive models; conduct ad hoc and exploratory analysis to support data-driven decisions using advanced analytics, including machine learning
• Ensure data governance and 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, managing required documentation, and tracking action items through follow-up
• 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; candidates with an ACTIVE PUBLIC TRUST or SUITABILITY are preferred
• Bachelor’s degree
• 3+ years of data experience
• Experience performing data analytics to address management and operational challenges
• Proficiency with data tools including SQL, Python, R, and Databricks
• Proficiency with the Microsoft Suite, with an emphasis on 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

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: Up to 10%
• Clearance: 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, and communicate potential conflicts to a supervisor
• Effective communication with various audiences, including management and external clients
• Ability to facilitate meetings and present 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 environments
• Experience with Microsoft Power Platform (Power BI, Power Apps, Power Automate) and SharePoint

Compensation and Location

• Location: McLean, VA 22102 (onsite)
• Salary Range: $113,000 - $188,000 per year

Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package.