DMS Developer / Systems Analyst

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

What We're Looking For

Required:

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