Job Details

ALLDATA is the industry's #1 choice for unedited OEM automotive repair and collision information. Founded in 1986, the Elk Grove, California-based company has more than 115,000 subscribers worldwide who rely on us for access to the OEM-accurate information and procedures they need for safe and accurate repairs. More than 400,000 technicians trust ALLDATA's industry-leading software solutions for faster diagnostics, updated OEM information covering 95% of vehicles on the road today, and simpler shop management. With the support of our parent company, AutoZone, we are an employer of choice for those who are passionate about working for a leader in the automotive software industry.

Position Summary

The Lead Software Engineer, specializing in database analysis and modeling, will be an experienced technical generalist familiar with a wide assortment of leading database technologies and methods. The qualified candidate must possess a thorough understanding of advanced database concepts including data modeling, relational DBMSs, SQL programming, with a working knowledge of web services, e-commerce systems, data warehouses, and operational data stores. In this role you will work independently with limited supervision and with other department personnel; this is an individual contributor position with no direct reports.

Position Responsibilities

• Create the architecture, design, and implementation of database schema for systems underlying interactive web and mobile apps being developed in-house by ALLDATA for our tens of thousands of subscribers.
• Data Analysis: working with Product Owners, BSAs, API developers, QA testers, and DBAs to extrapolate logical and physical data requirements from systems design documents that are frequently system behavior-focused (such as wireframes), taking them through from inception to production release and ongoing maintenance.
• Data Modeling: applying logical and physical data modeling best practices and concepts, often leading the logical data design in new systems; primarily working with traditional OLTP systems but also able to work in data warehouse OLAP systems and cloud-based, non-structured data systems.
• Define the development tasks and estimates for completion (including story writing).
• Work with the testing team and API developers to refine and validate the implementation.
• Participate in the scrum team ceremonies: stand-up, planning, grooming, demo, retro.

Position Requirements

• B.S. in Computer Science.
• 5-10 years working in a database environment designing.
• Understanding of the data modeling concepts like Star Schema, Snowflake Schema.
• Experience with Agile methodologies, working inside one or more scrum teams.
• Experience in creating data models in cloud environments like GCP, AWS.
• Experience in migrating on-premise ETLs to GCP using cloud-native tools like BigQuery.
• Experience in building and/or working with data marts.
• High competency in entity-relationship analysis from requirements to diagramming.
• Demonstrable experience designing and refactoring large database schemas over time.
• Knowledge and application of normalization and denormalization strategies.
• Able to follow and promote source code control best practices in SVN, GitHub, or similar.
• Programming languages such as PSQL, Java, Python, .NET/C#.
• Exceptional communication, organization, and time management skills.
• Strong analytical problem-solving skills with a high attention to detail.
• Track record as a self-starter, results-oriented, and delivery-focused contributor.

Salary: $107,000 - $187,000 Compensation Range (USD): MIN 107000.0 - MID 147100.0 - MAX 187000.0