Role Overview

We are seeking a Senior SQL Developer & ETL Engineer with 5+ years of experience for a 100% remote opportunity.

Please note: This is not a standard Big Data / Infra-heavy Data Engineering role. We are specifically looking for a SQL Specialist. Your core strength must lie in relational database development, schema design, and writing high-performance database logic. Python will be your primary tool for moving and orchestrating data, but SQL and database architecture are the heart of this role.

Key Responsibilities

• Database Architecture & Schema Design: Design, implement, and maintain robust relational database schemas, ensuring optimal data modeling (OLTP and OLAP/Data Warehousing).
• Advanced Database Programmability: Write, debug, and optimize complex Stored Procedures, Functions, Triggers, and Views to handle core business logic at the database level.
• Performance Tuning & Indexing: Analyze query execution plans, identify bottlenecks, and implement advanced indexing strategies, partitioning, and query refactoring to ensure sub-second response times.
• Python ETL/ELT Pipelines: Develop, schedule, and maintain scalable data ingestion and transformation pipelines using Python to connect disparate data sources.
• Data Integrity & Governance: Establish constraints, data validation routines, and automated quality checks to guarantee absolute data accuracy.

Required Technical Skills

• Expert-Level SQL & DB Programmability (5+ Years): Mastery of writing complex queries (CTEs, Window Functions, Analytical queries) and server-side logic (Stored Procedures/Functions) in platforms like PostgreSQL, SQL Server, Oracle, or MySQL.
• Advanced Database Optimization: Deep understanding of how databases work under the hood—specifically indexing (B-Tree, Hash, Clustered/Non-Clustered), execution plans, statistics, and locking/concurrency mechanisms.
• Python for Data Ingestion (3+ Years): Proficient in writing clean, modular Python scripts for data manipulation, API integration, and ETL processing (using libraries like Pandas, SQLAlchemy, or custom database connectors).
• Data Modeling Methodologies: Practical experience designing Star/Snowflake schemas, Normalization (3NF), and handling Slowly Changing Dimensions (SCD).

Remote & Soft Skills

• Autonomous Execution: Proven ability to manage your own time, architecture tasks, and deliverables without micromanagement.
• Asynchronous Communication: Exceptional written and verbal English communication skills to collaborate seamlessly across time zones.
• Legacy Refactoring Mindset: You enjoy opening up a massive, poorly optimized 500-line stored procedure and refactoring it for 10x performance.

Nice-to-Haves

• Experience migrating legacy on-premise stored procedures to modern cloud data warehouses (Snowflake, BigQuery, Redshift).
• Familiarity with workflow orchestration tools like Apache Airflow or Prefect.
• Experience with dbt (data build tool).

Pay: ₹296,633.39 - ₹1,373,466.16 per year

Work Location: Remote