Duties & Responsibilities:
Lead the design, development, and optimization of ETL/ELT pipelines and workflows
Write, tune, and optimize advanced SQL queries for large-scale data processing
Build and maintain data warehouses and data models (relational, dimensional, star schema)
Translate business requirements into robust, well-architected, and reusable data solutions
Partner with analysts, data scientists, and stakeholders to deliver trusted, actionable datasets
Implement and maintain unit tests, integration tests, and validation frameworks to ensure pipeline reliability
Document workflows, and design decisions to support knowledge sharing and operational continuity
Apply coding standards, CI/CD practices, version control, and peer code reviews to ensure high-quality deliverables
Proactively monitor, optimize, and troubleshoot pipelines for performance, scalability, and cost efficiency
Support deployments and handle post-production monitoring and incident resolution
Mentor associate engineers, providing technical guidance and feedback

Requirements




Basic Qualifications:
Bachelor’s degree in computer science, Information Systems, Engineering, or a related field
4–7 years of hands-on experience in data engineering or related fields
Expertise in writing complex SQL queries, optimizing, using advanced functionals and turning the performance on cloud data warehouse setting.
Robust experience with data warehousing concepts, design, and implementation
Minimum 3 years of hands-on experience with Snowflake or up-to-date cloud data warehouse
Minimum 2 years of hands-on experience in data modeling
Minimum 1 year of hands-on Python development (ETL/ELT scripting, OOP, automation)
Solid knowledge of at least one major cloud platform (AWS, Azure, or GCP)
Experience with orchestration tools (e.g., Airflow, ADF, Luigi) for workflow management
Demonstrated ability to lead and mentor teams while managing multiple priorities
Robust communica

📌 Senior Data Engineer Chennai
🏢 Staples India Business Innovation Hub
📍 Chennai