API Data Analyst & BI Insights Specialist

Lightspeed DMS LLC.; South Jordan (UT); Hybrid; USD 85,000 - 110,000; Full time

Job summary

Lightspeed DMS LLC is seeking a Data Analyst to own API-based data integrations that connect Lightspeed's DMS with OEMs, aftermarket manufacturers, and internal teams. You will build and maintain RESTful APIs and reporting solutions to ensure data flows accurately across Lightspeed platforms.

You'll collaborate with engineering, data platform, and product teams to meet data requirements for sales, service, and accounting modules, using SQL, Python, and Power BI to provide actionable insights and

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field.
• 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: Build and maintain RESTful API integrations connecting Lightspeed's DMS platform to OEM systems, aftermarket manufacturer data feeds, and internal platforms.
• Reporting & Data Solutions: Create and support reporting solutions using SQL (Microsoft and PostgreSQL) and Power BI; ensure data accuracy and security across dealer and OEM datasets.
• Client & Partner Support: Respond to internal and external requests related to API integrations and data feeds; collaborate with OEM/partner contacts to finalize 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 new tools and techniques across SQL, APIs, SSIS, and Power BI.

Skills

RESTful API design

Data analysis

Problem-solving

Communication

Education

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

Tools

Microsoft SQL

PostgreSQL

Python

Node.JS

SSIS

Power BI

Job description

Lightspeed DMS LLC is seeking a Data Analyst to own API-based data integrations that connect Lightspeed's DMS with OEMs, aftermarket manufacturers, and internal teams. You will build and maintain RESTful APIs and reporting solutions to ensure data flows accurately across Lightspeed platforms.

You'll collaborate with engineering, data platform, and product teams to meet data requirements for sales, service, and accounting modules, using SQL, Python, and Power BI to provide actionable insights and