Senior Data Architect

SourcingXPress; Bengaluru; On-site; INR 1,500,000 - 2,500,000; Full time

Job summary

SourcingXPress in Bengaluru is looking for a Data Modeling & Warehousing Expert with 10-15 years of experience. You will take full ownership of the data lifecycle, implementing best practices in data modeling and cloud solutions.

The ideal candidate should possess strong skills in SQL and PySpark, with a background in ETL/ELT processes and cloud services like AWS and Databricks. Excellent communication and a proactive approach are essential.

Qualifications

• 10–15 years of experience in data modeling and delivery.
• 3+ years of PySpark development experience.
• Strong background in ETL/ELT and analytical modeling.

Responsibilities

• Lead data modeling projects and oversee the full data lifecycle.
• Write complex SQL for data transformation and validation.
• Analyze existing transformation logic for reconciliation.

Skills

Data Modeling

SQL

PySpark

ETL/ELT

Cloud Services

Tools

AWS

Databricks

dbt

Snowflake

Azure

GCP

Job description

Job Description

• Data Modeling & Warehousing Expert — Strong background in Kimball, dimensional, and analytical modeling with hands‑on delivery of data warehouse builds or migrations.
• SQL & PySpark Power User — Deep expertise in writing complex SQL for transformation, validation, and reconciliation, plus 3+ years of PySpark development with Unity Catalog and governance frameworks.
• Full Data Lifecycle Ownership — Proven experience across ingestion, staging, conformed layers, and data exploitation design, with a strong grasp of MDM, metadata management, cataloguing, and data quality.
• ETL/ELT & Pipeline Validation — Skilled in analyzing existing transformation logic and performing reconciliation testing between legacy and new environments end-to-end.
• Business-Meets-Technology Translator — Able to take business requirements and turn them into robust, scalable data models that power analytics and reporting.
• Cloud & Modern Stack — Experience with AWS data platform services, Databricks, and familiarity with dbt, Snowflake, Azure, or GCP. Telecom sector experience is a plus.
• Strategic & Hands‑On Leader — 10–15 years of experience blending technical delivery with architectural strategy. Proactive, detail-oriented, and accountable.
• Great Communicator & Relationship Builder — Simplifies complex ideas, builds trust with clients and teams, and quickly grasps business context.
• Industry‑Curious — Keen interest in emerging data technologies and trends, and how they drive real business outcomes.