Data Validation & Visualization Consultant

Location: McLean, Virginia US

Apply Refer a Friend

Requisition Number: 1847

Position Title:

External Description:

For a large Financial Services client, we are seeking a Data Validation & Visualization Consultant who can pull financial data from a cloud (S3) environment, analyze and test it using SQL and other tools to validate credit policy.

Responsibilities:

  • Pull data from cloud location and perform data joins. Construct appropriate analysis and visualizations to support validation efforts associated with bank regulator requests.
  • Use analytical skills to create case statements to identify potential violations of credit policy.
  • Make extensive use of data visualization tools to analyze financial data. Client does not specify a required visualization application; environment includes common applications such as Python, R, Tableau, Excel.
  • Perform analysis and visualizations to ensure accuracy of data, correct capture of business rules into technical requirements, and appropriate sample size.

Requirements:

  • 2+ years of experience with SQL and pulling data from AWS cloud (S3 and Snowflake).
  • Experience working with AWS S3 and Snowflake REQUIRED.
  • Ability to understand concepts in financial institutions such as bank loan terms and credit policies, and perform data validation and visualization supporting determination of compliance with policies.
  • Familiarity with financial data is preferred.
  • Exposure to concepts in financial modeling is helpful but not required.
  • Strong technical experience with SQL.
  • Technical expertise with one or more of the following R, Python, Tableau, Amazon Quicksight, Google Sheets.
  • Familiarity with accepted principles and practices regarding selection of sample size for large data sets.
  • Master's Degree in Economics, Statistics, Computer Science, or related strongly preferred.

City: McLean

State: Virginia

Community / Marketing Title: Data Validation & Visualization Consultant

Company Profile:

The Oakleaf Group is a premier advisory firm with expertise in risk management and financial modeling for the mortgage and banking industries. We serve publicly traded and privately held banks and non-bank mortgage firms, government agencies, law firms, insurance companies, institutional asset managers and hedge funds. Founded in 2007, our firm’s over 100 professionals are located in the Washington, DC and New York City metro areas, serving clients across North America and Europe. 

We differentiate ourselves through our approach to client relationships. We begin with the belief that each client relationship will be permanent and ongoing, spanning across engagements. We invest in communication and research to ensure that we fully understand the drivers of every client’s short and long term success. We align our goals to those of our clients, and we continuously monitor and adjust to ensure that the relationship stays strong. 

It’s on the foundation of strong client relationships and aligned objectives that we provide expertise-infused advisory services and technology-aware implementation assistance that drive client success.

Location_formattedLocationLong: McLean, Virginia US

CountryEEOText_Description: As a condition of employment with The Oakleaf Group, any successful job applicant will be required to successfully complete a background investigation, which may also include a pre-employment drug screen and/or a credit check for positions in some areas of our business. The Oakleaf Group is an equal opportunity employer. Applicants are considered for positions without regard to race, religion, gender, native origin, age, disability, or any other category protected by applicable federal, state, or local laws.

7315 Wisconsin Avenue, East Tower 10th Floor
Bethesda, MD 20814
P. (202) 684-2800 • F. (202) 684-2803

© 2018 The Oakleaf Group, All Rights Reserved.