Senior Financial Management Data Engineer

Senior Financial Management Data Engineer to support DHS financial management and IT programs through data ingestion, integration, governance, and analytics.

Responsibilities

• 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; perform quality assurance on data preparation
• Design and implement data integration, mapping, and standardization frameworks using configurable business rules and data crosswalks for interoperability and reconciliation
• Manipulate large datasets and structure raw data; perform data mining and pattern discovery using SQL, Python, and PySpark to generate insights for decision-making
• Build data modeling processes, algorithms, and predictive models; perform ad hoc and exploratory data analysis, including advanced analytics such as predictive modeling and machine learning
• Support data governance and data quality assurance standards
• Help define data quality metrics tied to data ingested into Databricks
• Organize and lead client meetings, including scheduling, drafting agendas and meeting minutes, archiving documentation, and tracking action items to completion
• Deliver client services and support business development, internal firm initiatives, and ongoing professional development

Requirements

• Obtain and maintain a Federal or DoD PUBLIC TRUST; candidates must obtain approved adjudication of their PUBLIC TRUST prior to onboarding with Guidehouse
• Preferred: candidates with an ACTIVE PUBLIC TRUST or SUITABILITY
• Bachelor’s degree
• 3+ years of data experience
• Experience performing data analytics to address management and operational challenges
• Proficiency in data analytics tools: SQL, Python, R, and Databricks
• Proficiency in Microsoft Office Suite, especially PowerPoint, Word, and Excel
• Prior experience with statistical analysis, predictive modelling, 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

Additional Details

• Location: Washington, DC (onsite)
• Travel required: None
• Clearance required: Ability to Obtain Public Trust
• Job family: Data Science Consulting
• Annual salary range: $113,000.00-$188,000.00

What Would Be Nice To Have

• Ability to collaborate in a team environment and work independently
• Ability to identify and address client needs; build relationships; prioritize and complete tasks; communicate potential conflicts to a supervisor
• Effective communication to different audiences, including various levels of management and external clients
• Experience facilitating meetings and presenting topics to diverse functional and technical staff
• Experience with 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