Data Engineer

 
We are OppLoans
 
Growth with a Purpose 
OppLoans is a growing FinTech company that provides accessible and simple-to-understand lending products for middle-income consumers with five-star customer service. We’re growing fast with profitable returns, and new employees can make an immediate impact.
 
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. We are looking for engineers who are excited by the chance to challenge the FinTech status quo. 

What you get to do:
Data Engineer is a customer-facing position that helps to design database solutions to meet our needs; support architecture, design, ETL, and database administration tasks for both OLTP systems and data warehouses, administration of cloud-based BI system.
  • Design and implement data warehouse or data mart fact tables, aggregate tables, and dimensions. Provide quality data integration projects, best practices, and data dictionary. 
  • Develop and document audits and controls to ensure the data meets standards and thresholds.
  • Support and refine internal Business Intelligence and Data Warehouse environments.

What you will bring to the team:
  • Experience with PostgreSQL in AWS with details like users, start and end time, CPU Usage and time, Memory usage, IO Time, locking etc.
  • Implement automated methods and industry best practices for installation and configuration of PostgreSQL for production and non-production environments.
  • Conduct technical reviews and walk through of system design documentation with development team members.
  • Manage backup and recovery functions for a PostgreSQL data warehouse environment.
  • Resolve incidents and address user problems/concerns.
  • Fluency in at least one scripting language such as Ruby, Perl, or Bash. Experience in JavaScript or AWS Redshift are desired.
  • SQL expertise.
  • A Bachelor's Degree or equivalent experience
 
  
Why OppLoans?
 
Employees Love Working Here
With a dynamic startup culture and great benefits, we’ve attracted top talent and boast one of the most engaged offices in the country. In 2019, we were named the 4th fastest growing company in Chicago by Crain’s Chicago Business and celebrated our fourth straight year on the Inc. 500. We’ve been named one of the best companies to work for in the nation by Glassdoor two years in a row. Check out our Glassdoor reviews to see why our employees love us!
 
Customers love our product
OppLoans is committed to delivering an outstanding experience to our customers. Don’t believe us? See what our customers are saying on Google and the BBB! We were also named a number one personal lender by Lending Tree, and a “Leader in Quality and Innovation” by the Center for Financial Services Innovation=. 
 
Benefits
We offer a great compensation package and benefits package to support you inside and outside of work as you define your career with us. Some of these benefits include a 401(k) matching program, paid vacation policy, free PPO medical option with BCBS for Employee Only Plans, dental, vision, and accident coverage, free gym membership, discounted Divvy memberships & ClassPass fitness classes, CTA and Metra benefit programs, casual dress policy, subsidized daily lunches, a stocked kitchen with healthy snacks and drinks, an employee and peer recognition program, and intramural sports leagues. 
 
Our office is conveniently located in downtown Chicago with panoramic views of Millennium Park and Lake Michigan with rooftop access. 
 
 
 
OppLoans is an equal opportunity employer. OppLoans does not discriminate against any applicant for employment due to age, color, sex, disability, national origin, race, religion, veteran status, or any other protected class.

 

Want to apply later?

Type your email address below to receive a reminder

Apply to Job

ErrorRequired field
ErrorRequired field
ErrorRequired field
Error
Error
insert_drive_file
insert_drive_file
ErrorRequired field
Error
ErrorRequired field
ErrorRequired field
ErrorRequired field
Error
Error