Data Analyst

DATA ANALYST
Location: Remote
Experience: 5+ Years
Employment Type: Full-Time
Work Mode: Remote
CTC: Up to ₹15 LPA
Job Summary
We are seeking an experienced and detail-oriented Data Analyst to analyse commercial, sales, and marketing data, develop meaningful business insights, and support data-driven decision-making.
The ideal candidate should have strong SQL expertise, hands-on experience with Amazon Redshift and/or Databricks, and practical experience with QlikSense for data visualisation and reporting. The candidate should also possess a solid understanding of dimensional modelling, star and snowflake schemas, data validation, and data quality management.
Experience working with SAP Sales and Distribution (SAP SD) and Salesforce (SFDC) source data, along with an understanding of Order-to-Cash (O2C), distributor and retailer channels, pricing, sales incentives, and marketing campaign tracking, is highly desirable.
The role will involve extracting, transforming, validating, and analysing data from multiple business systems, developing dashboards and reports, identifying trends and discrepancies, and translating complex datasets into actionable business insights.
Key Responsibilities
Data Analysis & SQL Development
Write, optimise, and maintain advanced SQL queries to extract, transform, and analyse large datasets.
Perform complex data joins, aggregations, transformations, and calculations across multiple data sources.
Analyse commercial, sales, and marketing data to identify trends, patterns, business opportunities, and performance gaps.
Develop reusable queries and data logic to support recurring business reporting and analytics requirements.
Investigate data discrepancies and provide accurate and reliable analytical outputs.
Ensure data extraction and transformation processes meet business requirements.
Data Warehousing & Cloud Data Platforms
Work with Amazon Redshift and/or Databricks to access, process, and analyse business data.
Develop and maintain queries and analytical datasets within data warehouse environments.
Understand data structures, relationships, and dependencies across multiple source systems.
Support data transformation and integration processes to ensure data is available for reporting and analysis.
Optimise query performance and improve the efficiency of analytical workflows.
Collaborate with relevant teams to resolve data availability, quality, and processing issues.
QlikSense Dashboards & Reporting
Develop, maintain, and enhance dashboards and reports using QlikSense.
Translate business requirements into meaningful visualisations, KPIs, and analytical reports.
Create dashboards to track sales performance, commercial metrics, pricing, incentives, and marketing campaign effectiveness.
Ensure dashboards present accurate, consistent, and actionable information.
Validate dashboard outputs against source data and agreed business definitions.
Maintain existing reports and improve reporting processes based on stakeholder requirements.
Data Modelling & Data Validation
Apply dimensional modelling principles to structure data for analytical and reporting purposes.
Work with star schemas, snowflake schemas, fact tables, and dimension tables.
Understand relationships between datasets and ensure appropriate data modelling practices.
Perform data validation, reconciliation, and quality checks across source systems and reporting outputs.
Identify missing values, duplicate records, inconsistencies, and other data quality issues.
Ensure consistency between source data, transformed datasets, and business reports.
Document data definitions, transformation logic, validation rules, and reporting methodologies.
Commercial, Sales & Marketing Analytics
Analyse commercial, sales, and marketing datasets to support business planning and performance monitoring.
Track sales trends, revenue performance, pricing movements, and commercial KPIs.
Analyse distributor and retailer channel performance.
Support the evaluation of sales incentives, promotional activities, and marketing campaign effectiveness.
Identify trends and discrepancies in sales and marketing performance.
Develop reports to monitor business performance against targets and agreed KPIs.
Provide data-driven insights to support commercial decision-making and operational improvements.
SAP SD, Salesforce & Business Process Analytics
Work with data sourced from SAP Sales and Distribution (SAP SD) and Salesforce (SFDC).
Understand relevant data structures and business entities within SAP SD and Salesforce.
Analyse data related to customer accounts, sales transactions, orders, deliveries, billing, and other relevant business processes.
Demonstrate an understanding of the Order-to-Cash (O2C) process and its associated data flows.
Analyse distributor and retailer channel data, pricing information, sales incentives, and commercial transactions.
Support data reconciliation across source systems and reporting platforms.
Collaborate with business and technical stakeholders to resolve data-related issues.
Stakeholder Collaboration & Business Insights
Understand business requirements and translate them into analytical solutions.
Collaborate with commercial, sales, marketing, and technology teams to define reporting requirements.
Present findings and insights in a clear, structured, and business-oriented manner.
Identify opportunities to improve reporting accuracy, data quality, and analytical efficiency.
Support stakeholders with ad hoc analysis and data-driven recommendations.
Maintain proper documentation of analytical processes, reports, and business logic.
Key Deliverables
Accurate and optimised SQL queries for business analysis.
Reliable datasets sourced from Amazon Redshift and/or Databricks.
Effective QlikSense dashboards and business reports.
Well-structured analytical datasets based on dimensional modelling principles.
Accurate data validation, reconciliation, and quality checks.
Actionable insights derived from commercial, sales, and marketing data.
Reliable reporting on distributor and retailer channel performance.
Analysis of pricing, sales incentives, and marketing campaign effectiveness.
Consistent and accurate reporting using SAP SD and Salesforce source data.
Timely delivery of analytical reports and stakeholder requirements.
Performance Metrics
Accuracy and reliability of analytical outputs.
Efficiency and performance of SQL queries.
Quality and usability of QlikSense dashboards.
Accuracy of data validation and reconciliation processes.
Timeliness of reporting and analytical deliverables.
Effectiveness of commercial, sales, and marketing analysis.
Consistency between source data and reporting outputs.
Resolution of data quality issues and discrepancies.
Stakeholder satisfaction with reporting and business insights.
Efficiency of recurring reporting and analytical workflows.
Candidate Requirements
5+ years of relevant experience in data analytics, business intelligence, or a related field.
Advanced proficiency in SQL, including complex joins, aggregations, transformations, and query optimisation.
Hands-on experience with Amazon Redshift and/or Databricks.
Practical experience developing dashboards and reports using QlikSense.
Strong understanding of dimensional modelling, star schemas, and snowflake schemas.
Experience in data validation, reconciliation, and data quality management.
Experience working with commercial, sales, and marketing datasets.
Familiarity with SAP SD and Salesforce (SFDC) source data.
Understanding of Order-to-Cash (O2C) processes.
Knowledge of distributor and retailer channels, pricing, sales incentives, and marketing campaign tracking.
Ability to analyse large datasets and translate findings into meaningful business insights.
Strong analytical, problem-solving, and data interpretation skills.
Excellent attention to detail and commitment to data accuracy.
Good communication and stakeholder management skills.
Ability to work independently and manage multiple analytical requirements in a remote work environment.
Required Skills
Advanced SQL | Amazon Redshift | Databricks | QlikSense | Data Analytics | Business Intelligence | Data Warehousing | Dimensional Modelling | Star Schema | Snowflake Schema | Data Validation | Data Reconciliation | Data Quality Management | Data Transformation | Query Optimisation | Commercial Analytics | Sales Analytics | Marketing Analytics | SAP SD | Salesforce (SFDC) | Order-to-Cash (O2C) | Distributor & Retailer Analytics | Pricing Analysis | Sales Incentives | Marketing Campaign Tracking | Dashboard Development | Data Visualisation | KPI Reporting | Business Insights | Stakeholder Management | Analytical Skills | Problem Solving
Core Competencies
Strong SQL and data analysis expertise. Practical understanding of cloud-based data warehousing and analytical platforms. Ability to develop meaningful QlikSense dashboards and reports. Strong knowled

Work arrangement
Yes