• Us Citizen

• Green Card

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 9th Jan 2021

SQL/Python Report Developer

Location: Chicago or NYC preferred but will takeelsewhere if they have the experience

Duration: 6 months plus 

Industry: Trading

Visa: NO CPT/H1B

Interview: WebEx with Citadel 

 Neededwith resume: LinkedIn profile and photo ID

Skills/Must-Haves :
* SQL expertise
* Strong Python development
* Regulatory and/or equities/options experience
* Large-scale reporting development

Tradingindustry experience Highly preferred

JobSummary: Skills:
• SQL most important
• Python - very important
• Regulatory experience AND/OR (equities /options) Regulatory experience can besupplemented for equities or options andvice versa (not Fixed Incomeexperience)• Front office experience (trading)–strongly preferred over backoffice experience (ie settlements) Allocationwould be a key word though to lookfor if the person is back office
• OATS Bluesheets – keywordsResponsibilities
• Develop, test, and help deploy and support ascalable solution for reportgeneration, attestation, artifact managing, and testing
• Work with Reporting Services and ReportingPlatform and with the BusinessControls and Trading Desks to develop supportfor a fully automated lifecyclefor reports’ submission and response workflows
• Work with report developers on maintainingthe consistency of developmentstandards
• Assume responsibility for deliveringreporting logic for Hong Kong SF DataStandard Order Lifecycle
• Build automated alerts and reporting tovalidate the effectiveness of theFirm’s trading controls. This includes utilizationbased repots for Risk Limits,monitoring reports for strategy behavior withrespect to trading controls andvalidating core regulatory controls are met.
• Work with Trading and Front OfficeTechnology to assess the impact of businesschanges on existing reportingfunctionality.
• Work with the Quality Assurance team onintegrating the report developmentinto the state-of-the-art QA framework atCitadel Securities

Qualifications
• Financial Services experience, withregulatory reporting experience highlypreferred (e.g., OATS, CAT, MiFID II,Hong Kong Transaction Reporting,Supervisory or Surveillance Reports)
• Experience designing, developing (coding),testing, deploying, documenting,and validating supervisory, and exceptionreports overseeing areas like tradingactivity (examples: best execution, ordermarking, wash trade, naked shortselling, information barriers, transactioncost analysis, potential market abuse)
• Experience with trading workflows(order-execution-settlement lifecycle, ordertypes), trading technologies(market data feeds, market access andconnectivity), market structure(exchanges, dark pools), and products (equities,options, futures, swaps,treasuries)
• Experience with automated tradingenvironments a plus
• A minimum of 4-6 years engineeringexperience related to large-scale reportingdevelopment
• Experience in using relational,non-relational, and streaming data forreporting
• Bachelor’s degree in relevant discipline(Computer Science, Mathematics,Statistics, Engineering, InformationTechnology, or other related field),Master’s degree or similar graduatestudies in these areas is a plus
• Databases: SQL Server, Snowflake
• Languages: SQL and Python is required andC is a plus
• Data streaming/queueing frameworks: Kafka
• Containerization: Kubernetes
• Strong communication and presentationskills, project management, andrelationship-building skills to manage internalstakeholder relationships
• Maintains high level of confidentiality, integrity, and professionalism