DMS Developer / Systems Analyst

Model1 Commercial Vehicles, Inc.

• $90K — $110K *
Enterprise Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 2–4 years of hands-on SQL Server/T-SQL development experience including complex logic.
  • Proficiency in Python for scripting and automation tasks.
  • Experience building web applications with REST APIs.
  • Ability to read and reverse-engineer VBA code.
  • Strong debugging skills and a systematic approach to testing.
  • Clear communication skills for explaining technical concepts to diverse audiences.
  • Comfortable working with complex data formats like CSV exports.

Responsibilities

  • Develop and maintain T-SQL views, stored procedures, and automated DMS workflows.
  • Analyze and rebuild Excel VBA tools as web applications.
  • Migrate data access from SQL queries to API integrations.
  • Troubleshoot and document SQL logic and fixes for edge cases.
  • Support Excede administration including user permissions and data exports.
  • Build Python scripts for data transformation and automation tasks.
  • Translate business requirements from various departments into technical specifications.

Benefits

  • Competitive health insurance benefits.
  • Paid holidays and vacation time.
  • Continuous training for personal and professional development.
  • Access to a diverse network of mentors and networking opportunities.
  • Use of top-tier technology for improved efficiency in delivery.
Full Job Description
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 Range90-110

Similar Jobs

More Jobs at Model1 Commercial Vehicles, Inc.

More Enterprise Technology Jobs

Find similar DMS Developer / Systems Analyst jobs: