Senior Data Engineer (SQL/Azure)

About the position

At Exeter Finance, we are committed to helping customers find the right financing for their next vehicle purchase. By building strong relationships with our customers and network of dealer partners we are able to give options that make sense, getting customers behind the wheel of their car. Every team member is integral to our success. Whether you’re at a servicing center helping customers with their loans, in the field building relationships with dealers, or supporting the company from its corporate offices, you'll enjoy a nurturing, invigorating and positive work environment. Our vision is to be a premier finance company and lender of choice known for its People, Performance and Service. This position is hybrid and will be required to be in office two times per month for collaboration working sessions. A Senior Data Engineer takes a lead role in the design and development of optimized and robust automated data processing solutions, while mentoring junior team members and driving innovation. This role involves developing complex data engineering projects, ensuring the efficient management and processing of data, and collaborating with cross-functional teams to support data-driven decision-making.

Responsibilities

• Lead the design and implementation of complex data architectures inclusive of data warehouses, data lakes, and real-time data processing systems.
• Ensure batch jobs and data processes are efficient, reliable, and meet performance requirements.
• Implement relational and massively parallel database solutions ensuring quality assurance and timely delivery of data.
• Design, develop, and own scalable data processes that support ETL/ELT loads of various data sources.
• Implement data models and integration frameworks that align with organizational requirements.
• Investigate, troubleshoot and correct data and user related system errors, and ensure data integrity.
• Develop and maintain documentation for batch jobs including database and ETL/ELT.
• Participate in the On-call developer rotation and respond to batch failures and alerts.
• Contribute to support an IT roadmap that is forward thinking.
• Participate in project team standups and report status updates.
• Ensure compliance with Exeter’s policies & procedures, safety, state and federal laws, regulations and standards.
• Other duties as assigned.

Requirements

• Minimum of 6 years of job-related experience required.
• Bachelor's Degree or equivalent in Computer Science or a related field of study preferred.
• Expert level Microsoft Transact-SQL required.
• Programming/scripting experience in languages such as PowerShell, C#, Python, etc.
• Strong knowledge of design, development, and implementation of OLTP database and data warehouse methodologies.
• Proven experience implementing data engineering projects and providing technical guidance within a large or complex organization.
• Detail-oriented with strong analytical and problem-solving skills.
• Strong verbal and written communication skills.

Nice-to-haves

• Knowledge and experience with a variety of cloud technologies, data lakes, data ingestion and data pipeline technologies.
• Familiarity with data engineering tools and platforms for ETL/ELT, data processing, and data integration.
• Familiarity with data lake architectures, big data technologies, real-time data processing technologies, and enterprise jobs schedulers.
• Familiarity with the auto finance industry.

Benefits

• Individually tailored compensation packages with competitive salary and benefits.
• Training and development opportunities.
• Team member recognition and awards.