Associate Data Engineer at Auto Club Enterprises in Costa Mesa, CA

Job description

• As our Data Engineer, you will function as a consultant between our technology unit and other business units to understand their challenges. You’ll ask questions and present ideas that enable them to solve those data problems with code.
• To thrive in this role, you must understand how to query and process large data sets of 200,000 rows or more, ideally in SQL. You must also have functional knowledge of at least 1 programming language like Python. Be prepared to share an example of how you have worked with multiple tables to develop a solution to a business problem (real or hypothetical for more junior candidates).
• Note: This is a hybrid role; the candidate must reside within a 100-mile radius of our Costa Mesa, CA office and be available to work on-site 3 days a week on a regular basis, as well as 2–3 times per month for team meetings and collaboration days.

Responsibilities

• Every day you will begin with a set of technical specifications to begin coding solutions to issues across the business. Our team’s success isn’t just implementing the code but seeing that those insights are implemented by the business, and they have the necessary tools to accomplish the goal. More senior Data Scientists will write these technical specifications while junior applicants are doing the work to translate specs into functional code.
• Ask questions and do quality testing to understand if the solution meets the objectives of the business or the goal we set for the business. You will work side-by-side with the business to make sure it works as expected, not just as designed.

Requirements

• To thrive in this role, you must have a passion for problem-solving using data. Your experience in querying the high volumes of data and doing the data analysis must inform how you design solutions that align with the business objectives.
• Being proficient with SQL and programming languages such as Python and Spark is a must.
• Experience with data integration from different sources into Big Data systems is preferable.
• Experience quality testing and coding. These solutions will deploy across products that are important to our customers and the business. They must be high-quality and functional.
• A willingness to collaborate. Our best work is done when we work together - either with non-technical or technical leads. You should be interested in learning from others regardless of their role in the organization.
• You have worked previously with an Agile team or understand these concepts. You expect to participate in daily standup meetings, you’ll complete your projects or stories during our sprints, and

Skills

Required

• SQL
• Python
• Spark
• Data querying
• Data processing
• Quality testing
• Coding
• Agile methodology

Benefits

• • Health coverage for medical, dental, vision
• • 401(K) saving plans with company match AND Pension
• • Tuition assistance
• • Floating holidays and PTO for community volunteer programs
• • Paid parental leave
• • Wellness programs
• • Employee discounts (membership, insurance,
• travel, entertainment, services and more!)
• $86,100.00 - $115,000.00
• Additionally, for full time positions, you will be eligible to participate in our incentive program based upon the achievement of organization, team and personal performance.
• .