IT Automation Engineer

Fort Morgan, CO; Littleton (CO); On-site; USD 80,000 - 135,000; Full time

Benefits offered by this job

401k / 401k matching

Medical / Dental / Vision Insurance

Employee Assistance Program (EAP) -免费

PTO Accrual

Health Savings Account

Flexible Spending Account

Voluntary Life and AD&D

Employee Discounted Pricing on Parts,

Vehicles, and Service

Job summary

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

Ideal candidate will design and maintain automation, integrations, and reporting while transitioning ownership from external partners to internal IT resources.

Qualifications

• Strong SQL skills for queries, procedures, and data modelling.
• Experience building internal apps, reporting platforms, or frontends.
• Experience with APIs, JSON, and system integrations.
• Automation tooling experience using Power Automate or similar.
• Experience with ETL or data pipelines and data governance.

Responsibilities

• Own and support the organization's reporting platform including internal SQL databases and ETL processes.
• Design, develop, deploy, and maintain automations and integrations using Power Platform and APIs.
• Develop and optimize SQL solutions and data models for performance and integrity.
• Build and enhance Power BI reporting with semantic models and dashboards.
• Collaborate with leaders to identify pain points and deliver tech solutions.
• Monitor, troubleshoot, and improve reporting systems and data pipelines.

Skills

SQL skills

APIs

JSON

System integrations

Power Automate

Power Platform

Automation governance

Analytical thinking

Troubleshooting

Stakeholder communication

Tools

Power BI

Power Apps

Azure SQL

Azure Data Factory

Dataverse

Microsoft Copilot

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

9 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, develop, deploy, and maintain business automations and system integrations using Power Platform, APIs, SQL, Python, Microsoft Copilot, and other automation technologies.
• Develop and optimize SQL solutions, including queries, stored procedures, views, and data models, while ensuring data integrity, accuracy, and system performance.
• Build, maintain, and enhance Power BI reporting solutions, including semantic models, dashboards, report distribution, and role‑based security.
• Partner with business leaders to analyze workflows, identify inefficiencies, and deliver technology solutions that streamline operations, reduce manual effort, and improve business processes.
• Monitor, troubleshoot, and continuously improve reporting systems, integrations, data pipelines, and automation workflows to ensure reliability and operational continuity.
• Establish and maintain documentation, governance standards, security controls, and best practices for reporting, automation, and data management solutions.
• Research, evaluate, and implement emerging technologies, AI capabilities, and Microsoft ecosystem tools to drive innovation and improve organizational efficiency.

What We Offer:

• Competitive 401k / 401k matching
• Medical / Dental / Vision Insurance
• Employee Assistance Program (EAP) - free, confidential counseling
• PTO Accrual
• Health Savings Account
• Flexible Spending Account
• Voluntary Life and AD&D
• Employee Discounted Pricing on Parts, Vehicles, and Service

What Makes Us Different?

For more than 65 years, McDonald Automotive has been one of Colorado's most respected family‑owned dealership groups. Built on the values of Respect, Integrity, Growth, Hard Work, and Trust, we believe success comes from doing the right thing — for our customers, our employees, and our community.

We invest heavily in our people because we know great careers are built through mentorship, training, leadership development, and opportunity. Many of our employees have spent decades growing their careers here, advancing into leadership and management positions while helping us set the standard for what great service looks like in our industry.

This position will remain open for at least three days and will close upon candidate selection.

If you are an individual with a disability and need a reasonable accommodation to assist with your application for employment or the recruiting process, please contact us by sending an email to [e-mail] .