Data Analyst
Rate: $60/Hr
Location: Reston,VA
Hybrid: 3 days a week
Initially it is for 12 months period and will be made permanent if the performance is good.
Interview: in-person
Description:
Job Information
Support our clients financial data need from external and internal data sources and partners, and facilitate the inquiry and acquisition of financial data from them through technology developed both internally and externally.
Provide ongoing analysis of new products or asset classes, and suggest program modifications as necessary. May test applications for accuracy and functionality before putting them into service.
Key Job Functions and Qualifications
- Document business requirements based on internal customer needs, maintain application interface registration, support data attributes registration and source to target management(STTM).
- Support internal customers and resolve any data issues quickly to avoid interruptions to business processes.
- Understand how application is setup in AWS and how to test applications hosted in AWS.
- Communicate with internal teams to answer business questions, clarify requirements and perform UAT
- Understand how external market data, mainly securities and derivatives prices, various interest rates, and analytics flowing from external data vendors and partners, into our client's internal systems, and understand how the data get transformed into different xml and json formats and how the data feed into downstream systems
- Communicate with existing external data vendors and partners for any data issues in delivery, consistence, and precision, and connect internal customer demand with external vendors.
- Search data and data sources among external data vendors based on business needs, find proper channel like SFTP, HTTPS, curl to bring that data into the company, familiar with how public data is provided by the Treasury, SEC, and Federal Reserve and how to acquire it
- Use and modify formula to calculate and verify analytics feed into internal systems based on the security value changes caused by the market move when needed.
- Participate with product management, treasury, or capital markets staff in exercises to value derivatives or other complex products, or to revise models used to perform these valuations.
- Support existing internally developed applications that bring in the external data, trouble shoot data issues, help development team and operations team to support internal infrastructure, interfaces, and registration.
Data Analyst gathers user requirements for database changes, analyzes database requirements, creates specifications for the ETL team to load the data to the database, participates in functional design sessions, creates and executes test scripts for the load of the database, and aids in the escalation/resolution of data issues. The candidate must be familiar with the development lifecycle and must be proficient in querying databases via SQL or other tools.
Skills:
1) Expertise with Software Development Lifecycle (SDLC)
2) Ability to translate high level business requirements into database and ETL requirements (source to target mappings)
3) Ability to document business processes
4) Knowledge of SQL for querying databases
5) Excellent communication skills
6) Strong analytical skills.
7) Ability to multitask is critical
8) Knowledge of testing tools such as Mercury Quality Center or HP Quality Center desired
Education/Work Experience:
1) Bachelor degree in Computer Science, Information Systems or related field
2) Professional certification(s) desired 5-10 years software development experience with experience with projects of similar scope and complexity
