Financial/Data Analyst

Job Title: Financial/Data Analyst

Location: McLean, VA 22102 (hybrid – 3 days/week onsite)

Duration: 2 months

Contract Type: W2 only

Pay Rate: $53.16/Hour

 

Role & Responsibilities

Collect and write detailed data transformation and financial process requirements

Create and take responsibility for project deliverables

Create and maintain technical, process and data-related documentation

Create, analyze, execute and enhance complex Excel-based and Python-based processes, data controls and data reconciliations

Support acceptance testing; create and execute test cases; analyze and reconcile complex test results using Excel and Python

Improve and automate validations and input preparation processes

Maintain, update and track development features and stories in JIRA

Troubleshoot, track and resolve project issues, project dependencies and configuration changes

Lead the analysis, requirements and testing of financial reports using advanced Excel and custom Python code

Perform complex data and reports analysis involving financial, forecasting and risk data

Asses impacts from data sources and product changes to systems and processes

Create engaging and detailed materials including user guides, specification documents, release notes and testing results

Support a variety of project management activities, including control requirements and execution, issue troubleshooting and analysis, data conversion and cataloguing, and user training.

 

Qualifications

Degree in accounting, quantitative finance, statistics, mathematics, economics, data analytics or a related quantitative field preferred, with 1-3 years of relevant work experience.

Work experience and proficiency in programming and/or data mining languages such as SQL, Python or SAS

Experience working with large data sets and relational databases

Outstanding quantitative, analytical, and problem-solving skills

Excellent presentation, communication and writing skills

Ability to use SQL to query and display large data sets while maximizing the performance of workbooks

Proven experience writing SQL to query complex data structures and working with analytics

Expertise with Python coding

Expertise with financial statements and general ledger/subledger data is strongly preferred

Ability to translate complex business requirements into technical specifications

Excellent competency with advanced Excel is required

Knowledge of application development following Agile methodology

Experience working with different databases and understanding of data and financial reporting concepts

Experience with implementing or modifying financial systems or applications, preferably related to accounting functions

Strong data and financial analytical skills; Ability to quickly understand complex financial concepts; Mortgage industry experience preferred