Data Analyst

Code1; India; Teletrabalho; INR 1 200 000 - 1 800 000; Tempo integral

Resumo da oferta

Code1 Tech is seeking a Data Analyst for the AMEA Data & AI team to translate complex commercial processes into cloud-based data models and robust SQL logic. You will partner with regional Sales, Marketing, and Commercial Excellence to enable AI/ML initiatives with accurate data.

You will work in Databricks and Amazon Redshift environments, build QlikSense dashboards, and ensure data quality while aligning data pipelines with business needs across SAP SD and Salesforce integrations.

Qualificações

• Expert in writing highly optimized SQL for Redshift/Databricks.
• Hands-on data visualization with dashboards and BI tools.
• Strong understanding of data warehousing concepts and modeling.
• Experience with ERP/CRM data sources (SAP SD, Salesforce).

Responsabilidades

• Translate complex commercial processes into accurate SQL logic.
• Write, optimize, and maintain SQL queries in Redshift/Databricks.
• Map and validate data across systems like SAP SD and Salesforce.
• Design and maintain QlikSense dashboards powering KPIs.
• Analyze sell-in/sell-out data to identify trends and risks.
• Conduct ad-hoc analyses to support campaigns and ROI decisions.

Conhecimentos

Expert SQL

Cloud Data Environments

Data Visualization

Data Warehousing Concepts

Ferramentas

Databricks

Amazon Redshift

SAP SD

Salesforce

QlikSense

Descrição da oferta de emprego

At Code1 Tech, we drive innovations that shape the future of enterprise technology. Our expertise spans Data Engineering, AI/ML, Cloud Solutions, and Full-Stack Development. We empower businesses with cutting-edge technology solutions, enabling digital transformation at scale. Join us to build impactful products with a passionate team of engineers and innovators.

Role Purpose:

As a Data Analyst for the AMEA Data & AI team, you will bridge the gap between complexagricultural business processes and cloud-based data environments. You will partnerwith regional Sales, Marketing, and Commercial Excellence teams to translatecommercial rules, seasonal sales cycles, and distributor structures into precise, high

performing analytical models. A critical part of this role is the ability to navigate clouddata platforms, writing advanced, accurate SQL queries to extract and transform datafrom Databricks and Amazon Redshift

Experience:

5+ Years

Key Responsibilities:

1. Business Process Translation & SQL Development

• Translate complex commercial business processes (e.g., sales in differentmarkets with different GTM / GoToMarket strategy, seasonal rebate programs,sales returns, and marketing campaign performance) into accurate,documented SQL logic.
• Write, optimize, and maintain complex SQL queries and views directlywithin Amazon Redshift or Databricks environments (Gold Layer) to supportvisualization and AI/ML teams.
• Map and validate data across disparate systems—such as SAP SD (sales orders,delivery, billing, rebates, etc), Salesforce (Sales target, Business Growth Plan,special prices), and digital tools (grower engagement, field force effectivenesstools)—ensuring the business logic is accurately represented in the data layer.
• Design, build, and maintain robust QlikSense dashboards powered by optimizedRedshift/Databricks data models to track regional commercial KPIs.
• Analyze "sell-in" (sales to distributors) and "sell-out" (sales to retailers/growers)data to identify market demand trends and potential inventory bottlenecks.
• Conduct ad-hoc deep-dives into sales campaigns, loyalty programs, andpromotional effectiveness to optimize marketing spend ROI.

3. Data Governance & Environment Management

• Collaborate with data engineering teams to optimize data pipelines, tables, andviews in Databricks/Redshift for BI consumption.
• Ensure data quality and consistency by implementing validation queries to catchanomalies in commercial data before they impact business decisions.

Technical Skills:

• Expert SQL: Mastery in writing highly optimized, complex SQL queries (CTEs,complex joins, query optimization) specifically within AmazonRedshift or Databricks (Silver and Gold Layer) environments.
• Cloud Data Environments: Hands-on experience working within Databricksnotebooks or Redshift query editors to explore, validate and clean largedatasets.
• Data Visualization: Good to have QlikSense exposure with experienceconnecting directly to Redshift or Databricks data sources.
• Data Warehousing Concepts: Solid understanding of star/snowflake schemas,dimensional modeling, and how business hierarchies (sales territories, producthierarchies) are structured in a data warehouse.

Domain & Business Knowledge:

• Commercial Process Expertise: Deep understanding of commercial, sales, andmarketing business processes (e.g., order-to-cash, distributor/retailer channeldynamics, sales incentive plans, pricing structures, and marketing campaigntracking).
• AgTech/Agriculture Industry Experience: 2+ years of experience working within anAgTech, Crop Protection, Seeds, or related manufacturing/FMCG company witha structured distribution network.
• Source System Familiarity: Understanding of how commercial transactions arecaptured in ERPs (like SAP SD) and CRMs (like Salesforce/SFDC).

Soft Skills:

• Business-to-Tech Translation: Ability to sit with commercial managers,understand their business challenges, and independently translate those needsinto technical SQL specifications.
• Attention to Detail: Rigorous approach to data validation, ensuring that financialand sales numbers in dashboards match source systems perfectly.