Sr. Data Analyst

About

Peraton is adding or looking for a Sr. Data Analyst. This qualified individual will support our CFTC contract and will join a team of high performer. This position is Hybrid. Must be local to the DC, MD, VA.

What will you do:

• Expert analysis in transaction-level data across derivatives markets, familiarity with the CFTC’s dual cloud environment and the skillset to develop data standards and perform analysis to support the real-time alerts and reporting within the complex NMS platform.
• Conduct analysis and develop and update requirements and schemas for the full complement of exchanges.
• Map CFTC in-house exchange datasets to NMS FIX input messages, including but not limited to, orders, trades, products, and participants.
• Create technical guidance documents with data maps and conditions.
• Support data loading & processing team in testing and trouble-shooting input files from external sources into NMS.
• Experience with data warehouse, data lake, and enterprise big data platforms in multi-data-center contexts required.
• Knowledge of industry-specific XML data exchange message formats, including necessary modifications or extensions.
• Collaborate with stakeholders and industry representatives to secure approval for technical guidance.
• Document expansion of existing datasets, including mapping to FIX input format, to leverage more features of the NMS system.
• Assist CFTC data loading & processing team by documenting and testing expanded dataset extracts into NMS.
• Assess and document new datasets needed to make better use of NMS system.
• Assist CFTC data loading & processing team in relating new datasets to existing databases and testing loads and extracts into NMS for implementation.
• Conduct assessments, document requirements and create mappings to support standards development for all datasets.

Required Qualifications:

• Minimum of 8 years with BS/BA; or 12 years with a HS degree
• Derivative markets knowledge with Futures, Options and Swaps products and exchanges.
• Experience/Knowledge in AWS cloud tools
• Experience in Redshift data warehouse service
• Experience/Knowledge of XML, FIXML, FPML
• At least one (1) year of experience using:
• SQL, PostgreSQL
• Microsoft SQL Server, Microsoft Azure, SQL Server Management Studio.
• SAS, SAS Enterprise Guide, SAS Viya.
• AWS, including QuickSight, Redshift, Sage Maker;
• Python, including the following Python packages/libraries/modules:
• Experience with data visualization using programming languages, (e.g. Python or R), or commercial tools (e.g. MicroStrategy, Tableau, JMP, or Amazon Web Services (AWS) QuickSight
• 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, SAS reporting skills is a plus
• Financial Industry Certifications is a plus