Data Analyst

Peraton•Washington, DC

3d•$86,000 - $138,000•Hybrid

About The Position

Peraton is hiring a Data Analyst to support critical regulatory reporting initiatives for U.S. derivatives markets. The role focuses on defining data standards, protecting the quality and integrity of market data, collaborating with industry stakeholders, and supporting oversight of traditional derivatives and emerging prediction markets. The position requires candidates to be local to the DMV area or the Chicago, Illinois area and able to work onsite at least three days per week. The Data Analyst will develop and maintain data standards and technical materials for CFTC regulatory reporting, analyze exchange-submitted data, and help resolve data and processing issues. The role works with CFTC internal teams and external market participants, supporting regulatory submissions, onboarding of new applicants, and the integrity of market data in the Commission’s data warehouse.

Requirements

Minimum experience based on education: 8 years with a BS/BA, 6 years with an MS/MA, 10 years with an AS/AA, or 12 years with a high school diploma or equivalent.
Strong understanding of derivatives markets, including futures, options, swaps, and exchange operations.
Experience or knowledge of XML, FIXML, and FPML.
Experience in multi-data-center or cloud environments, including AWS and Redshift tools.
Ability to create detailed technical documentation, mapping specifications, and validation rules.
Excellent communication skills for coordinating with internal teams, external exchanges, and stakeholders.
At least one year of experience using SQL, PostgreSQL, Microsoft SQL Server, Microsoft Azure, and SQL Server Management Studio.
At least one year of experience using AWS, Redshift, and Python.
Must be able to work onsite at least three days per week.
Must be a U.S. citizen or Green Card holder.
Must be able to obtain and maintain a Public Trust Clearance.
Must be local to the DMV area or Chicago, Illinois area.

Nice To Haves

Active Public Trust Clearance.
SQL querying skills and AWS tools skills.
Financial industry certifications.
Experience with prediction-market data or familiarity with how prediction markets operate.
Experience with SAS, data visualization using programming languages such as Python or R, or commercial tools such as MicroStrategy or Tableau.

Responsibilities

Analyze and develop reporting requirements to define data standards specifications, schemas, and validation rules for CFTC regulatory reporting obligations.
Develop technical guidance, data-mapping documentation, FIXML examples, and updated guidebooks reflecting schema changes and new validations.
Answer data-submission questions from DCMs, SEFs, and DCOs, and maintain clear, current reference materials.
Analyze exchange-submitted data for duplicates, missing fields, errors, and cross-dataset mismatches.
Compare data across SQL Server and Redshift platforms to identify and document gaps or anomalies.
Support troubleshooting of UAT and production issues involving large-volume inbound datasets.
Collaborate with CFTC stakeholders, including DMO, DCR, Enforcement, and the Division of Data, as well as external market participants, to review and approve data standards specifications.
Participate in industry calls, regulatory working groups, and validation meetings.
Support onboarding of new DCM/SEF applicants by evaluating submissions, aligning them with CFTC requirements, and documenting needed updates.
Support the data loading and processing team in testing and troubleshooting input files from external sources into the CFTC data warehouse.