Senior Data Engineer

AiAuto; Parsippany-Troy Hills (NJ); On-site; USD 120,000 - 180,000; Full time

Benefits offered by this job

PTO & Sick Time

Medical, Dental, Vision

401k matching

Life Insurance

On-site cafeteria

Corporate events and team activities

Job summary

AiAuto in Parsippany, NJ is seeking a Senior Data Engineer to design, build, and maintain scalable data architecture and pipelines that power our data-driven initiatives.

You will mentor junior engineers, guide best practices, and collaborate across product, analytics, and DevOps to ensure high performance, reliability, and governance of our data platforms. We value clear communication and hands-on leadership in a fast-growing SaaS environment.

Qualifications

• Minimum 7-10+ years of data engineering experience is required.
• Bachelor's Degree in Data Engineering, Computer Science, Data Analytics or related field is required. Master’s Degree preferred.
• Must live in commutable distance to Parsippany, NJ. We are not considering out of state candidates at this time.
• Must have excellent communication skills both written and verbal in English. Must be able to present data to leadership and collaborate with team members.
• Strong technical coding capabilities.
• Advanced proficiency with SQL, Python, and ETL development are required.
• Python proficiency is required. Must be seen on resume.
• Strong experience with data modeling, data warehousing, and database technologies (e.g. PostgreSQL, Snowflake, Redshift).
• Experience with cloud data platforms (AWS or Azure) and cloud-native data engineering tools.
• Solid understanding of data architecture patterns (batch, streaming, event-driven) and best practices.
• Proven ability to optimize data workflows, troubleshoot complex issues, and ensure high system performance.
• Strong project management capabilities and ability to work independently.
• Excellent communication skills, with the ability to explain complex technical concepts to non-technical stakeholders.
• Must be able to pass a technical coding assessment.

Responsibilities

• Data Architecture, Pipeline Development, and Automation
• Lead the automation of data ingestion from diverse sources (databases, APIs, cloud services) and ensure system reliability and failover readiness.
• Oversee the optimization of data storage, processing, and retrieval for performance, cost-efficiency, and scalability.
• Process Improvement and Technical Leadership
• Identify, evaluate, and implement improvements to legacy systems, ensuring alignment with current and future business demands.
• Research, recommend, and introduce advanced tools, frameworks, and technologies to enhance the data platform.
• Provide technical leadership to the data engineering team, including mentoring, code reviews, and enforcing engineering best practices.
• Data Governance, Integrity, and Quality
• Ensure end-to-end data quality and integrity by establishing and enforcing robust validation, monitoring, and testing protocols.
• Collaborate with cross-functional stakeholders to translate business requirements into well-defined data models and transformations.
• Proactively identify and resolve data inconsistencies, gaps, and errors across systems.
• Cross-functional Collaboration
• Partner closely with data analysts, data scientists, product managers, and business leaders to deliver data products that enable analytics, reporting, and advanced modeling.
• Work with DevOps, software engineering, and IT teams to ensure seamless integration of data systems with enterprise platforms.
• Drive the creation of self-service data tools, dashboards, and reporting solutions that empower business teams.
• Documentation, Knowledge Sharing, and Strategy
• Develop and maintain comprehensive documentation for data models, pipelines, processes, and system architecture.
• Share knowledge and lead training efforts to upskill the team and promote a data-driven culture.
• Contribute to the long-term data strategy, including architecture roadmaps, data governance policies, and compliance initiatives.
• Other Responsibilities
• Perform any other duties assigned by the discretion of management.

Skills

SQL

Python

ETL development

Data modeling

Data warehousing

PostgreSQL

Snowflake

Redshift

AWS

Azure

Batch processing

Streaming data

Event-driven

Data governance

DevOps collaboration

Communication skills

Education

Bachelor's Degree in Data Engineering, Computer Science, Data Analytics or related field

Master’s Degree preferred

Tools

PostgreSQL

Snowflake

Redshift

AWS

Azure

ETL tools

Job description

About AiAuto:

We are challenging the traditional car-buying experience. Gone are the days of consumers spending hours at a dealership, navigating unclear pricing and high-pressure sales tactics. The days of F&I managers who miss family dinners and are unable to attend their children’s games on the weekends are a thing of the past with remote F&I. Instead, we have created an innovative SaaS platform that brings the dealership experience to consumers fingertips wherever they may be. At AiAuto, we are not just another automotive software vendor. We are a group of passionate individuals with decades of automotive and technology experience who have come together with a singular vision: transform how people buy cars. We invite you to experience a new way of engaging with consumers. A way that respects their time, values transparency, and puts them in the driver’s seat of the buying process. We are not just helping dealers sell more cars and F&I products. We are championing a movement to make car buying what it should be: simple, transparent, and enjoyable. Welcome to the future of car buying. Welcome to AiAuto.

