Data Developer/ Team Lead

  • Washington, DC
  • Posted 60+ days ago | Updated 1 hour ago

Overview

On Site
USD 86,000.00 - 138,000.00 per year
Full Time

Skills

Data Architecture
Analytical Skill
Knowledge Management
Data Visualization
Prototyping
Leadership
Team Leadership
As-is Process
IT Management
Management
Corrective And Preventive Action
Microsoft Exchange
Forms
Surveillance
ISS
Reporting
Market Analysis
Regulatory Compliance
Quality Assurance
Business Analytics
Business Analysis
Mergers and Acquisitions
Derivatives
Amazon Web Services
R
Python
Amazon S3
Amazon Redshift
Remote Desktop Services
Amazon RDS
DMS
Amazon SageMaker
Database
Microsoft SQL Server DBA
Microsoft SQL Server Management Studio (SSMS)
Microsoft SQL Server
Microsoft SSRS
JMP
MATLAB
Microsoft Excel
PowerPivot
Microsoft SharePoint
SAS
Business Intelligence
Stata
SQL
Microsoft SSAS
Security Clearance
Finance
Computer Science
Statistics
Nexus
Adobe AIR
SAFE

Job Details

Responsibilities

We are looking to add a Senior Data Developer, Team Lead to our analyst team. CFTC Market Data Operations (MDO) is responsible for the oversight, data architecture, and analytical support of electronic data received at the Commission. Working across all divisions, MDO provides agency-wide data strategy, knowledge management, and query support. MDO data support includes building custom data visualization tools, prototyping conceptual data models, generating custom reports, and providing overall guidance on how to leverage the data available at the Commission.The qualified individual must be local to the DC Metro area. This is a hybrid position, one day a week onsite schedule.

The Senior Data Analyst, Team Lead will work as an advisor to the customer and a trusted liaison between customer and Peraton leadership. The team lead is responsible for automation of the manual quality checks that are currently performed. This person will take up the current manual work as is and in parallel work to automate the manual checks.

What you will do:
  • Serves in a technical lead role, responsible for overseeing the work of the 3 data operations specialists
  • This role will require performing routine data checks as outlined below and development and automation of the quality checks
  • Communicates with exchange personnel to request incomplete data and assure the resolution of discrepancies
  • Ensure that reporting entities submit position data accurately and is complete; ensure appropriate corrective action is taken
  • Request missing position data from the reporting entities and ensure that the requested information is received. Missing data is submitted electronically
  • Monitor the receipt of daily exchange reporting which includes permanent record and clearing member data
  • Analyzes a variety of futures and other derivatives data by monitoring reports filed by exchanges, futures commission merchants, traders, and resolving reporting problems
  • Request and review submitted forms for unidentified accounts
  • Enter data into Integrated Surveillance System (ISS) and ensure that the account is associated with the correct trader
  • Resolve data issues related to the weekly publication of the Commitment of Traders report
  • Perform data reviews to ensure that submitted data is complete and matches source data at reporting firm
  • Monitor the performance of market participants with regard to timeliness of submissions, the number of errors submitted on data files, discrepancies between what was reported and what was cleared
  • Review and analysis of firms' position, ownership and control data
  • Review and analysis of futures and options data, and market data for compliance
  • completeness, consistency and quality
  • Review and analysis of data published on Commission reports
  • Receives and/or enters data submitted on the Call Cotton form (Form 304)
  • Quality analysis of transactional, position, ownership and control data
  • Responding to data inquiries from other divisions

Qualifications

Required Qualifications:
  • 5 years with BS/BA; 3 years with MS/MA; 0 years with PhD
  • Working knowledge of derivatives market (futures, options, etc)
  • Experience working and automation/development in an AWS environment
  • Experience with R, Python, S3, Redshift, RDS, DMS, SageMaker, QuickSight
  • Experience in Microsoft SQL Server database
  • SQL Server Management Studio (SSMS) experience
  • SQL Server Reporting Services (SSRS)
  • Statistical Analysis System (SAS)
  • Familiarity with SAS JMP
  • Matrix Laboratory (MATLAB) experience
  • Experience in Excel, PowerPivot, SharePoint
  • SAS Enterprise Business Intelligence Platform
  • Markit, Stata, SQL Services Analysis Services experience
  • Must be able to obtain and maintain the required agency clearance

Preferred Qualifications:
  • Active Public Trust
  • Master's degree in business, finance, computer science, statistics or related field and 5 years of experience

Benefits:

At Peraton, our benefits are designed to help keep you at your best beyond the work you do with us daily. We're fully committed to the growth of our employees. From fully comprehensive medical plans to tuition reimbursement, tuition assistance, and fertility treatment, we are there to support you all the way.

#LI-ET1

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 based on experience and other factors.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.