Business Intelligence Analyst II - SQL & Retool/Hex

Motive empowers the physical operations driving the global economy with AI-powered fleet management, safety, equipment tracking, and spend management tools. Serving nearly 100,000 customers from Fortune 500 enterprises to small businesses, Motive combines industry-leading hardware and software to automate manual workloads and give operations complete visibility.

As a Business Intelligence Analyst II, you will sit within our Post Sales Organization—partnering directly with Customer Support, Product, Services, and Sales Engineering leadership. You will be responsible for designing scalable dashboards, writing advanced SQL queries, and translating complex customer interaction data into actionable executive insights using modern analytics tools like Hex, Retool, and Salesforce. This high-visibility role requires strong technical fluency alongside deep business acumen across post-sales KPIs, process optimization, and reporting governance.

Key Responsibilities

• Interactive Dashboard & Report Engineering: Design, build, and maintain interactive dashboards and storytelling reports using Hex, Retool, and native Salesforce reporting tools.
• Advanced SQL & Data Transformation: Write and optimize complex SQL queries to extract, transform, and aggregate large datasets across disparate data systems.
• Cross-Functional Stakeholder Alignment: Partner with Customer Support, Product, Professional Services, and Sales Engineering leaders to define data requirements, establish KPI definitions, and track business health.
• Post-Sales Trend & Process Analysis: Conduct deep-dive analyses on support ticket volume, resolution times, onboarding efficiency, and customer satisfaction metrics to identify operational bottlenecks and growth drivers.
• Data Governance & Consistency: Work alongside Data Engineering and BI platform teams to ensure data accuracy, single-source-of-truth definitions, and reliable reporting pipelines.
• Automation & Scripting: Leverage Python or R to automate data manipulation workflows, custom reporting pipelines, and routine operational checks.

Requirements

BI Engineering & Data Analytics Depth

• 5+ years of professional experience in data analytics, business intelligence, or data engineering.
• Expert SQL Skills: Extensive experience writing complex aggregations, window functions, and data transformations across enterprise data warehouses.
• Post-Sales Domain Acumen: Strong familiarity with pre- and post-sales operational metrics (e.g., Customer Support CSAT/CES, First Contact Resolution, SLA adherence, onboarding time-to-value, services utilization).
• Modern Dashboarding Tools: Hands-on experience developing interactive dashboards in Hex, Retool, Tableau, Looker, or Power BI.
• Salesforce Analytics: Practical experience creating custom Salesforce reports, dashboards, and working with underlying CRM objects.
• Scripting & Automation: Proficiency in Python or R for data cleaning, statistical analysis, and script automation.
• Communication & Influence: Excellent stakeholder management skills with a proven ability to explain technical data models and insights to non-technical business leaders.

Preferred Qualifications

• Direct prior experience supporting Customer Support, Professional Services, or Sales Engineering teams within a fast-growing B2B SaaS or IoT ecosystem.
• Familiarity with modern data stack tools (e.g., Snowflake, dbt, Airflow).
• Experience setting up automated data quality testing and alerting for executive reporting suites.

Total Rewards & Benefits

• Compensation & Equity: Competitive base salary + equity compensation package.
• Comprehensive Healthcare: Medical, dental, and vision insurance coverage options.
• Work Culture & Growth: Flexible working environment, continuous learning opportunities, and career growth within a high-impact IoT leader.
• Inclusive Workplace: Equal opportunity employer committed to diversity, equity, and inclusion across all global teams.