Senior Financial Management Data Engineer

Guidehouse Inc.; Washington (District of Columbia); On-site; USD 113,000 - 188,000; Full time

Benefits offered by this job

Medical Insurance

401(k) Retirement Plan

Parental Leave

Job summary

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

On-site location in Washington, DC with a focus on data quality, interoperability, and advanced analytics. The role emphasizes building scalable data pipelines, implementing governance standards, and delivering actionable insights using SQL, Python, R, and Databricks.

Qualifications

• Bachelor's degree required.
• 3+ years of data experience.
• Proficiency in SQL, Python, R and Databricks.
• Experience performing data analytics to address management and operational challenges.

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.
• 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.

Skills

SQL

Python

R

Databricks

Education

Bachelor's degree

Tools

Databricks

Microsoft PowerPoint

Microsoft Word

Microsoft Excel

Job description

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