Senior Financial Management Data Engineer

About the role

Guidehouse is seeking a Data Engineer to join our Defense and Security Segment. The individual will collect, transform, integrate, and analyze data in support of organizational and mission goals, and support decision-making for financial management and information technology programs within the Department of Homeland Security (DHS).

Responsibilities

• Access data sources, establish data connections, and develop data 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 of these tasks.
• Design and implement data integration, mapping, and standardization frameworks, including configurable business rules and data crosswalks, to enable interoperability, reconciliation, and reporting across disparate financial and operational systems.
• Manipulate large datasets, perform data mining, and structure raw data using open-source tools such as SQL, Python, and PySpark to formulate or recognize patterns and generate new information.
• Design data modeling processes, create algorithms and predictive models, and perform ad hoc/exploratory data analysis to support data-driven decision-making, including advanced analytics techniques such as predictive modeling and machine learning.
• Ensure data governance and quality assurance standards are met.
• Help define data quality metrics associated with the quality of data ingested into Databricks.
• Organize and lead client meetings, including scheduling meetings; drafting and delivering agendas and meeting minutes; providing and archiving required documentation; and documenting, tracking, and following up on action items.
• Deliver client services while supporting business development, internal firm initiatives, and ongoing professional development.

Requirements

• Must be able to obtain and maintain a Federal or DoD "Public Trust"; candidates must obtain approved adjudication of their Public Trust prior to onboarding with Guidehouse. Candidates with an active Public Trust or Suitability are preferred.
• Bachelor's degree.
• Three or more years of data experience.
• Experience in performing data analytics to address management and operational challenges.
• Proficiency in data analytic tools such as SQL, Python, R, and Databricks.
• Proficiency in Microsoft Suite, especially MS PowerPoint, MS Word, and MS Excel.
• Prior experience with statistical analysis, predictive modeling, machine learning, and artificial intelligence.

Nice to have

• Collaborating and working in a team environment, as well as the ability to work independently.
• Identifying and addressing client needs, building relationships with clients, demonstrating flexibility in prioritizing and completing tasks, communicating potential conflicts to a supervisor.
• Communicating effectively to various audiences, including various levels of management and external clients, in a professional environment.
• Ability to facilitate meetings and present topics to diverse groups of 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 Microsoft Azure, AWS, or similar cloud environments.
• Experience with Microsoft Power Platform (Power BI, Power Apps, Power Automate) and SharePoint.

Pay

The annual salary range for this position is $113,000.00–$188,000.00. Compensation decisions depend on a wide range of factors, including but not limited to skill sets, experience and training, security clearances, licensure and certifications, and other business and organizational needs.

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 Pay Down
• Tuition Reimbursement, Personal Development & Learning Opportunities
• Skills Development & Certifications
• Employee Referral Program
• Corporate Sponsored Events & Community Outreach
• Emergency Back-Up Childcare Program
• Mobility Stipend