The Oakleaf Group, LLC

  • Analyst, Data and Software Development

    Job Location 2 weeks ago(4/12/2018 12:15 PM)
    Posted Date
  • Overview

    Analyst, Data and Software Development

    Washington, DC metro area



    The Oakleaf Group is seeking an Analyst to join their Data and Applications team to support clients with large and complex datasets. These datasets must be collected, validated, aggregated, transformed and then vended internally to support a variety of analytical purposes.  This position requires a wide spectrum of skill sets including complex data manipulation, quantitative analysis, and software development. The incumbent will refine the existing data warehouse in a Python, SQL database, and AWS environment as it evolves to support similar new business, incorporating reuse where practical.  The incumbent may also contribute to a long-term effort to share back-end analytical processes in a self-service user environment and may also develop and support analytical finance applications, according to ability and the evolving needs of the practice.


    • Data Sourcing: Analyze and document data conventions used in outside data sources. Understand multiple sources and utilize the most appropriate.
    • Data Warehousing: Load data into Oakleaf’s secure data stores capturing metadata, and mapping data to Oakleaf’s standardized data fields. Maintain load scripts.
    • Data Cleansing: Run validations to identify, document and remediate missing, or unreasonable data. Transform data as required for downstream models and reports. Maintain validation and transformation software.
    • Reporting: Design and implement reports, extracts and queries to assist in business analysis and modeling.
    • Data Architecture: Design logical database models using normalization/ standardization techniques. Develop strategies and data structures to unify information of various types from numerous disparate data sources and facilitate re-use across clients and usages. Document data processes, and information flow.
    • Software development: Develop, maintain, and execute data warehouse applications and analytical financial applications.


    • Bachelor’s degree in Mathematics, Statistics, Computer Science, Engineering, Physics, Business, Finance, Economics, Accounting or related field.
    • 1-4+ years (Analyst) experience in querying and creating stored procedures in a SQL or No-SQL data querying languages.
    • 1-4+ years (Analyst) experience in a programming role using Python, R, or other industry standard data manipulation languages. Senior Analysts will have 3+ years of experience.
    • Experience in handling time-series data and other large datasets. Senior Analysts will preferably have experience in formal data stewardship, provisioning data to customers adhering to enterprise quality standards.
    • Database administration, SAS, accounting, and statistical analysis experience is a plus.
    • Domain knowledge of financial instruments and particularly the mortgage lifecycle preferred, and highly preferred for Senior Analysts.
    • Experience in application testing, performance tuning and optimization.
    • Understanding of object-oriented programming, design patterns and data structures.



    Company Overview

    The Oakleaf Group is a mid-size consulting firm with offices in Bethesda, MD and New York, NY. Our people are our greatest assets and our company culture is grounded on that belief. Our goal is to thrill our clients and challenge and reward our employees.  As a member of the Oakleaf team, you will have an exciting opportunity to work with emerging technology, modernize financial applications, and grow in a friendly workplace where you can work independently and collaboratively. In this position the ideal candidate will work to solve complex “hot topic” issues currently faced by the financial services industry. We bring depth of experience to a wide range of highly satisfied clients, delivering trusted advice along with quantitative, technology, regulatory, and operations strategies. Do you possess the talent and dedication to be part of our growing team?



    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. The Oakleaf Group participates in the E-Verify program.


    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed