Senior Database Developer

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.

Job Description

This position is hybrid and will be required to be in office two times per month for collaboration working sessions.

As a Senior Data Engineer, you will lead the design and development of optimized and robust automated data processing solutions. This role involves overseeing complex data engineering projects, ensuring efficient data management and processing, and collaborating with cross-functional teams to support data-driven decision-making. You will leverage deep technical expertise to deliver high-quality data solutions, mentor junior team members, and drive innovation in data engineering practices. This role is ideal for someone who excels in technical leadership, enjoys mentoring, and is passionate about advancing data engineering practices.

Your responsibilities include implementing and maintaining operational and analytics databases and data pipelines. You will identify data sources, define source-to-target mappings, and design and build databases and ETL/ELT data loads. By adhering to standards and design/coding principles, you will implement robust solutions that involve executing business logic to process data in support of operations and reporting needs, as well as moving data between internal and external systems as needed. Additionally, you will develop and maintain batch jobs and schedules, stored procedures, data pipelines, and scripting.

Technologies: Microsoft SQL Server, Microsoft Azure, EventHub, Stream Analytics, SnapLogic, ActiveBatch, T-SQL, PowerShell, and Python.

Job Duties

• Design, develop, and maintain scalable data pipelines that support ETL/ELT loads of multiple sources of data into data warehouses, data lakes and transactional databases. 

• Ensure batch jobs and data pipelines are efficient, reliable, and meet performance requirements. 

• Integrate data from various sources, including internal systems, external APIs and files, streaming and third-party services.  

• Lead the design and implementation of complex data architectures, including data warehouses, data lakes, and real-time data processing systems. Develop data models and integration frameworks that align with organizational requirements. 

• Provide technical leadership and mentorship to junior data engineers and team members. 

• Review and approve technical designs, code, and implementations to ensure adherence to best practices and high-quality standards.

• Participates in project team standups and reports status updates.

• Implement solutions using relational and massively parallel databases. 

• Implement advanced optimization techniques, such as indexing, partitioning, and query tuning, to ensure high performance and reliability of data systems.

• Participates in project team standups and reports status updates.

• Implements database solutions and ensures quality assurance and timely delivery of data. 

• Understands how to efficiently process large data sets using appropriate storage options.

• Investigates, troubleshoots and corrects data and user related system errors, and ensures data integrity. 

• Implement and enforce data quality standards and validation processes into solutions. 

• Develop and maintain documentation for batch jobs including database and ETL/ELT. 

• As part of the Oncall developer rotation respond to batch failures and alerts by trouble shooting and advising data operations team to resolve failures. 

• Contributes to support an IT roadmap that is forward thinking and sets the groundwork for reducing maintenance cost while meeting or exceeding business objectives.

• Promotes a constructive, positive team environment and maintains a spirit of openness, information sharing inquisitiveness, problem-solving and support for common goals. 

• Collaborates with cross-functional teams and has significant ownership of projects.

• Ensures compliance with Exeter’s policies & procedures, safety, state and federal laws, regulations and standards.

• Other duties as assigned.

Experience/Education

• Bachelor's Degree or equivalent in Computer Science or a related field of study.

• 6-8 years of job related experience required.  

• Expertise in Microsoft Transact-SQL required along with programming/scripting Powershell, C#, Python, etc.  

• Knowledge of databases and development and design methodology required. 

• Knowledge and experience with cloud technologies, data lakes, data ingest and pipeline technologies a plus. 

• Requires experience with data engineering tools and platforms for ETL, data processing, and data integration. 

• Requires experience leading data engineering projects and providing technical guidance within a large or complex organization. 

• Requires knowledge of implementing data warehousing solutions.

• Familiarity with data lake architectures, and real-time data processing technologies.

• Familiarity with cloud-based data services and big data technologies a plus. Familiarity with enterprise job schedulers a plus.

• Familiarity with the auto finance industry a plus. Strong analytical and problem-solving skills, with the ability to troubleshoot and resolve complex data issues.

• Good communication skills, with the ability to collaborate effectively with data scientists, analysts, and other team members.

• Detail-oriented with a focus on data accuracy, quality, and performance in a large database environment.

#LI-Hybrid

Exeter Finance LLC is an Equal Opportunity Employer.

Individual compensation packages are based on various factors unique to each candidate including

skill set, experience, qualifications and other job-related reasons.

109,400.00 USD-$150,350.00