Demo

Senior Algorithm Developer - PySpark / SQL

ACA Group
Durham, NC Full Time
POSTED ON 5/16/2026
AVAILABLE BEFORE 6/21/2026
Senior Algorithm Developer – PySpark / SQL

Company Overview:

ACA Global delivers market abuse surveillance solutions to institutional investors, hedge funds, and asset managers. The Market Abuse Surveillance (MAS) platform monitors trading activity across equities, fixed income, and derivatives to identify potential regulatory and policy violations.

The Opportunity:

This role sits on the Market Abuse Surveillance Product Development team and focuses on validating, optimizing, and advancing a PySpark‑based surveillance platform. Following a multi‑year algorithm migration initiative, the emphasis is now on production quality, performance optimization, and next‑generation algorithm development. The position blends deep PySpark/Python and SQL expertise with financial markets and regulatory domain knowledge.

What You'll Do:


  • Validate and QA migrated surveillance algorithms by reconciling PySpark outputs against legacy SQL baselines across multiple client environments
  • Optimize PySpark algorithms and Spark infrastructure to meet processing SLAs across large data volumes
  • Enhance and develop new surveillance algorithms aligned to evolving regulatory and client requirements
  • Support legacy SQL systems during transition and ensure data integrity and auditability

Technical Skill Set:


  • 3 years of hands‑on PySpark/Python development in production environments
  • Strong Spark expertise (DataFrames, SQL functions, windowing, joins, optimization, execution plans)
  • 5 years of advanced SQL experience (CTEs, window functions, performance tuning, stored procedures)
  • Experience operating within the Spark ecosystem (EMR, Iceberg, Spark UI)
  • Strong AWS experience (S3, EMR, IAM, CloudWatch, cost optimization)
  • Familiar with CI/CD, Git workflows, JIRA, automated testing, and code review practices

Domain Expertise (or Strong Willingness to Learn):


  • Financial instruments: equities, fixed income, and derivatives
  • Trade lifecycle and portfolio concepts
  • Market abuse and regulatory surveillance (KYC/AML, best execution, fair dealing)
  • Institutional trading behavior and surveillance patterns

Experience Profile:


  • 5 years total software development experience, including large‑scale data processing systems
  • Proven track record delivering production‑ready data or algorithmic platforms
  • Strong validation, testing, and reconciliation experience across complex data systems
  • Background in fintech, RegTech, or financial services strongly preferred
  • Experience working in agile teams with cross‑functional stakeholders (QA, DevOps, Product)

What Success Looks Like:


  • Quickly ramp on MAS platform architecture and algorithm logic
  • Validate and production‑ready multiple surveillance algorithms with audit‑ready documentation
  • Improve algorithm performance and stability across client environments
  • Contribute to new algorithm development and next‑generation platform initiatives
  • Become a subject matter expert on specific surveillance domains or platform components

Impression:

This is a senior, hands‑on algorithm development role ideal for someone who enjoys working at the intersection of big data engineering, Python/Spark optimization, and financial regulatory logic in a production‑critical environment.

Salary.com Estimation for Senior Algorithm Developer - PySpark / SQL in Durham, NC
$123,908 to $159,208
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

What is the career path for a Senior Algorithm Developer - PySpark / SQL?

Sign up to receive alerts about other jobs on the Senior Algorithm Developer - PySpark / SQL career path by checking the boxes next to the positions that interest you.
Income Estimation: 
$119,030 - $151,900
Income Estimation: 
$149,493 - $192,976
Income Estimation: 
$119,030 - $151,900
Income Estimation: 
$149,493 - $192,976
Employees: Get a Salary Increase
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

Job openings at ACA Group

  • ACA Group Portland, ME
  • The Opportunity: This position is responsible for servicing our broker-dealer compliance consulting clients. What you’ll do: Provide consulting to our brok... more
  • 9 Days Ago

  • ACA Group Oklahoma, OK
  • The Opportunity: The individual in this position works with and supports supervisors, relationship managers, account owners, and engagement leads for certa... more
  • 11 Days Ago

  • ACA Group Oklahoma, OK
  • The Opportunity: The Exchange Traded Fund Specialist (“ETF Specialist”) will work in a small client-oriented institutional trading operation that services ... more
  • 11 Days Ago

  • ACA Group Medford, OR
  • The Opportunity The application support engineer specializing in financial concepts, including understanding transactions, holdings, and securities. You wi... more
  • 11 Days Ago


Not the job you're looking for? Here are some other Senior Algorithm Developer - PySpark / SQL jobs in the Durham, NC area that may be a better fit.

  • TekShapers Raleigh, NC
  • Job Role: Senior SSIS Developer Location: Raleigh, NC (Hybrid) Employment Type: Full-Time & CTH Start Date: ASAP Job Description: 10 years of strong hands-... more
  • 23 Days Ago

  • Stellar IT Solution Raleigh, NC
  • NC DHHS SQL/Power BI Developer Location : 1915 Health Services Way Raleigh, NC 27607 Hybrid Duration: 12 Months Job Description: DHHS-ITD is looking to hir... more
  • 30 Days Ago

AI Assistant is available now!

Feel free to start your new journey!