Data Analyst (in-person Interview )

Overview

Hybrid
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - 12 Month(s)
No Travel Required
Able to Provide Sponsorship

Skills

SQL
SDLC

Job Details

Role: Data Analyst

Reston, VA

12+ Months

Description:


Job Information
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 Fannie Mae'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 Fannie Mae's 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

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.