Data Analyst

Data Analyst

BCforward is currently seeking a highly motivated Data Analyst in Chicago, IL

Position Title: Data Analyst

Location: Reston, VA

Anticipated Start Date: 8/18/2025
Please note this is the target date and is subject to change. BCForward will send official notice ahead of a confirmed start date.

Expected Duration: 6+ months with possibilities for extension

Job Type: Contract: 40 hrs/week

Payrate - $48 to $51.67/hr on W2

Job Description:

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

Keywords:

Data analysis, SQL

Benefits:

BCforward offers all eligible employees a comprehensive benefits package including, but not limited to major medical, HSA, dental, vision, employer-provided group life, voluntary life insurance, short-term disability, long-term disability, and 401k.

About BCforward:
Founded in 1998 on the idea that industry leaders needed professional service, and workforce management expert, to fuel the development and execution of core business and technology strategies, BCforward is a Black-owned firm providing unique solutions supporting value capture and digital product delivery needs for organizations around the world. Headquartered in Indianapolis, IN with an Offshore Development Center in Hyderabad, India, BCforward's 6,000 consultants support more than 225 clients globally.

BCforward champions the power of human potential to help companies transform, accelerate, and scale. Guided by our core values of People-Centric, Optimism, Excellence, Diversity, and Accountability, our professionals have helped our clients achieve their strategic goals for more than 25 years. Our strong culture and clear values have enabled

BCforward to become a market leader and best in class place to work.

BCforward is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against based on disability.
To learn more about how BCforward collects and uses personal information as part of the recruiting process, view our Privacy Notice and CCPA Addendum. As part of the recruitment process, we may ask for you to disclose and provide us with various categories of personal information, including identifiers, professional information, commercial information, education information, and other related information. BCforward will only use this information to complete the recruitment process.
This posting is not an offer of employment. All applicants applying for positions in the United States must be legally authorized to work in the United States. The submission of intentionally false or fraudulent information in response to this posting may render the applicant ineligible for the position. Any subsequent offer of employment will be considered employment at-will regardless of the anticipated assignment duration.

Interested candidates please send resume in Word format Please reference job code 241463 when responding to this ad.