# Senior Data Engineer - Python/SQL at Shimento
Source: https://true-hire-ten.vercel.app/jobs/senior-data-engineer-python-sql-shimento-2rnyf5rt · Company profile: https://true-hire-ten.vercel.app/companies/shimento · Apply on the employer's site: https://www.hirist.tech/j/senior-data-engineer-python-sql-1671684?utm_source=freehire.me
## Job details
- Location: Bangalore
- Seniority tag: Senior
- Category: Data Engineering
- Countries: India
- Posted: 2026-09-16 (23 days ago, stale)
- Skills named: airflow, analytics, anomaly-detection, api, ci-cd, data-engineering, data-lineage, data-modeling, data-pipelines, data-quality, etl, git, hadoop, hive, medallion-architecture, mysql, pandas, postgresql, python, spark, sql, sqlalchemy, yaml
## About the role
**Hiring : ** Senior Data Engineer | 6+ Years.

**Location : ** Bangalore.

**Role : ** Senior Data Engineer.

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.

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.

**Key Responsibilities : **

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

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

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

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

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

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

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

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

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

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

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

- Own CI/CD processes using Git workflows.

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

**Must-Have Skills : **

- 6+ years of experience in Data Engineering.

- Strong Python + SQL expertise.

- Strong Data Architecture and System Design skills.

- End-to-end production pipeline ownership.

- Expert SQL including Window Functions, CTEs, CASE logic.

- Strong experience with MySQL / PostgreSQL.

- Experience designing Transaction / Fact Tables.

- Strong data quality, reconciliation, auditability, and lineage practices.

- Experience with Airflow or similar orchestration tools.

- Strong data modeling knowledge - Fact/Dimension, Normalization, Medallion Architecture.

**Good to Have : **

- Finance, Risk, or Compliance data experience.

- Spark / Hive / Hadoop experience.

- YAML-based pipeline configuration.

- CI/CD and Git workflows.

- API integrations.

- Experience with large-scale production data platforms.
© TrueHire. Listing data from freehire; applications go to the employer's own page.