Data Analyst - API

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

Job summary

Lightspeed DMS in the United States is seeking a Data Analyst to design and maintain API integrations connecting Lightspeed's DMS with OEM systems and internal platforms. This role combines hands-on API development with data analysis and reporting, collaborating with engineering, data platform, and cross-functional teams to ensure accurate dealer data flows.

Responsibilities include building custom reports in SQL and Power BI, validating data quality, and supporting clients and partners on data

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

• Support and 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.
• Build and support customized reporting solutions using SQL(Microsoft and Postgres)andPower BI.
• Perform data classification and validation to ensure accuracy and security across dealer and OEM datasets.
• Support internal and external client inbound requests related to API integrations and data feeds.
• Collaborate with OEM and aftermarketmanufacturertechnical contacts to gather andvalidateintegration requirements.
• Partner with engineering, dataplatform, 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.

Skills

RESTful API

Microsoft SQL

PostgreSQL

Python

Node.js

SSIS

Communication

Problem-solving

Education

Bachelor's degree in Computer Science / Information Systems or related field

Tools

Power BI

SSRS

Job description

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- APItomaintainthe API-based data integrations that connect Lightspeed's DMS platform with OEMs, aftermarket manufacturers, and internal teams. This individual will implementand support RESTful API integrations and reporting solutions, partnering closely with engineering, dataplatform, and cross-functional teams to keep dealer data flowing accurately acrossall Lightspeed data platforms.

This role hasdirectimpact on dealer-facing data integrity: the integrations this person builds andmaintainsdeterminewhether OEM programs, manufacturer data feeds, and dealer reporting areaccurateandtimely. The role combines hands-on API development with data analysis andreporting andrequires close collaboration with internal and external technical stakeholders.

What You'll Do

API Development & Integration

• Support and helpmaintainRESTful 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)andPower 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 aftermarketmanufacturertechnical contacts to gather andvalidateintegration requirements.

Cross-Functional Collaboration

• Partner with engineering, dataplatform, 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.
• Proficiencywith Microsoft SQL; familiarity with PostgreSQL.
• Experience with Python, Node.JS,and/or SSIS for building data pipelines.
• Exposure todealer, 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.

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