Software Engineer II
Description
Senior Software Engineer (ETL & Data Engineering)
We are seeking a skilled Data Engineer specializing in ETL processes and data lake integration. This role supports our digital catalog data operations and expands into our data lake engineering initiatives. The ideal candidate has a strong background in SQL, ETL tools, AWS data technologies, and data analytics platforms. This is a unique opportunity to be part of a fast-growing SaaS product company and work on the enterprise's critical applications and operations.
Here is more of what you’ll get to do:
- ETL & Data Processing Support:
- Extract, transform, and load data from various external formats into internal databases (SQL Server, Oracle).
- Develop, maintain, and optimize stored procedures and ETL workflows supporting data synchronization, validation, and reporting.
- Collaborate with catalog data teams to manage ACES & PIES database updates, ensuring data accuracy and completeness.
- Troubleshoot data synchronization and integration issues, identifying root causes and implementing solutions.
- Data Lake Integration (AWS Focus):
- Design and develop data pipelines for loading structured and semi-structured data into AWS data lakes.
- Utilize AWS services such as S3, Athena, Glue, and Lambda for data processing.
- Develop and maintain ETL scripts using Python.
- Implement version control using Git for source management.
- Data Analysis and Reporting:
- Build and support reports using SQL Server Reporting Services (SSRS), Power BI, and Tableau.
- Perform data validation checks to ensure report accuracy and data completeness.
- Collaborate with business teams to define data quality metrics and resolve discrepancies.
- Collaboration & Continuous Improvement:
- Work closely with cross-functional teams, including data catalog, business analysts, and IT support.
- Stay up-to-date with emerging data technologies and best practices in ETL and data lake management.
- Document processes, workflows, and best practices for knowledge sharing and future reference.
You’ll thrive in this role if you have:
- Bachelor’s degree in Computer Science, Information Systems, or a related field.
- 5+ years of experience in ETL development, data processing, and database management.
- Advanced SQL skills, including stored procedure development and performance tuning.
- Proficiency in Python for ETL scripting.
- Experience with AWS services (S3, Athena, Glue, Lambda) and Git.
- Strong analytical skills with experience in data validation and reporting using Power BI, Tableau, or similar tools.
- Excellent English communication skills, both written and verbal.
- Ability to work independently and in team settings.
- Able to collaborate directly with overseas colleagues and stakeholders in different time zones.
- Flexibility in work schedules, including availability for meetings with overseas colleagues in the evening/night or early morning.
- A pleasant and patient demeanor. A positive individual who can handle pressure well. We expect employees to make personal decisions to strive for something beyond the status quo.
Nice to have qualifications:
- Familiarity with ACES & PIES data standards.
- Experience in data governance and data quality management.
- Previous experience in the automotive or digital catalog data domain.
Does this position sound like something you would enjoy and be successful at, but you’re not sure you have the exact qualifications to be considered? While our job descriptions are an outline for the type of candidate we’re looking for, it is not a checklist. We encourage you to apply!
Who we are:
LeadVenture is the market-leading SaaS provider of digital retailing, eCommerce, digital marketing and eCatalog solutions for dealerships across 12 industry verticals including powersports, marine, RV, pre-owned auto, agriculture and more. Our family of brands includes Dealer Spike, Dealer Car Search, Frazer, Net Driven, Direct Communications, Inc. (DCi), Powersports Support, Level 5, PSM Marketing, Monroney Labels, and Interact RV. We are an international company with offices located in the United States, Mexico (Juniper Data Center), Belize (Dealer Spike Belize), India and The Netherlands. Together, we are LeadVenture.
LeadVenture provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, LeadVenture complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, transfer, leaves of absence, compensation, and training.
LeadVenture expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of LeadVenture employees to perform their job duties may result in discipline up to and including discharge.
LeadVenture expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of LeadVenture employees to perform their job duties may result in discipline up to and including discharge.