Job Description

? Hiring: Senior Data Engineer | 6+ Years

n

? Location: Bangalore

n

? Experience: 6+ Years

n

n

? ? Role: Senior Data Engineer

n

We are looking for a highly skilled Senior Data Engineer with strong expertise in Data Architecture, System Design, Python, and SQL to design, build, and own end-to-end production data pipelines powering analytics and business decision-making.

n

The ideal candidate should have strong experience in transaction-level data modeling, data quality, auditability, data lineage, and production pipeline ownership, preferably within finance, risk, or compliance data domains.

n

n

? Key Responsibilities

n

• Own data architecture and system design decisions for data pipelines and data models.

n

• Design and build scalable, production-grade data pipelines end-to-end.

n

• Design transaction-level fact tables and standard fact/dimension models.

n

• Implement Bronze/Silver/Gold (Medallion) architecture.

n

• Build pipelines for finance, risk, or compliance use cases where accuracy and auditability are critical.

n

• Implement data quality controls, reconciliation, anomaly detection, and audit trails.

n

• Write complex SQL using CTEs, window functions, CASE logic, COALESCE, NULLIF, and date/timestamp handling.

n

• Build idempotent data reload patterns and handle late-arriving or corrected records without double-counting.

n





• Develop and maintain Airflow-style DAGs and cross-pipeline dependencies.

n

• Build Python-based ETL tooling using Pandas, SQLAlchemy, and database drivers.

n

• Work with YAML-driven configurations and integrate with APIs where required.

n

• Own CI/CD processes using Git workflows.

n

• Document data models, pipeline logic, data lineage, and operational processes.

n

n

?️ Must-Have Skills

n

✅ 6+ years of experience in Data Engineering

n

✅ Strong Python + SQL expertise

n

✅ Strong Data Architecture and System Design skills

n

✅ End-to-end production pipeline ownership

n

✅ Expert SQL including Window Functions, CTEs, CASE logic

n

✅ Strong experience with MySQL / PostgreSQL

n

✅ Experience designing Transaction / Fact Tables

n

✅ Solid data quality, reconciliation, auditability, and lineage practices

n

✅ Experience with Airflow or similar orchestration tools

n

✅ Strong data modeling knowledge — Fact/Dimension, Normalization, Medallion Architecture

n

n

⭐ Good to Have

n

• Finance, Risk, or Compliance data experience

n

• Spark / Hive / Hadoop experience

n

• YAML-based pipeline configuration

n

• CI/CD and Git workflows

n

• API integrations

n

• Experience with large-scale production data platforms

📌 Senior Data Engineer | 6+ Years (Bengaluru)
🏢 ShimentoX Technologies
📍 Bengaluru