BI Analyst II - Dashboards, SQL & Insights

Motive; Lahore; On-site; PKR 24,910,000 - 35,981,000; Full time

Job summary

Motive is seeking a Business Intelligence Analyst II to join the Post Sales Organization. You will partner with Customer Support and product teams to deliver high-quality reporting, dashboards, and analytics.

The role emphasizes data-driven decision-making and visibility into key KPIs across the business. Responsibilities include building scalable dashboards, writing advanced SQL, and leveraging HEX/Retool and Salesforce tools.

Qualifications

• 5+ years of experience in data analytics and business intelligence.
• Hands-on experience with Salesforce reporting/dashboards.
• Strong proficiency in SQL for querying and data transformation.
• Experience in HEX or Retool for dashboard development and storytelling (Preferred).
• Python or R for data manipulation and automation.

Responsibilities

• Design, develop, and maintain interactive dashboards and reports using HEX, Retool and Salesforce native reporting tools.
• Write advanced SQL queries to extract, manipulate, and analyze large datasets across multiple systems.
• Collaborate with Customer Support, Product, Services, and Sales Engineering to translate business needs into data requirements.
• Drive data consistency and accuracy across reporting platforms to ensure leadership visibility into KPIs.
• Provide deep-dive analyses to identify trends, opportunities, and process improvements.
• Support cross-functional initiatives by building scalable, automated reporting solutions.
• Coordinate with data engineering and BI teams to align on data sources, definitions, and governance.

Skills

SQL

HEX/Retool

Salesforce

Python/R

Stakeholder Mgmt

Data analytics

Job description

Motive is seeking a Business Intelligence Analyst II to join the Post Sales Organization. You will partner with Customer Support and product teams to deliver high-quality reporting, dashboards, and analytics.

The role emphasizes data-driven decision-making and visibility into key KPIs across the business. Responsibilities include building scalable dashboards, writing advanced SQL, and leveraging HEX/Retool and Salesforce tools.