Pyspark

Pyspark Finance Jobs

3 jobs found

15d ago

Financial Management Data Engineer

Guidehouse Inc. McLean, VA

McLean, VA

15d ago

$113k - $188k/yr Full time Analytics Automation Developer Big Data

Apply Now

Job Description

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.

View full job page →

1mo ago

Senior Financial Management Data Engineer

Guidehouse Inc. Washington, DC

Washington, DC

1mo ago Closed

$113k - $188k/yr Full time Senior Analytics Azure Data Engineer

This position is no longer accepting applications (closed Nov 2, 2026).

Job Description

Join Guidehouse Inc. as a Senior Financial Management Data Engineer supporting financial management and IT programs for the Department of Homeland Security (DHS). This onsite role in Washington, DC combines data engineering, governance, and analytics to help improve decision-making across financial and operational systems. In addition to impactful work, you will have access to a comprehensive benefits package and professional development support.

Salary: USD 113,000 to 188,000 per year. Travel: None.

What you will do

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, and perform quality assurance on those processes.
Design and implement data integration, mapping, and standardization frameworks, including configurable business rules and data crosswalks for interoperability, reconciliation, and reporting.
Manipulate large datasets and perform data mining and structuring using open-source tools such as SQL, Python, and PySpark to identify patterns and generate new insights.
Build data modeling processes, create algorithms and predictive models, and conduct ad hoc or exploratory analysis, including advanced analytics, predictive modeling, and machine learning.
Maintain data governance and ensure data 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, archiving documentation, and tracking and following up on action items.
Deliver client services and also support business development, internal initiatives, and ongoing professional development.

Required qualifications

Ability to OBTAIN and MAINTAIN a Federal or DoD “PUBLIC TRUST”; candidates must obtain approved adjudication prior to onboarding. 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 in Microsoft Suite, with emphasis on MS PowerPoint, MS Word, and MS Excel
Prior experience with statistical analysis, predictive modeling, machine learning, and artificial intelligence

Technologies you may work with

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 and support

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

Nice to have

Experience collaborating in a team environment and working independently
Ability to identify and address client needs, build relationships, prioritize work, and communicate potential conflicts
Professional communication across technical and management audiences, including external clients
Experience facilitating meetings and presenting 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 environments
Experience with Microsoft Power Platform (Power BI, Power Apps, Power Automate) and SharePoint

View full job page →

1mo ago

Data Scientist- Financial Investigation

Guidehouse Washington, DC

Washington, DC

1mo ago Closed

$98k - $163k/yr Full time Analytics Artificial Intelligence Big Data

This position is no longer accepting applications (closed Oct 26, 2026).

Job Description

Guidehouse is seeking a Data Scientist- Financial Investigation for an onsite role in Washington, DC. In this position, you will lead analytical workstreams that support complex financial crime investigations and enforcement matters, turning data into decision-support products for regulatory and enforcement stakeholders.

What you will do

Lead analytical workstreams supporting complex financial crime investigations and enforcement matters.
Use advanced data science methods to analyze structured and unstructured datasets, identifying patterns of illicit financial activity and supporting investigative findings.
Develop analytical products that inform regulatory and enforcement decision-making.
Translate analytical findings into memoranda, briefings, recommendations, or other decision-support materials.
Independently execute analytical projects while collaborating directly with investigators, intelligence analysts, attorneys, and regulatory stakeholders.

Requirements

Active and current Secret clearance is required.
Must be a US Citizen.
Bachelor's degree in Data Science, Statistics, Computer Science, Mathematics, Economics, Finance, Criminal Justice, Intelligence Studies, or a related field.
4+ years of experience developing analytical methods, models, tools, or workflows that deliver actionable insights.
Experience analyzing financial data and BSA filings, including SARs, CTRs, wire transfers, transaction records, account activity, or related financial intelligence datasets.
Strong proficiency with Python, SQL, PySpark, machine learning, natural language processing, data visualization, and statistical analysis.
Experience performing entity resolution of businesses, companies, beneficial owners, or related parties using analytical techniques.
Experience working in large-scale data environments using Hive, Spark, Hadoop, PostgreSQL, Oracle, or similar technologies.
Experience translating analytical findings into memoranda, briefings, recommendations, or other decision-support products.
Ability to independently execute analytical projects and collaborate with investigators, intelligence analysts, attorneys, and regulatory stakeholders.

Technologies

Python
SQL
PySpark
Machine learning
Natural language processing
Data visualization
Statistical analysis
Hive
Spark
Hadoop
PostgreSQL
Oracle

Nice to have

Experience supporting investigations involving money laundering, proliferation financing, terrorist financing, sanctions evasion, cyber-enabled financial crime, or complex fraud schemes.
Experience analyzing blockchain, virtual currency, Fedwire, correspondent banking, or international transaction data.
Experience supporting enforcement actions, regulatory reviews, or investigative matters.
Prior experience supporting FinCEN, Treasury, DOJ, DHS, or other federal law enforcement or regulatory agencies.

Compensation, travel, and job family

Annual salary range: USD 98,000 - 163,000
Travel required: up to 10%
Job family: Risk & Regulatory Compliance Consulting

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

View full job page →

Pyspark Finance Jobs

Financial Management Data Engineer

Senior Financial Management Data Engineer

Data Scientist- Financial Investigation

Get Pyspark Finance Jobs alerts