Data Analyst - API

Lightspeed is the leading provider of cloud-based software for dealerships, serving the Powersport, Marine, RV, Trailer, and Golf Car industries. Our Dealer Management Solution (DMS) enables dealerships to optimize end-to-end business operations, including Sales, Parts, Service, Rentals, Payments, Accounting, and Customer Relationship Management (CRM). Lightspeed helps dealers increase profitability by selling more units, service, and parts while creating a streamlined customer experience. With over 500 integrations with OEMs, aftermarket parts and accessory distributors, and other software tools, Lightspeed empowers over 4,500+ dealers across North America.

About the role

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 ensure dealer data flows accurately across all Lightspeed data platforms. The role has a direct impact on dealer-facing data integrity and combines hands-on API development with data analysis and reporting.

Responsibilities

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

Requirements

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

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.