Associate, Data Engineer

Avant - Chicago, IL

Full-time - Entry Level

Remote - Chicago, IL

Credit Intermediation and Related Activities

About the position

Avant is looking for an 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 to understand their operational, regulatory, and reporting needs, and develop a mature model to enable their data-driven decisions.

Responsibilities

• 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

Requirements

• Expert-level proficiency with SQL (4+ years experience)
• Advanced-level proficiency with data modeling and data structures (3+ years experience)
• Advanced-level proficiency in 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

Benefits

• 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