Lead Sales Compensation Analyst

Who We Are

Motive empowers the people who run physical operations with tools to make their work safer, more productive, and more profitable. For the first time ever, safety, operations and finance teams can manage their drivers, vehicles, equipment, and fleet related spend in a single system. Combined with industry leading AI, the Motive platform gives you complete visibility and control, and significantly reduces manual workloads by automating and simplifying tasks.

Motive serves nearly 100,000 customers – from Fortune 500 enterprises to small businesses – across a wide range of industries, including transportation and logistics, construction, energy, field service, manufacturing, agriculture, food and beverage, retail, and the public sector.

Visit gomotive.com to learn more.

What You'll Do

• Lead end-to-end data integration initiatives using Advanced SQL : partner with business and system owners to understand data needs, model and transform data, develop scalable pipelines, and validate results for accuracy and completeness.
• Design and optimize complex SQL for transformation, reconciliation, and analytics use cases;
• Build and maintain reporting datasets and views to support self-service analytics and executive reporting; ensure data definitions and KPIs are consistently applied.
• Own project delivery : scope requirements, create technical designs, manage timelines, communicate risks, and deliver incremental value as a hands-on technical lead.
• Implement data quality controls and monitoring, including reconciliation checks, anomaly detection, and issue triage / resolution.
• Collaborate with adjacent teams (e.g., Finance, RevOps, HRIS) to understand upstream / downstream impacts and align on data contracts and SLAs.
• Document data models, transformation logic, and runbooks; contribute to standards and best practices for SQL development, reviews, and release management.
• Mentor junior team members, provide code reviews, and elevate team standards around SQL quality, performance, and reliability.
• Nice to have responsibilities : integrate with Snowflake, source / consume data from SFDC and Workday, and build dashboards or data products in Tableau.

What We're Looking For

Creating a diverse and inclusive workplace is one of Motive's core values. We are an equal opportunity employer and welcome people of different backgrounds, experiences, abilities and perspectives.

Please review our Candidate Privacy Notice here .

UK Candidate Privacy Notice here.

The applicant must be authorized to receive and access those commodities and technologies controlled under U.S. Export Administration Regulations. It is Motive's policy to require that employees be authorized to receive access to Motive products and technology.

Skills Required

snowflake , Tableau, Workday, Advanced Sql