DMS Automation & API Integration Specialist

Model1 Commercial Vehicles, Inc.; Indianapolis (IN); On-site; USD 90,000 - 110,000; Full time

Benefits offered by this job

Health insurance

Paid holidays and vacation

Continuous training

Mentors and networking

Top quality technology

Job summary

Model 1 Commercial Vehicles, Inc. seeks a skilled developer to support the dealership management system (DMS) team. You will build automations, integrations, and reports that keep service, parts, and sales operations running smoothly, and transition Excel VBA tools to modern web applications.

You’ll migrate data access to APIs while leveraging AI-assisted tools in daily work. You will collaborate with the Sr.

Qualifications

• 2–4+ years of hands-on SQL Server / T-SQL development, including views, stored procedures, and complex logic.
• Working proficiency in Python for scripting and automation.
• Experience building web applications, including working with REST APIs.
• Ability to read and understand existing VBA code well enough to reverse-engineer its behavior.
• Strong debugging habits and a methodical approach to testing changes incrementally.
• Ability to explain technical reasoning clearly to both technical and non-technical colleagues.
• Experience with challenging real-world data (CSV exports, legacy schemas).

Responsibilities

• Develop, test, and maintain T-SQL views, stored procedures, and scheduled jobs that automate DMS workflows.
• Analyze existing Excel VBA tools to document their logic, data sources, and business rules, then rebuild them as web applications.
• Migrate data access from direct SQL queries to API-based integrations, working with DMS APIs and building or consuming internal APIs as needed.
• Troubleshoot and debug existing SQL logic, with careful attention to edge cases and conditional branches, and document fixes clearly.
• Support Excede (Procede) administration, including security workspaces, user permissions, and data exports.
• Build Python scripts and utilities for data extraction, transformation, and Windows/Office automation.
• Analyze DMS data exports and produce clear reports and workbooks for stakeholders.
• Translate requirements from service, parts, and sales departments into technical specs, and adapt to scope changes directed by project sponsors.
• Maintain documentation, including process and lifecycle diagrams, for the systems you build or change.
• Work in local and test environments before promoting changes to production.
• Use Claude Code as part of day-to-day development, including drafting SQL and Python, debugging and refactoring, while reviewing and testing all AI-generated changes before they reach production.

Skills

SQL Server/T-SQL

Python scripting

REST APIs

VBA understanding

Tools

Procede Excede

Docker

Job description

Model 1 Commercial Vehicles, Inc. seeks a skilled developer to support the dealership management system (DMS) team. You will build automations, integrations, and reports that keep service, parts, and sales operations running smoothly, and transition Excel VBA tools to modern web applications.

You’ll migrate data access to APIs while leveraging AI-assisted tools in daily work. You will collaborate with the Sr.