Data Analyst Senior

About

Genesis10 is currently seeking a Data Analyst Senior with a Major Financial Institution located in McLean, VA. This is a 6‑month fully onsite contract opportunity. The candidate will support project management activities and initiatives, with a focus on financial & capital reporting and forecasting. The role includes complex data analysis, reconciliations, testing, development lifecycle activities, and production support, coordinating directly with key business area and IT partners.

Responsibilities

• Outstanding proficiency with Excel for data analysis of complex datasets, data quality validation, data reconciliations, and data transformation for inputs and outputs of forecasting processes
• Collect and write detailed data transformation and financial process requirements
• Create high‑quality and high‑complexity project deliverables, focused on requirements, reconciliations and test results
• Create and maintain technical, process and data‑related documentation
• Support acceptance testing; create and execute test cases, reconciliations and regressions; analyze and reconcile complex test results using Excel and SQL
• 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 SQL and advanced Excel
• Perform complex data and reports analysis involving financial, forecasting and risk data
• 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 cataloging, and user training

Requirements

• Degree in accounting, quantitative finance, statistics, mathematics, economics, data analytics or a related quantitative field preferred, with at least 5 years of relevant work experience
• Extensive experience using advanced Excel efficiently is required
• 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 financial statements and general ledger/subledger data is strongly preferred
• Ability to translate complex business requirements into technical specifications
• Outstanding attention to detail and accuracy
• 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

Key to Success

• Champion in leveraging Excel workbooks to analyze large datasets and create reconciliations and reports
• Ability to juggle and prioritize a large number of activities of varying scope
• Ability to focus on precision, accuracy, reliability, delivery and schedule
• Outstanding ability to leverage data to validate code and processes
• Phenomenal teammate with a positive attitude

Pay Rate

• Up to $66.37 hourly

Benefits (Genesis10)

• Access to hundreds of clients, many with long‑term relationships
• Career‑home opportunities within Genesis10
• Experienced recruiting team
• Behavioral Health Platform
• Medical, Dental, Vision coverage
• Health Savings Account
• Voluntary Hospital Indemnity (Critical Illness & Accident)
• Voluntary Term Life Insurance
• 401(k) plan
• Sick Pay (where applicable)
• Commuter Benefits (Dallas, NYC, SF)