Data Engineer III

Exeter Finance; Irving (TX); Hybrid; USD 99,000 - 137,000; Full time

Job summary

A leading finance company is seeking a Data Engineer III to design and optimize data systems that support analytics and business intelligence. This hybrid role involves collaboration and requires expertise in SQL, cloud technologies, and data processing. Join a positive work environment focused on innovation and teamwork.

Qualifications

• 4-6 years of job-related experience.
• High proficiency in Microsoft Transact-SQL.

Responsibilities

• Design, develop, and maintain scalable data processes for ETL/ELT.
• Integrate data from various sources including APIs and files.
• Implement complex data architectures like data warehouses.

Skills

Analytical Skills

Problem Solving

Communication

Education

Bachelor's Degree in Computer Science

Tools

Microsoft SQL Server

PowerShell

Python

Job description

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.

Job Summary

A Data Engineer III is responsible for designing, building, and optimizing complex data systems and automated data processing solutions that support the organization’s data analytics and business intelligence needs. The Data Engineer III implements and maintains operational and analytical databases and data processes. They identify data sources, define source-to-target mappings, and design and build databases as well as ETL/ELT data loads. They also adhere to standards and design/coding principles when implementing robust solutions.

The role targets solutions by executing business logic to process data in support of operational and reporting needs, as well as moving data between internal and external systems as required. The day to day execution of the position includes developing and maintaining batch jobs and schedules, stored procedures, data pipelines, and scripts. The Data Engineer III utilizes multiple technologies, including Microsoft SQL Server, Microsoft Azure, EventHub, Stream Analytics, SnapLogic, ActiveBatch, T-SQL, PowerShell, and Python.

Job Duties

• Design, develop, and maintain scalable data processes that support ETL/ELT loads of multiple sources of data into data warehouses, data lakes and transactional databases.
• Ensure batch jobs and data processes are efficient, reliable, and meet performance requirements.
• Integrate data from various sources, including internal systems, external APIs, files, streaming and third-party services.
• Implement 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.
• Review 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, understanding how to efficiently process large data sets using appropriate storage options.
• Implement advanced optimization techniques, such as indexing, partitioning, and query tuning, to ensure high performance and reliability of data systems.
• Implements database solutions and ensures quality assurance and timely delivery of data.
• 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.
• Participates in 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.
• Ensures compliance with Exeter’s policies & procedures, safety, state and federal laws, regulations and standards.
• Other duties as assigned.

Experience

• Bachelor's Degree or equivalent in Computer Science or a related field of study.
• 4-6 years of job-related experience. 4+ years of job-related experience preferred.
• High level of proficiency in Microsoft Transact-SQL required with programming/scripting in PowerShell, C#, Python, etc.
• Knowledge of databases and development and design methodology required.
• Knowledge and experience with cloud technologies, data lakes, and data ingest and pipeline technologies a plus.
• Experience with data engineering tools and platforms for ETL, data processing, and data integration a plus.
• 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.

99,500.00 USD-$136,850.00