Data Analyst - API Integrations & BI Solutions

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