Data Engineer Python Dbt Chennai

Description We are seeking a seasoned Senior Data Engineer specializing in Python, dbt, and SQL to design, optimize, and scale our core data infrastructure. In this role, you will be the bridge between raw, disparate data sources and high-performance analytics, driving the architecture of our modern data stack. This is not a role for simple data moving; you will own the reliability, scalability, and quality of our data warehouse. You will write clean, modular dbt models, develop custom Python frameworks for complex ELT/ETL extractions, and optimize massive SQL queries to keep compute costs low and performance high. If you treat data infrastructure like software engineeringvaluing testing, documentation, and automated deploymentyou will thrive in this setting. Requirements Experience: 6+ years of experience in data engineering, backend engineering, or a highly analytical data infrastructure role. SQL & Warehouse Mastery: Exceptional SQL skills with a deep understanding of database internals, query execution plans, and analytical performance tuning. dbt Expertise: Proven track record of deploying and managing dbt in production at scale, including experience with dbt packages, custom macros, and documentation generation. Software Engineering Mindset: Solid Python development skills, including writing reusable modules, handling APIs, using virtual environments, and implementing unit tests. Cloud-Native Fluency: Deep familiarity with cloud settings (AWS, GCP, or Azure) and containerized workflows (Docker). Communication Skills: Ability to clearly explain data architecture choices, trade-offs, and data lineages to both technical and non-technical stakeholders. Job responsibilities Data Pipeline Development: Design, build, and maintain scalable ELT/ETL pipelines using Python and SQL to ingest data from internal applications, production databases, and third-party APIs. Data Transformation Architecture: Own the dbt environment, establishing best .