Avant is looking for a Associate Data Engineer, to play a crucial role in building and evolving our data model to meet a range of business initiatives. This position is suited for someone who is driven to understand complex problems and use technology to build robust solutions. You will work with teams throughout the company understand their operational, regulatory, and reporting needs, and develop a mature model to enable their data-driven decisions.
What you do at Avant:
Model new data sets that can be incorporated into a Databricks and DBT-based platform
Engage with internal stakeholders and users to define clear and well-structured business requirements for our data assets
Support the delivery of data for key customer and operational processes
Build and leverage frameworks for ensuring data assets within Avant’s data platform are high-quality, well-governed, meticulously curated, and operationally well-instrumented
Mentor teammates and be a part of a culture of learning
Why you are a fit for Avant:
Expert-level proficiency with SQL (4+ years experience)
Advanced-level proficiency with data modeling and data structures (3+ years experience)
Advanced-level proficiency data engineering and pipeline automation, preferably working with dbt and Python (3+ years experience)
Advanced-level proficiency with database and query optimization, preferably with Databricks and Postgres (3+ years experience)
Disciplined Agile practitioner
Excellent written and oral communication skills
Must be a self-starter and able to work independently as well as in a team environment
Detail oriented with strong organizational skills
Ability to participate in a support rotation to provide escalation support which may occur outside of business hours
Check out our Avant Blog!
We believe that a diverse set of backgrounds and experiences helps us create the most innovative solutions for our customers. We invite you to apply to our positions even if you do not meet 100% of the qualifications listed in the description. If you’re passionate about our mission and aligned to our values, we hope you’ll come contribute to our awesome culture.
Why Avant is the place for you:
At Avant, we believe our values make a difference:
Authenticity. We show up to work as our whole selves and make sure others can too.
Collaboration. We can only succeed when we do so as a team.
Problem-Solving. The harder the problem, the more satisfying the solution.
Customer. We are all owners of the customer experience.
Initiative. Plan. Adapt. Get Sh!t Done.
We believe that great ideas come from anyone and anywhere, that everyone is an owner who drives change, and that we have more fun when we work together. We’re problem solvers who love collaborating with intelligent and highly-motivated people to reshape the face of digital banking. Avant offers terrific perks and benefits, fun social events with employees who actually like hanging out together, and a flexible growth environment where trying your hand at new projects and being the active owner of your career path is encouraged and supported.
Some of our benefits include:
Choice of great Medical, Dental, and Vision Insurance Plan options
401(k) Match
Unlimited Paid Time Off
Flexible Work Environment
Generous Paid Parental Leave
Lunch Allowance (Fooda) and In-office Snacks
WFH Stipends for our Remote Employees
Access to LinkedIn Learning for Professional Development
No Meeting Wednesdays - (a.k.a. planned time to Get Sh!t Done)
Summer Fridays
Fun In-Office and Virtual Social Events
And who doesn’t love the swag
This position may require you to be fully vaccinated against COVID-19. If required, you’ll be asked to provide proof that you’re fully vaccinated upon your start date or before working in or visiting our Chicago office. You’re considered fully vaccinated two weeks after you receive the second dose of a two-dose vaccine series (e.g., Pfizer or Moderna) or two weeks after a single-dose vaccine (e.g., Johnson & Johnson/Janssen). Failure to provide proof of vaccination may result in termination. Subject to applicable law and requests for accommodation.