API Data Analyst: Drive Dealer Data with SQL & Power BI

Doist; South Jordan (UT); On-site; USD 90,000 - 140,000; Full time

Job summary

Lightspeed is seeking a Data Analyst - API to maintain RESTful API integrations linking our DMS platform with OEMs and internal teams. You will build reporting solutions using SQL and Power BI, ensuring data accuracy and secure data flows across dealer datasets.

You will collaborate with engineering and product teams to meet data needs across Sales, Parts, Service, Rentals, and Accounting modules, and you will explore new tools and techniques within SQL, APIs, SSIS, and Power BI.

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

• API Development & Integration: Support and maintain RESTful API integrations connecting Lightspeed's DMS platform to OEM systems, aftermarket manufacturer data feeds, and internal platforms.
• Reporting & Data Solutions: Build and support customized reporting solutions using SQL (Microsoft and Postgres) and Power BI.
• Client & Partner Support: Support internal and external client inbound requests related to API integrations and data feeds.
• Cross-Functional Collaboration: Partner with engineering, data platform, and product teams to meet diverse data requirements across modules and explore new tools like SQL, APIs, SSIS, and Power BI.

Skills

RESTful API design

SQL

Python

Node.js

Data pipelines

Education

Bachelor's degree in CS/IS or related field

Tools

Power BI

SSIS

Microsoft SQL Server

PostgreSQL

Job description

Lightspeed is seeking a Data Analyst - API to maintain RESTful API integrations linking our DMS platform with OEMs and internal teams. You will build reporting solutions using SQL and Power BI, ensuring data accuracy and secure data flows across dealer datasets.

You will collaborate with engineering and product teams to meet data needs across Sales, Parts, Service, Rentals, and Accounting modules, and you will explore new tools and techniques within SQL, APIs, SSIS, and Power BI.