Immediate need for a talented Data Analyst. This is a 06+months contract opportunity with long-term potential and is located in Mclean, VA (Onsite). Please review the job description below and contact me ASAP if you are interested.
Job ID: 26-11300
Pay Range: $60/hr - $65/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).
Key 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.
Key Requirements and Technology Experience:
- Key skills; SQL, Python, Mortgage domain
- 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 dataand 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
- Champion in leveraging Excel workbooks to analyze large datasets and create reconciliations and reports
- Ability to juggle and prioritize 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
Our client is a leading Financial Industry, and we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration.
Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
By applying to our jobs you agree to receive calls, AI-generated calls, text messages, or emails from Pyramid Consulting, Inc. and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy .
Never miss an opportunity! Create an alert based on the job you applied for.
