What are the responsibilities and job description for the Data Engineer | Performance Management position at Swickard Auto Group?
Description
Corporate Office | Enterprise Analytics | Turning Data into Decisions | Veterans encouraged to apply
Position Overview
This position will support the data analytics and reporting requests of our growing Performance Management team within Swickard Auto Group. The Performance Management team is tasked with delivering insights and analytics that help drive bottom line impact and improve the customer experience across the entire organization. The insights generated through the data work that this position generates and maintains will be critical in the corporate and retail level decision-making process.
The ideal candidate will have advanced Data Engineering skills, an analytical mindset, great attention to detail, ability to manage projects on their own, and craft data solutions that are both expedient and scalable. The candidate must be comfortable working in a small team with limited structure and have an entrepreneurial mindset.
Duties And Responsibilities
Our question is simple: How can we do this better?
Data helps us answer it — every day.
Corporate Office | Enterprise Analytics | Turning Data into Decisions | Veterans encouraged to apply
Position Overview
This position will support the data analytics and reporting requests of our growing Performance Management team within Swickard Auto Group. The Performance Management team is tasked with delivering insights and analytics that help drive bottom line impact and improve the customer experience across the entire organization. The insights generated through the data work that this position generates and maintains will be critical in the corporate and retail level decision-making process.
The ideal candidate will have advanced Data Engineering skills, an analytical mindset, great attention to detail, ability to manage projects on their own, and craft data solutions that are both expedient and scalable. The candidate must be comfortable working in a small team with limited structure and have an entrepreneurial mindset.
Duties And 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.
- 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
- Experience automating processes and data analysis using Python
- Master’s Degree in Data Analytics or similar field
- Aggressive salary based on experience
- Medical, dental, and vision insurance
- Paid time off and holidays
- 401(k) plan
- Career growth opportunities within a fast-scaling organization
- A seat at the table — your work will be used by senior leadership
- Data is central to how we run the business — not an afterthought
- Leaders who value clarity, accountability, and follow-through
- Opportunity to build systems that scale across brands, states, and teams
- A culture that pairs high standards with genuine respect for people
- We were founded in 2014 by Jeff Swickard in Wilsonville, OR.
- We’re a hospitality company that happens to sell cars, parts, and service.
- We are a team. Everyone plays a role in our success.
- Culture: We want to be our customers’ favorite place to purchase, lease, or service their vehicle and we want to be your favorite place to work!
- Highline Brands: Swickard has positioned itself as a leader in highline brands such as Mercedes Benz, BMW, Volvo, Porsche, Lexus, Audi, Land Rover, and more.
- We are consistently ranked as one of the fastest growing dealership groups in the US by Automotive News.
Our question is simple: How can we do this better?
Data helps us answer it — every day.