Business Intelligence Analyst II - SQL & Retool/Hex

Motive; Lahore; On-site; PKR 1,800,000 - 3,000,000; Full time

Benefits offered by this job

Competitive base salary

Equity compensation package

Healthcare coverage

Flexible working environment

Job summary

Motive in Lahore is seeking a skilled Business Intelligence Analyst II to design scalable dashboards, write advanced SQL queries, and translate complex post-sales data into actionable executive insights using Hex, Retool, and Salesforce.

You will partner with Customer Support, Product, Services, and Sales Engineering leaders to define KPIs, establish data governance, and drive improvements in onboarding, support efficiency, and customer satisfaction.

Qualifications

• 5+ years of experience in data analytics, BI, or data engineering.
• Strong SQL skills for complex aggregations and window functions.
• Experience producing executive-level dashboards and reports.
• Familiarity with post-sales metrics and customer success data.
• Ability to translate data into actionable insights.

Responsibilities

• Design, build, and maintain dashboards and reports.
• Write and optimize complex SQL queries across data sources.
• Align with cross-functional leaders to define KPIs and data requirements.
• Analyze post-sales trends, onboarding impact, and CSAT metrics.
• Ensure data governance and reporting pipelines.
• Automate data workflows using Python or R.

Skills

Dashboard design

Advanced SQL

Data transformation

Stakeholder management

Python or R

Data governance

Tools

Hex

Retool

Salesforce

Tableau

Looker

Power BI

Job description

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.

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.