Data Analyst - API

Lightspeed DMS; South Jordan (UT); On-site; USD 90,000 - 140,000; Full time

Job summary

Lightspeed is seeking a Data Analyst - API to maintain RESTful API integrations linking our DMS platform with OEMs and internal teams. You will build reporting solutions using SQL and Power BI, ensuring data accuracy and secure data flows across dealer datasets.

You will collaborate with engineering and product teams to meet data needs across Sales, Parts, Service, Rentals, and Accounting modules, and you will explore new tools and techniques within SQL, APIs, SSIS, and Power BI.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field, or equivalent practical experience.
• Working knowledge of RESTful API design, development, and integration.
• Proficiency with Microsoft SQL; familiarity with PostgreSQL.
• Experience with Python, Node.JS, and/or SSIS for building data pipelines.
• Exposure to dealer, franchise, or vertical SaaS business models, or strong interest in learning the dealer/OEM data ecosystem.
• Strong problem-solving and communication skills.

Responsibilities

• API Development & Integration: Support and maintain RESTful API integrations connecting Lightspeed's DMS platform to OEM systems, aftermarket manufacturer data feeds, and internal platforms.
• Reporting & Data Solutions: Build and support customized reporting solutions using SQL (Microsoft and Postgres) and Power BI.
• Client & Partner Support: Support internal and external client inbound requests related to API integrations and data feeds.
• Cross-Functional Collaboration: Partner with engineering, data platform, and product teams to meet diverse data requirements across modules and explore new tools like SQL, APIs, SSIS, and Power BI.

Skills

RESTful API design

SQL

Python

Node.js

Data pipelines

Education

Bachelor's degree in CS/IS or related field

Tools

Power BI

SSIS

Microsoft SQL Server

PostgreSQL

Job description

Company Overview:

Lightspeed is the leading provider of cloud-based software for dealerships, serving the Powersport, Marine, RV, Trailer, and Golf Car industries adding hundreds of dealerships to the Lightspeed community each year. Lightspeed’s Dealer Management Solution (DMS) enables dealerships to optimize their end-to-end business operations, including Sales, Parts, Service, Rentals, Payments, Accounting, and Customer Relationship Management (CRM). When implemented into their daily operations, Lightspeed helps dealers increase their profitability by selling more units, service, and parts, all while creating a more streamlined experience for customers. Lightspeed is the most complete and integrated DMS in the industry with over 500 integrations with Original Equipment Manufacturers (OEMs), aftermarket parts and accessory distributors and dozens of other software tools that a dealership may use to run their business. Uniquely designed by dealers for dealers, and refined over the past 4 decades, Lightspeed empowers over 4,500+ dealers across North America with the tools and technology they need to manage their dealerships. We are seeking a Data Analyst - API to maintain the API-based data integrations that connect Lightspeed's DMS platform with OEMs, aftermarket manufacturers, and internal teams. This individual will implement and support RESTful API integrations and reporting solutions, partnering closely with engineering, data platform, and cross-functional teams to keep dealer data flowing accurately across all Lightspeed data platforms. This role has direct impact on dealer-facing data integrity: the integrations this person builds and maintains determine whether OEM programs, manufacturer data feeds, and dealer reporting are accurate and timely. The role combines hands-on API development with data analysis and reporting and requires close collaboration with internal and external technical stakeholders.

What You'll Do

API Development & Integration

• Support and help maintain RESTful API integrations connecting Lightspeed's DMS platform to OEM systems, aftermarket manufacturer data feeds, and internal platforms.
• Troubleshoot and resolve API connectivity, authentication, and data flow issues for internal and external clients, including OEM and dealer partners.
• Document API integration specifications and data mappings for internal and partner-facing use.

Reporting & Data Solutions

• Build and support customized reporting solutions using SQL (Microsoft and Postgres) and Power BI.
• Perform data classification and validation to ensure accuracy and security across dealer and OEM datasets.

Client & Partner Support

• Support internal and external client inbound requests related to API integrations and data feeds.
• Collaborate with OEM and aftermarket manufacturer technical contacts to gather and validate integration requirements.

Cross-Functional Collaboration

• Partner with engineering, data platform, and product teams to meet diverse data requirements across sales, parts, service, rentals, and accounting modules.
• Explore and adopt new tools and techniques across SQL, APIs, SSIS, and Power BI.

What You Should Have

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent practical experience.
• Working knowledge of RESTful API design, development, and integration.
• Proficiency with Microsoft SQL; familiarity with PostgreSQL.
• Experience with Python, Node.JS, and/or SSIS for building data pipelines.
• Exposure to dealer, franchise, or vertical SaaS business models, or strong interest in learning the dealer/OEM data ecosystem.
• Strong problem-solving and communication skills.

Preferred Qualifications

• Experience with Power BI or SSRS reporting.
• Prior experience integrating with OEM, manufacturer, or partner-facing APIs.
• Interest in the Powersports, Marine, RV, Trailer, Outdoor Power Equipment, or Golf Cart industries.

Inclusion and Diversity at Lightspeed

At Lightspeed, we celebrate the uniqueness of every individual and encourage diverse perspectives. We believe that inclusion drives innovation and fosters meaningful connections. We are committed to building an environment where everyone feels valued and empowered to make an impact.

Equal Employment Opportunity Statement

Lightspeed is an Equal Opportunity Employer and is dedicated to building a diverse and inclusive workforce. All qualified applicants will be considered for employment without regard to race, color, creed, ancestry, national origin, gender, sexual orientation, gender identity, gender expression, marital status, religion, age, disability, veteran status, or any other protected category.

Important Note:

Applicants must be authorized to work in the U.S.