Data Analyst Specialist

Role: Data Analyst Specialist

Job Type: Contract on CTH

Location: McLean, VA (Onsite)

Top Skills as per Hiring Manager:

1. Data Analysis


2. Advanced Excel (90%)


3. SQL Expertise (10%)


4. Python


5. Accounting Experience (accounting background- general ledgers, subledgers, mortgage accounting)


6. Wants to see a finance degree or finance related degree, equivalent professional experience will work too


7. Doesn’t want to see statistic or mathematics background

Required Qualifications:

1. 5 years of hands-on experience in data transformation and data reconciliation.


2. Expertise in Advanced Excel functionalities and capabilities.


3. Strong proficiency in SQL, with extensive experience in querying databases.


4. Prior experience in the finance industry, particularly in accounting.


5. Familiarity with general ledgers, sub-ledgers, and mortgage accounting or mortgage security experience.


6. Demonstrated ability in data testing, data reconciliation, and conducting detailed data analysis.


7. In-depth knowledge of Fannie Mae and Freddie Mac mortgage security accounting.