Senior Data Warehouse Engineer

| Greater NYC Area

At OnDeck, we make small business a big deal. We’re improving the world’s economic landscape by changing the way small businesses access capital. We care intensely about each other, our company and the customers we serve, and are committed to making every day count.

The Risk Management division creates competitive advantage for OnDeck through excellence in risk/reward optimization while simultaneously exercising its function of control in a vigorous and diligent fashion. The Risk Management team develops strategies and models to extend credit in a profitable manner to small businesses and their owners based on a strong understanding of the behavioral and commercial drivers of its customers and on sophisticated analysis of data. As the control function of OnDeck, the Risk Management Team ensures that that the portfolio, policies, strategies, new product features or operational processes at OnDeck are consistent with the risk appetite set by the management team and the board.

As a part of the Risk division, the Data Warehouse team manages the Data, Decisioning and Risk Systems Organization which owns Ondeck’s data infrastructure and data solution development. We are passionate about improving and maturing our Terabyte data environment and using data to solve business problems. We are looking for a Senior Data Warehouse Engineer to support the growing responsibilities of the team.

As a Senior Data Warehouse Engineer at OnDeck, you will:

  • Assist in leading the technical design and implementation of Ondeck’s next generation reporting data warehouse on Snowflake Cloud DW.
  • Be responsible for designing robust ETL framework with proper triggers and data quality checks in place.
  • Partner with cross-functional teams to understand the business and analytics needs.
  • Work closely with product managers and software engineers to build reporting data architecture that supports new product launch and feature releases.

Necessary qualifications for success:

  • You have 3+ years of experience leading reporting data warehouse design and implementation initiatives, and you understand various data modeling methodologies, relational, dimensional or hybrid
  • You have 3+ years of experience designing and developing enterprise level ETL processes, Matillion preferred
  • You have 3+ years of experience writing, optimizing and validating SQL queries
  • You have excellent communication skills, both written and verbal
  • You are a quick learner and are enthusiastic about introducing and using new technologies/tools to improve the Data Warehouse
  • You are disciplined on using office productivity and collaboration tools
  • Bachelor’s Degree or equivalent in Computer Science, Math, Information Systems Management, or other engineering field

Nice-to-haves (not required):

  • Hands on experience with a BI tool, Tableau preferred
  • Comfortable with Unix/Linux environment
  • Development experience in Python
  • Working experience in the financial industry

About OnDeck:

As the largest online small business lender in the U.S. serving more than 700 different industries, we have been trusted by over 80,000 small businesses by providing them with a term loan or line of credit to help them build growing and thriving enterprises. Since 2007, we’ve issued over $10 billion in capital.

Join us as we enable small businesses to achieve their goals. At OnDeck, we’re reinventing small business financing. We care intensely about each other, our company and the customers we serve, and are committed to making every day count. We are small enough to be nimble and strong enough to make a big impact.

Benefits for you:

OnDeck believes that each and every team member plays an important role in our company’s success. That’s why we strive to provide you and your family with a competitive and comprehensive benefit program with a variety of options and opportunities. We offer:

  • Generous Vacation
  • Comprehensive Healthcare
  • Educational Reimbursement
  • 401k Matching
  • Parental Leave
  • Sports Teams
  • Stocked Kitchens
  • Loan Consolidation 

We are going to ask you to talk about your accomplishments. Here are some of ours:

  • WorldatWork, 2017 Seal of Distinction
  • Fortune 50 Best Workplaces for Diversity, 2016
  • Fortune 50 Best Small and Medium Companies to Work For, 2016
  • Fortune 30 Best Workplaces in Finance and Insurance, 2016
  • Built in Colorado, Top 100 Digital Companies in Colorado, 2015, 2016, 2017
  • Crain’s New York Business Fast 50, 2013, 2014, 2015, 2016, 2017
  • Fortune and Great Place to Work 100 Best Workplaces for Millennials, 2015
  • Fortune/Great Place To Work Great Rated! People’s Picks: 20 Great Workplaces in Financial Services, 2015
  • Crain’s New York Best Places to Work, 2013, 2014, 2015
  • Colorado SHRM Best Companies to Work For in Colorado, 2015
  • Forbes’ America’s Most Promising Companies, 2013, 2014
  • Selling Power Magazine Best Company to Sell For, 2013, 2014, 2015, 2016, 2017
  • 500|5000, 2013, 2014

As part of our dedication to maintaining an inclusive and diverse workforce, OnDeck provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, OnDeck complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

