Data Analyst

Job Title: Data Analyst
Location: Remote
Experience: 5+ Years
CTC: ₹15 LPA
Employment Type: Full-Time
Work Mode: Remote
Job Summary
We are looking for an experienced Data Analyst to support data and analytics initiatives by translating complex commercial business processes into accurate analytical models and SQL logic. The ideal candidate should have strong expertise in SQL, cloud data environments, data visualization, and commercial analytics.
The candidate will work closely with business and technical teams to understand requirements, validate data, and develop reliable dashboards and analytical solutions.
Key Responsibilities
Business Process Translation and SQL Development
Translate complex commercial processes, including sales, seasonal rebate programs, sales returns, and marketing campaign performance, into accurate and documented SQL logic.
Develop, optimize, and maintain complex SQL queries and views using Amazon Redshift and Databricks.
Extract, transform, and validate data to support reporting and analytics initiatives.
Map and validate data across systems, including SAP SD, Salesforce, and digital business platforms.
Ensure business rules and commercial processes are accurately represented in the data layer.
Commercial Analytics and Dashboarding
Design, develop, and maintain QlikSense dashboards.
Develop analytical models to track regional commercial KPIs.
Analyze sell-in and sell-out data to identify market trends, demand patterns, and potential inventory issues.
Conduct in-depth analysis of sales campaigns, loyalty programs, and promotional effectiveness.
Provide actionable insights to support business decisions.
Data Quality and Governance
Collaborate with data engineering teams to optimize data pipelines, tables, and views in Databricks and Amazon Redshift.
Develop validation queries to identify data anomalies and ensure data quality and consistency.
Validate analytical results against source systems.
Ensure accurate and reliable data consumption for business intelligence and analytics teams.
Required Skills and Qualifications
Minimum 5 years of experience in Data Analytics or a related analytical role.
Strong expertise in SQL, including complex joins, CTEs, and query optimization.
Hands-on experience with Amazon Redshift and/or Databricks.
Experience working with large datasets in cloud data environments.
Proficiency in QlikSense or similar data visualization tools.
Knowledge of data warehousing concepts, including Star/Snowflake schemas and dimensional modelling.
Experience working with commercial, sales, and marketing data.
Understanding of Order-to-Cash processes, distributor/retailer channels, pricing, sales incentives, and marketing campaign tracking.
Experience with source systems such as SAP SD and Salesforce/SFDC.
Strong analytical, data validation, and problem-solving skills.
Ability to translate business requirements into technical SQL specifications.
Excellent attention to detail and communication skills.
Ability to collaborate effectively with business and technical stakeholders.
Experience in AgTech, Crop Protection, Seeds, FMCG, or related manufacturing and distribution industries.
Familiarity with structured distribution networks and commercial datasets.
How to Apply
Interested candidates can share their updated CV at:
Email: zohair@hirednex.com

Work arrangement
Yes