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
