Data Engineer | Performance Management jobs in United States
cer-icon
Apply on Employer Site
company-logo

Swickard Auto Group · 2 weeks ago

Data Engineer | Performance Management

Swickard Auto Group is a hospitality company that specializes in selling cars and parts, emphasizing the importance of data in their operations. They are seeking a Data Engineer to support their Performance Management team by delivering insights and analytics that enhance decision-making and improve customer experience. The role involves building automated data pipelines, developing data models, and integrating data from multiple systems.

AutomotiveConsumer GoodsSales

Responsibilities

Create and maintain relevant data architecture documentation
Build automated data pipelines using Azure Data Factory, Azure Functions, and Python
Develop and manage Data Vault 2.0 models (Hubs, Links, Satellites) across all dealership domains
Integrate data from multiple systems (APIs, SFTP, webhooks, ERPs, DMS systems) into the enterprise data platform
Create and maintain cloud-based data architecture across bronze, silver, and gold layers
Optimize SQL Server data models and ETL performance, including indexing, stored procedures, and pipeline efficiency
Develop production-quality Python ETL modules for ingestion, cleaning, validation, and transformation
Implement DevOps practices with Git, CI/CD, and YAML-based deployment pipelines

Qualification

Data EngineeringSQLPythonAzure Data FactoryData Vault ModelingCloud Data ArchitectureAPI InfrastructureDevOps PracticesAnalytical SkillsAttention to DetailCommunication Skills

Required

4+ years of related experience in a data engineering role
Bachelor's Degree (accredited school or equivalent technical bootcamp) with emphasis in: Data Engineering, Data Analytics, Mathematics, or Statistics
Proficiency in SQL and Python required; Node.js experience a plus
Experience with Data Vault modeling, Azure Data Factory, Azure Function Apps, and cloud-based ETL preferred
Strong proficiency in SQL
Strong proficiency in Python
Strong proficiency in API Infrastructure
Proficiency in Cloud Data Architecture (Azure Strongly Preferred)
Proficiency in Azure Function Apps and Cloud-based ETL
Strong experience in Data Vault Modeling
Strong experience in Azure Data Factory
Experience developing and maintaining API, webhook, and SFTP integrations in Python
Experience with YAML based DevOps pipeline management
Experience designing enterprise-grade database architecture
Strong attention to detail and a high degree of accuracy
Ability to communicate well both verbally and in writing with all levels of the organization
Strong analytical skills
Solid understanding of data sources, data organization and storage

Preferred

Experience automating processes and data analysis using Python
Master's Degree in Data Analytics or similar field

Benefits

Medical, dental, and vision insurance
Paid time off and holidays
401(k) plan

Company

Swickard Auto Group

twittertwitter
company-logo
Swickard Auto Group is a car dealership that provides sales services for new as well as preowned cars, and car services.