Python Senior Technical Lead - Data Analysis, SQL

Experience: 12 to Not Available years

Location: Chennai, India

Skills: Python, SQL, Django, Flask, FastAPI, RESTful services, PostgreSQL, MySQL, SQLAlchemy, Django ORM, unit testing, TDD, BDD, PyTest, unittest, Git, CI/CD, AWS, Lambda, SQS, Redis, Elasticsearch, Linux

Job Summary
This position entails leading technical projects in the areas of SQL, data analysis, and Python. The Senior Technical Lead will be responsible for overseeing the development and implementation of technical solutions that leverage SQL databases, perform data analysis, and utilize Python programming for automation and data manipulation tasks.

Key Responsibilities
Lead and work closely with the development team to deliver commitments smoothly and predictably.
• Perform technical impact analysis and contribute to accurate effort estimation and planning.
• Own the technical design and solutioning for backend systems and integrations.
• Actively promote and adopt AI-aided development and optimization practices (code generation, reviews, test creation, performance tuning).
• Proactively identify and address:
• Security vulnerabilities
• Code quality issues
• Engineering metrics (coverage, performance, reliability)
• Conduct code reviews, guide refactoring discussions, and ensure high-quality deliverables across teams.
• Drive root cause analysis for complex production issues, identify permanent fixes, and prevent recurrence.
• Perform feasibility studies to ensure solutions leverage modern and relevant technologies.

Skill Requirements
12+ years of overall IT experience,



with 5+ years focused on designing and developing backend/web applications using Python.
• Strong expertise in Python backend frameworks such as Django, Flask, FastAPI, or equivalent.
• Solid experience in API-first design, implementation, and optimization of RESTful services. Deep understanding of middleware architecture, backend services, and system integrations.
• Hands-on experience in database schema design, implementation, and tuning using RDBMS such as PostgreSQL or MySQL.
• Strong proficiency in:
• Writing complex SQL queries
• Stored procedures, indexes, and performance optimization
• Transaction handling and data consistency
• Experience with ORM frameworks (Django ORM, SQLAlchemy, etc.) and awareness of their performance trade-offs.
• Solid coding skills with the ability to:
• Drive large-scale refactoring initiatives
• Improve coding standards, testing discipline, and maintainability across large codebases
• Experience building cloud-native services, with strong understanding of:
• Scalability
• Performance
• Security
• Reliability
• Exposure to frontend technologies (Angular or similar) for effective backend frontend collaboration.
• Experience with unit testing and TDD/BDD practices using tools such as PyTest, unittest, or similar.
• Solid understanding of software engineering best practices, including:
• Coding standards
• Code reviews
• Version control (Git)
• CI/CD pipelines
• Deployment and operations
• Knowledge of AWS services such as Lambda, SQS, Redis, Elasticsearch, or similar cloud services is a plus.
• Working knowledge of Linux environments is a plus.

📌 Python Senior Technical Lead Data Analysis, SQL (Chennai)
🏢 HCL Technologies
📍 Chennai