Analyst - Data Engineering

Designation : Analyst - Data Engineering

Level : L1

Location : Chennai, Tamil Nadu , India

Experience : 1 to 3 years.

Job Role :

Data Architecture & Migration: Lead the architectural shift from Salesforce Datorama to an enterprise modern data stack (Fivetran + AWS S3 + Databricks + Tableau).

Ingestion & Integration: Configure and manage automated Fivetran connectors to pull data from diverse paid media channels (e.g., Google Ads, Meta Ads, LinkedIn Ads, programmatic media) and CRM/CRMA sources into AWS S3 raw storage.

Databricks Lakehouse & Data Pipelines: Design, build, and optimize PySpark/SQL data pipelines within Databricks to transform raw landing data into clean, aggregated, and business-ready reporting models.

Tableau Reporting Integration: Map and repoint existing Salesforce Datorama reporting logic to the new Databricks gold-layer tables and view structures in Tableau Desktop/Server.

Data Quality & Validation: Perform rigorous end-to-end data validation and reconciliation between historical Datorama dashboards and new Tableau dashboards to ensure data parity and metric consistency.

Performance Optimization: Optimize Databricks clusters, Delta Lake tables, and SQL queries to minimize processing runtime and cloud resource costs.

Collaboration & Documentation: Work closely with marketing analysts, business stakeholders, and client leadership to map legacy Datorama metrics to the new target schemas and document pipeline workflows.

Required skills :

Databricks, PySpark, and SQL,Fivetran, AWS S3, Tableau