Data Analyst

Peraton; Washington (District of Columbia); On-site; USD 86,000 - 138,000; Full time

Job summary

Peraton is seeking a Data Analyst to join a high‑impact team supporting regulatory reporting in the U.S. derivatives markets. You will help define data standards, ensure data quality, and collaborate with industry stakeholders on both traditional derivatives and prediction markets.

Local to the DMV area or Chicago is required. You will analyze exchange data, develop mappings and validation rules, and support data loading into the CFTC Datawarehouse.

Qualifications

• Minimum of 8 years with BS/BA; Minimum of 6 years with MS/MA; Minimum of 10 years with an AS/AA; or 12 years with a HS diploma/equivalent
• Strong understanding of derivatives markets, including futures, options, swaps, and exchange operations
• Experience/Knowledge of XML, FIXML, 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, SQL Server Management Studio
• AWS, Redshift, Python
• Must be able to go onsite at least 3 days a week
• Must be a US Citizen or a Green Card Holder
• Must be able to obtain and maintain a Public Trust Clearance

Responsibilities

• Conduct analysis 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 that incorporate schema changes and new validations
• Support DCMs, SEFs, and DCOs by answering data‑submission questions and maintaining clear, up‑to‑date reference materials
• Perform detailed analysis of exchange‑submitted data including checks for duplicates, missing fields, and other errors, and cross‑dataset mismatches; conduct multi‑platform comparisons in SQL Server and Redshift to identify gaps or anomalies
• Collaborate with internal stakeholders at CFTC and external market participants to review and approve data standards specifications
• Participate in industry calls, regulatory working groups, validation meetings, and support onboarding of new DCM/SEF applicants
• Support data loading & processing team in testing and trouble‑shooting input files from external sources into CFTC Datawarehouse

Skills

SQL

PostgreSQL

Microsoft SQL Server

Microsoft Azure

AWS

Redshift

Python

XML

FIXML

FPML

Data analysis

Communication skills

Public Trust

US Citizenship

Education

BS/BA in related field

MS/MA in related field

AS/AA

HS diploma or equivalent

Tools

Tableau

MicroStrategy

Job description

Responsibilities

Join a high-impact team supporting critical regulatory reporting initiatives for the U.S. derivatives markets.

We are looking to add a Data Analyst to the team. In this role, you’ll help define data standards, ensure the quality and integrity of market data, collaborate with industry stakeholders, and contribute to the oversight of both traditional derivatives and emerging prediction markets. If you have expertise in capital markets, data analysis, SQL, AWS, and regulatory reporting, we’d love to hear from you. Must be local the DMV area or Chicago, IL area.

What will you do:

• Conduct analysis 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 that incorporate schema changes and new validations.
• Support DCMs, SEFs, and DCOs by answering data‑submission questions and maintaining clear, up‑to‑date reference materials.
• Perform detailed analysis of exchange‑submitted data - including checks for duplicates, missing fields, and other errors, and cross‑dataset mismatches, and conduct multi‑platform comparisons in SQL Server and Redshift to identify and document gaps or anomalies. Additionally, support troubleshooting of UAT and production issues for large‑volume inbound datasets.
• Collaborate with internal stakeholders at CFTC including DMO, DCR, Enforcement, and the Division of Data and with external market participants to review and approve data standards specifications.
• Participate in industry calls, regulatory working groups, validation meetings, while supporting onboarding of new DCM/SEF applicants by evaluating submissions, aligning them with CFTC requirements, and documenting necessary updates.
• Support data loading & processing team in testing and trouble‑shooting input files from external sources into CFTC Datawarehouse.

*Must be local the DMV area or Chicago, IL area ONLY.

Qualifications

Required Qualifications:

• Minimum of 8 years with BS/BA; Minimum of 6 years with MS/MA; Minimum of 10 years with an AS/AA; or 12 years with a HS diploma/equivalent
• Strong understanding of derivatives markets, including futures, options, swaps, and exchange operations.
• Experience/Knowledge of XML, FIXML, 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 (1) year of experience using:
• SQL, PostgreSQL, Microsoft SQL Server, Microsoft Azure, SQL Server Management Studio.
• AWS, Redshift, Python
• Must be able to go onsite at least 3 days a week.
• Must be a US Citizen or a Green Card Holder
• Must be able to obtain and maintain a Public Trust Clearance

Preferred Qualifications:

• Active Public Trust Clearance is a plus
• SQL querying skills, AWS tools skills
• Financial Industry Certifications is a plus
• Prior experience with prediction‑market data or familiarity with how these markets operate is a plus.
• Experience with SAS, data visualization using programming languages, (e.g. Python or R), or commercial tools (e.g. MicroStrategy, Tableau) (Preferred, not required)

Peraton Overview

Peraton is a next‑generation national security company that drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the world's leading mission capability integrator and transformative enterprise IT provider, we deliver trusted, highly differentiated solutions and technologies to protect our nation and allies. Peraton operates at the critical nexus between traditional and nontraditional threats across all domains: land, sea, space, air, and cyberspace. The company serves as a valued partner to essential government agencies and supports every branch of the U.S. armed forces. Each day, our employees do the can't be done by solving the most daunting challenges facing our customers. Visit peraton.com to learn how we're keeping people around the world safe and secure.

Target Salary Range

$86,000 - $138,000. This represents the typical salary range for this position. Salary is determined by various factors, including but not limited to, the scope and responsibilities of the position, the individual's experience, education, knowledge, skills, and competencies, as well as geographic location and business and contract considerations. Depending on the position, employees may be eligible for overtime, shift differential, and a discretionary bonus in addition to base pay.

EEO

EEO: Equal opport