OppLoans is a rapidly growing Fintech company that helps credit-challenged consumers build a better financial path through accessible products and five-star customer service. As one of Chicago's fastest-growing startups, we've made the Crain's Business Chicago Fast 50 (#4 in 2019) and the Deloitte Technology Fast 500 (twice), and we've ranked in the top 10% of the Inc. 500 four years in a row!
OppLoans is a team of caring and inventive "Opptimists" with diverse perspectives and backgrounds. OppLoans employees approach every new challenge with an unparalleled ability to see what could be rather than settle for what is. We want people to be excited to come to work every morning and know they are a part of something great. That's why we prize collaboration, collegiality, and letting the best ideas win the day.
Data Engineers are integral members of the Database team who work with internal stakeholders to design database solutions to meet our reporting, analytics and data science needs. Our team supports architecture, design, ETL, and database administration tasks for both OLTP systems (PostgreSQL) and data warehouses (Snowflake).
Reporting to the Manager of Site Reliability and Database Engineering, you will:
Use Apache Airflow and Snowflake to make several layers of OppLoans data available for reporting, Data Science and analytics
Develop and document audits and controls to ensure the data meets quality standards and alerts the team when thresholds are breached
Support and refine internal Business Intelligence and Data Warehouse environments.
Collaborate closely with development teams to build data integrations for our applications and services
Collaborate closely with internal teams to implement data integrations with external products and partners
Operate in close partnership with the site reliability engineering team to develop and maintain database and ETL infrastructure
Contribute energy and opinions to the database team
Participate in the hiring process for technology candidates within a well-defined process
4+ years of experience of related data engineering experience working in an engineering team
Substantial SQL experience (required)
Scripting proficiency in Python, Ruby, or R (required)
Strong collaboration skills
A strong sense of customer service and empathy
Experience with Airflow, AWS, Linux, Snowflake, and PostgreSQL strongly preferred
Experience with containerization technologies and CI/CD tools a plus
OppLoans is committed to providing an exceptional employee experience that allows you to define your career and purpose with us. New hire "Opptimists" go through orientation, shadow programs, a new hire lunch with our CEO, Jared Kaplan, and you can participate in different company culture events focused on diversity, equity, and inclusion. Our onboarding team has designed programs to make you feel welcome and part of our team during your first year and beyond.
Define the Mission (days 1-30): You will understand our company mission, values, and vision, and how your role at OppLoans plays a part in that.
Define your Goals (months 1-3): You will be able to understand your role expectations and identify goals with your manager and mentor(s) to fulfill those expectations.
Define your Belonging (months 3-6): You will understand OppLoans' culture and have opportunities to engage with and impact that culture. Employee-led communities and programs, like our wellness program Project Opptimism, are offered to help with community connection both virtually and in-person.
Define your Journey (6 months - 1 year): You will feel confident in your abilities to execute in your role and know the next step you will take to develop your career.
OppLoans offers a 401(k) matching program and paid vacation. Other benefits include medical benefits, including a free PPO medical option with BCBS for Employee-Only Plans, dental and vision coverage, and tuition reimbursement. To support your wellness, you receive a free gym membership at One Two Pru and a corporate discount on ClassPass packages. To get you to and from work, you can participate in our pre-tax commuter benefits program with CTA and Metra, park your bike in the One Two Pru bike storage room, and take advantage of discounted Divvy memberships. Dresscode is casual. Lunch is subsidized through Fooda and Sweetgreen, and healthy snacks and drinks are available all day at the office.
Our office is conveniently located in downtown Chicago with panoramic views of Millennium Park and Lake Michigan with rooftop access.