OnDeck expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of OnDeck’s employees to perform their job duties may result in discipline up to and including discharge. 

**No external recruiters or agents, please.**

Read Full Job Description

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • RLanguages
    • SqlLanguages
    • ConfluenceManagement
    • JIRAManagement
    • WordpressCMS
    • SalesforceCRM

Location

A short walk from the Empire State Building and Times Square, our office is located amid the bustle of midtown Manhattan.

What are OnDeck Perks + Benefits

OnDeck Benefits Overview

OnDeck believes that each and every team member plays an important role in our company’s success. That’s why we strive to provide you and your family with a competitive and comprehensive benefit program with a variety of options and opportunities.

Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Employees have the option to set aside pre-tax dollars to pay for eligible Medical, Dental and Vision expenses as well as eligible child care expenses.
Disability Insurance
Our STD plan provides a level of continued income in the event you become disabled and cannot work. Should your disability extend lpast 26 weeks, LTD kicks in at 60% of base monthly earnings.
Dental Benefits
Employees can choose from two dental plans including one that is offered at no cost for employee only coverage.
Vision Benefits
The OnDeck Vision plan provides affordable eye care and discounts to cover routine eye exams, prescription eyeglasses or contact lenses,
Health Insurance Benefits
OnDeck offers employees flexibility to choose from several comprehensive medical plans.
Life Insurance
Our basic life insurance plan is a core benefit provided by the company at no cost to you. You can purchase additional life insurance for yourself, spouse or domestic partner and eligible dependents.
Pet Insurance
You have the option to elect pet insurance which includes coverage for veterinary expenses related to accident and illnesses
Wellness Programs
As an OnDeck employee you have access to additional discounted resources such as weight management programs, massage therapy and more.
Retirement & Stock Options Benefits
401(K)
Our 401(k) plan provides you with an opportunity to invest in your future with the option of contributing pre-tax into your retirement account.
401(K) Matching
OnDeck currently matches 50% up to the first 4% of your deferrals. In 2019, this is changing to 6%.
Employee Stock Purchase Plan
As a member of OnDeck, you will be able to participate in our ESPP and purchase OnDeck stock through payroll deductions at a discounted rate.
Performance Bonus
Annual incentives also referred to as bonuses are based on achievement of personal and company performance targets.
Child Care & Parental Leave Benefits
Generous Parental Leave
OnDeck provides a maximum of 16 weeks combined paid Disability and Parental Leave depending on years of service
Remote Work Program
We are rolling out a formal Remote Work policy in 2019. That said, team member requests to work remote are evaluated based on variety of factors and we currently have approx. 30 remote team members.
Family Medical Leave
Adoption Assistance
OnDeck will reimburse up to $5,000 in expenses related to the adoption of a child under the age of 18.
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Volunteer Time
If team members volunteer during the work day, they are paid for their time.
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
The commuter benefits plan provides you with the opportunity to pay for your commuting costs (mass transit and parking) with pre-tax dollars (up to the IRS maximums).
Company Outings
We have a company party in each office twice a year to celebrate team member and company achievements. This is in addition to department outings and celebrations.
Game Room
In our kitchen, we have a ping pong table where team members can play at their convenience.
Stocked Kitchen
Variety of healthy and delicious snacks including yogurt, cereal, nuts, oatmeal...as well as drinks and coffee.
Happy Hours
Bi-weekly social hour in each office, alternating breakfast and evening to accommodate different team member lifestyles.
Professional Development Benefits
Job Training & Conferences
Each department gets a set budget every year to send their own team members to job training and conferences relevant to their job and development.
Tuition Reimbursement
Team members are eligible to apply for tuition reimbursement for various career and professional development opportunities. Job-related courses will be reimbursed up to $5,250 a year.
Diversity Program
We currently have a Women in Tech ERG and our Culture Committee plans events throughout the year with inclusion in mind - whether a guest speaker or celebrating a heritage month.
More Jobs at OnDeck29 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR
Legal
Marketing
Operations
Project Mgmt
Operations
new
New York
Design + UX
new
New York
Data + Analytics
new
New York
Project Mgmt
new
New York
Marketing
new
New York
Project Mgmt
new
New York
Operations
new
New York
Data + Analytics
new
New York
Data + Analytics
new
New York
Developer
new
New York
Developer
new
New York
Developer
new
New York
Finance
new
New York
Data + Analytics
new
New York
Developer
new
New York
Operations
new
New York
Data + Analytics
new
New York
Project Mgmt
new
New York
Operations
new
New York
Data + Analytics
new
New York