Guidehouse is seeking a Financial Management Data Engineer to collect, transform, integrate, and analyze data that supports DHS Financial Management mission goals. The role is focused on building data ingestion and integration solutions, applying modeling and analytics, and ensuring data governance and quality to enable informed decision-making.
Responsibilities
- Access data sources by establishing data connections and developing ingestion and integration solutions using APIs, databases, file-based interfaces, and enterprise platforms to support data acquisition and pre-processing for analysis.
- Aggregate, clean, and organize datasets from disparate sources, and perform quality assurance for these processes.
- Design and implement data integration, mapping, and standardization frameworks, including configurable business rules and data crosswalks, to support interoperability, reconciliation, and reporting across financial and operational systems.
- Manipulate large datasets and structure raw data using SQL, Python, and PySpark to identify patterns, generate new information, and support actionable insights.
- Design data modeling processes, build algorithms and predictive models, and perform ad hoc or exploratory analysis to support data-driven decision making, including advanced analytics such as predictive modeling and machine learning.
- Maintain data governance and adhere to quality assurance standards.
- 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 and following up on action items.
- 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 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 with Microsoft Suite, especially MS PowerPoint, MS Word, and MS 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 required: Up to 10%
- Clearance required: Ability to Obtain Public Trust
Salary Range
$113,000.00-$188,000.00 per year
What We Offer
Guidehouse provides a comprehensive total rewards package, including competitive compensation and a flexible benefits package designed to support a diverse and inclusive workplace.
