DMS Developer / Systems Analyst

Model 1 Commercial Vehicles; Indianapolis (IN); On-site; USD 90,000 - 110,000; Full time

Benefits offered by this job

Health insurance

Paid holidays

Vacation pay

Job summary

Model 1 Commercial Vehicles in Indianapolis seeks a software developer to support the DMS team by building automations, integrations, and reporting. You will transition Excel VBA tools to modern web apps, move data access from SQL queries to APIs, and collaborate with the Sr.

Business Systems Manager to design, test, and maintain SQL-based processes. You'll work with Excede (Procede) administration, security workspaces, and data exports, using Claude Code as part of daily development while

Qualifications

• 2–4+ years of hands-on SQL Server / T-SQL development.
• Proficient in Python for scripting and automation.
• Experience building web applications with REST APIs.
• Ability to read and reverse‑engineer VBA code.
• Strong debugging and incremental testing approach.
• Clear ability to explain technical decisions to varied audiences.
• Comfort handling real-world CSV exports and legacy schemas.

Responsibilities

• Develop, test, and maintain T-SQL views, stored procedures, and jobs.
• Document logic and rebuild Excel VBA tools as web apps.
• Migrate data access to API-based integrations using DMS APIs.
• Troubleshoot and document fixes for SQL logic.
• Support Excede (Procede) administration including security workspaces.
• Build Python scripts for data extraction and Windows/Office automation.
• Analyze DMS exports and create stakeholder reports.
• Translate business requirements into technical specifications.
• Maintain system documentation and diagrams.
• Work in local and test environments before production.
• Use Claude Code for AI-assisted development with verification.

Skills

SQL Server / T-SQL

Python scripting

REST APIs

VBA reverse-engineering

Debugging / Testing

Communication

CSV/Legacy data handling

Tools

Procede Excede

Docker

Git

VS Code

Claude Code

Job description

Overview

About Model 1 Commercial Vehicles

Since we got our start in 1980, Model 1 Commercial Vehicles has grown to become the nation’s largest dealership, representing more than 20 top manufacturers across the U.S. And we did it all by listening to and investing in customers like you. Customers who want more than a dealer. Customers who want a partner in creative solutions to the challenges you face today, and visionary thinking for what’s next. It’s the strength of our relationships – both with customers and manufacturers – that allows us to keep a finger on the pulse of what our customers need and what’s possible to not just source but create together. Whether it’s custom-built vehicles or alternative fuel and electric vehicle (EV) options, customers have a partner from challenge all the way through solution and beyond.

Our Core Values

At Model 1, we are committed to living our core values:

• Solving Problems: Trust what you know. Work together to find solutions. See every angle and figure it out.
• Setting the Tone: Establish the mood that puts others at ease. Be the person that you’d want to interact with – approachable and transparent.
• Drive Forward: Keep your eyes up to see what’s ahead. Imagine better methods. Seize opportunities. Move the business and the market, meaningfully.
• Find Balance: Match your energy at work to your energy with family, friends, and community. Decide and align your priorities. Pour into yourself and those around you.
• Own It: Take the extra step. Fix issues when they come up. Care from start to finish. Do the right thing, every time.

Job Summary

We're looking for a developer to support our dealership management system (DMS) team in building automations, integrations, and reporting that keep our service, parts, and sales operations running smoothly. A key initiative is developing and maintaining modern web applications that complement our core system and transitioning existing Excel VBA tools into the same stack, incl. moving their data access from direct SQL queries to APIs. You'll work closely with the Sr. Business Systems Manager to design, test, and maintain SQL-based processes, support the administration of our Excede (Procede) environment, and turn business requirements from dealership staff into reliable technical solutions. Our team develops using AI-assisted tools, including Claude Code, as a core part of our workflow.

What You Will Gain

• Competitive benefits include health insurance, paid holidays, and vacation pay
• Continuous training to provide you the opportunity to develop your full potential and be a true business partner
• Access to an expansive network of mentors and networking opportunities
• Top quality technology to assist in your daily responsibilities to allow for more efficiencies to deliver outstanding customer service

Responsibilities

What You'll Do

• 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.

Required

What We're Looking For

• [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.
• Comfort working with challenging real‑world data (CSV exports, legacy schemas).

Preferred

• Experience with a dealership management system, ideally Procede’s Excede, or with other automotive/RV/heavy‑truck DMS platforms.
• Familiarity with dealership operations (service orders, sublet, parts, F&I).
• Experience with a web stack such as [e.g., Python/Flask or FastAPI, .NET, or JavaScript/React].
• Experience designing or securing APIs (authentication, permissions, error handling).
• Background in migrating legacy desktop or spreadsheet tools to web platforms.
• Experience with AI‑assisted development tools such as Claude Code, and good judgment about when to trust, verify, or rewrite their output.
• Experience with Excel automation, COM/pywin32, or Office integrations.
• Exposure to Docker, Git, and VS Code.

Pay Range

90-110