Data Analyst - API

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. 

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. 

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.