Job Summary

The Senior Data Engineer leads the design, development, and maintenance of scalable and secure data architecture, pipelines, and systems to support the company’s data-driven initiatives. This role not only ensures the integrity, performance, and delivery of data solutions but also guides the broader data engineering team, mentors junior engineers, and drives innovation and best practices. The Senior Data Engineer collaborates cross-functionally to align data solutions with strategic business goals and plays a critical role in shaping the company’s data infrastructure roadmap.

Duties/Responsibilities

Data Architecture, Pipeline Development, and Automation

• Design and build robust, scalable, and efficient ETL pipelines that support complex data workflows and meet evolving business needs.
• Lead the automation of data ingestion from diverse sources (databases, APIs, cloud services) and ensure system reliability and failover readiness.
• Oversee the optimization of data storage, processing, and retrieval for performance, cost-efficiency, and scalability.

Process Improvement and Technical Leadership

• Identify, evaluate, and implement improvements to legacy systems, ensuring alignment with current and future business demands.
• Research, recommend, and introduce advanced tools, frameworks, and technologies to enhance the data platform.
• Provide technical leadership to the data engineering team, including mentoring, code reviews, and enforcing engineering best practices.

Data Governance, Integrity, and Quality

• Ensure end-to-end data quality and integrity by establishing and enforcing robust validation, monitoring, and testing protocols.
• Collaborate with cross-functional stakeholders to translate business requirements into well-defined data models and transformations.
• Proactively identify and resolve data inconsistencies, gaps, and errors across systems.

Cross-functional Collaboration

• Partner closely with data analysts, data scientists, product managers, and business leaders to deliver data products that enable analytics, reporting, and advanced modeling.
• Work with DevOps, software engineering, and IT teams to ensure seamless integration of data systems with enterprise platforms.
• Drive the creation of self-service data tools, dashboards, and reporting solutions that empower business teams.

Documentation, Knowledge Sharing, and Strategy

• Develop and maintain comprehensive documentation for data models, pipelines, processes, and system architecture.
• Share knowledge and lead training efforts to upskill the team and promote a data-driven culture.
• Contribute to the long-term data strategy, including architecture roadmaps, data governance policies, and compliance initiatives.

Other Responsibilities

• Perform any other duties assigned by the discretion of management.

Required Skills & Experience

• Minimum of 7-10+ years of data engineering experience is required.
• Bachelor's Degree in Data Engineering, Computer Science, Data Analytics or related field is required. Master’s Degree preferred.
• Must live in commutable distance to Parsippany, NJ. We are not considering out of state candidates at this time.
• Must have excellent communication skills both written and verbal in English. Must be able to present data to leadership and collaborate with team members.
• Strong technical coding capabilities.
• Advanced proficiency with SQL, Python, and ETL development are required.
• Python proficiency is required. Must be seen on resume.
• Strong experience with data modeling, data warehousing, and database technologies (e.g. PostgreSQL, Snowflake, Redshift).
• Experience with cloud data platforms (AWS or Azure) and cloud-native data engineering tools.
• Solid understanding of data architecture patterns (batch, streaming, event-driven) and best practices.
• Proven ability to optimize data workflows, troubleshoot complex issues, and ensure high system performance.
• Strong project management capabilities and ability to work independently.
• Excellent communication skills, with the ability to explain complex technical concepts to non-technical stakeholders.
• Must be able to pass a technical coding assessment.

Physical Requirements

• Prolonged periods of sitting at a desk and working on a computer
• Must be able to lift up to 15 pounds

Come join our growing team here in Parsippany!

• Competitive compensation
• PTO and Sick Time
• Medical, Dental, Vision, 401k matching, Life Insurance, Ancillary Benefits
• Full-service cafeteria on-site serving breakfast & lunch from an exclusive private chef.
• Corporate events, team and culture building activities, employee awards and recognition, company trips and more!

DOWC (and its affiliated brands) is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, protected Veteran status, sexual orientation, gender identity, gender expression, genetic information, or any other characteristic protected by law. Applicants who require accommodation to participate in the job application process may contact us for assistance.