IT Automation Engineer (In Person)

Mcdonald Automotive; Littleton (CO); On-site; USD 80,000 - 135,000; Full time

Job summary

McDonald Automotive in Littleton, CO is seeking an IT Automation Engineer to develop, support, and expand automation, reporting, and data integration across Accounting, Payroll, Sales, Service, Parts, and Corporate Operations. The role blends automation engineering with data management and process improvement.

You will design and maintain automation, integrations, and reporting while transitioning ownership of critical platforms from external partners to internal IT, delivering scalable

Qualifications

• Strong SQL skills with querying and maintaining relational databases.
• Experience building or supporting internal business applications, reporting platforms, or database frontends.
• Experience with APIs, JSON, and system integrations.
• Automation tooling using Power Automate, Power Platform, Python, VBA, or similar.
• Experience building or supporting ETL or data pipeline processes.
• Track record of automating manual processes and integrating systems.
• Strong analytical, troubleshooting, and problem-solving skills.
• Ability to work with non-technical business users to understand requirements and deliver solutions.
• Strong organizational and documentation skills.

Responsibilities

• Own and support the organization's reporting platform, including internal SQL databases, ETL processes, reporting datasets, frontend applications, and technologies transitioned from external support partners.
• Design scalable automation and reporting solutions to meet business needs.

Skills

Strong SQL skills

Analytical and problem-solving

Documentation skills

Ability to work with non-technical业务

Tools

Azure SQL

Azure Data Factory

Azure Storage

Dataverse

Power BI

Power Apps

Power Automate

APIs

JSON

ETL/Data pipeline tools

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

IT Automation Engineer

Professional Littleton, CO, US

3 days ago Requisition ID: 4559

Salary Range: $80,000.00 To $135,000.00 Annually

McDonald Automotive is seeking an IT Automation Engineer to develop, support, and expand business automation, reporting, and data integration solutions across Accounting, Payroll, Sales, Service, Parts, and Corporate Operations.

This role combines automation engineering, reporting, data management, and business process improvement. The ideal candidate will design and maintain automation, integrations, and reporting solutions while helping transition ownership of critical reporting and analytics platforms from external support partners to internal IT resources. This is a high-impact position focused on eliminating manual work, improving data accuracy, increasing efficiency, and creating scalable solutions that support long-term business growth.

Compensation Overview:

$80,000 - $135,000 per year, commensurate with experience.

About You:

• Experience with Azure SQL, Azure Data Factory, Azure Storage, Dataverse, or similar cloud data technologies.
• Experience with Power BI, Power Apps, and enterprise reporting platforms.
• Experience supporting data warehouse or business intelligence environments.
• Experience in automotive retail or with dealership systems.
• Familiarity with Microsoft 365, Copilot, and AI-assisted workflow design.
• Experience with RPA platforms such as Power Automate.
• Familiarity with source control, change management, and automation governance practices.

Experience & Qualifications Needed:

• Strong SQL skills, including querying, writing, and maintaining relational databases.
• Experience building or supporting internal business applications, reporting platforms, or database frontends.
• Experience with APIs, JSON, and system integrations.
• Scripting and processing automation experience using technologies such as Power Automate, Power Platform, Python, VBA, or similar automation tools.
• Experience building or supporting ETL or data pipeline processes.
• Proven track record of automating manual business processes and integrating systems.
• Strong analytical, troubleshooting, and problem-solving skills.
• Ability to work directly with non-technical business users to understand requirements and deliver solutions.
• Strong organizational and documentation skills.

Essential Duties and Major Responsibilities:

• Own and support the organization's reporting platform, including internal SQL databases, ETL processes, reporting datasets, frontend applications, and technologies transitioned from external support partners.
• Design