Swickard Auto Group · 13 hours ago
Data Engineer | Performance Management
Swickard Auto Group is a hospitality company that specializes in selling cars, parts, and services. They are seeking a Data Engineer to support the Performance Management team by delivering insights and analytics that drive bottom line impact and improve customer experience across the organization.
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
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
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 with Data Vault modeling, Azure Data Factory, Azure Function Apps, and cloud-based ETL 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
Swickard Auto Group is a car dealership that provides sales services for new as well as preowned cars, and car services.
Funding
Current Stage
Late StageRecent News
2025-09-25
2025-09-25
Company data provided by crunchbase