Avant is revolutionizing the world of lending by lowering the costs and barriers of borrowing for everyday people. At our core, we are a technology company that builds advanced platforms and uses custom analytics. Today, we help underserved consumers, the majority of whom get fast funding on our online platform without having to talk anyone. Tomorrow we plan to use our world class technology and underwriting capabilities to launch new products and bank partnerships that improve people’s financial lives.
Job Description
Avant is looking for an ETL Engineer to join it’s Data Services team. As an ETL engineer, you will work closely with Data Management and business teams to design and build end-to-end data pipelines in our Hadoop Data Lake.
Are you passionate about managing data at scale? Do you want to contribute to building a robust data lake? Then this may be the role for you.
Responsibilities:
- Design, architect, implement, and document new, scalable data pipelines
- Conduct ETL and ad hoc query performance tuning, monitoring, troubleshooting, and support
- Audit and QA data and processes to ensure data quality and integrity throughout the data pipeline
- Support existing data pipelines
Minimum Qualifications:
- 2+ years developing data pipeline in the data warehouse space
- 2+ years experience working in a Hadoop or other MPP environment
- Proficiency with a dynamic scripting language (Python, Ruby, etc)Advanced knowledge of SQL
- Strong attention to detail
- Ability to communicate with analysts and business users across the company
Preferred Qualifications:
- Experience with Amazon Web Services ecosystem (EC2, S3, RDS)
- Experience with workflow tools such as Airflow, Oozie, or Luigi
- Experience with Dimensional Modeling
- Experience with Business Intelligence tools (Looker, Tableau, Qlikview, Microstrategy, etc)
Why Avant is a fit for you: At Avant, we believe our values make a difference:We value, support, and help each other growWe are committed to active inclusion and diversityWe are transparent and believe the best idea winsWe succeed when our customers succeedWe get sh!t done… responsiblyAnd we keep it fun! We believe that ideas are more important than titles, everything is more fun together, everyone drives change, and everyone is an owner. While we believe the perks and benefits that we offer are terrific, nothing excites us more than having the ability to collaborate with intelligent, highly-motivated and talented people on challenging problems as we work to change the face of online lending.