Senior Data Engineer

About Us

Dealer Owned Warranty Company LLC is a leading provider of F&I (Finance and Insurance) partnership services in the automotive industry, offering a full suite of obligor and administrator services, top-of-the-line products, technology, and training. We understand the importance of leveraging process and technology in the F&I industry to drive revenue and ensure success. Our goal is to provide visibility, transparency, and the tools needed for our partners to build their wealth and achieve their goals.

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! As NJ's Best Places to Work Honoree for four years in a row, we offer:

• 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.