Sr SQL/ETL developer

Moder

About The Position

Summary: The Senior SQL ETL Developer is responsible for designing, developing, and maintaining SQL-based data integration and transformation processes that support reporting and analytics. This role focuses on building and optimizing ETL pipelines, ensuring data accuracy and integrity, and supporting data models used across the organization. The position requires strong expertise in T-SQL, data warehousing concepts, and performance tuning, along with the ability to troubleshoot data issues and support production data operations.

Requirements

Strong experience with T-SQL development (stored procedures, functions, views)
Hands-on experience building and maintaining ETL pipelines
Solid understanding of data warehousing concepts (fact/dimension models, SCDs)
Experience with performance tuning (execution plans, indexing, query optimization)
Knowledge of data quality, validation, and reconciliation techniques
Experience with incremental data loading and change tracking
Strong problem-solving skills and ability to troubleshoot complex data issues
Experience working in production environments with SLAs
Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a related field
5-8+ years of experience in SQL development, data engineering, or ETL development
At least 3+ years working specifically with ETL pipelines and data warehousing concepts
Demonstrated experience in performance tuning and production support environments

Nice To Haves

Experience with modern data platforms or ETL tools (e.g., SSIS, Azure Data Factory, etc.)
Familiarity with data governance, auditing, and compliance requirements
Experience supporting analytics or BI teams
Exposure to cloud-based data environments

Responsibilities

Design, develop, and optimize T-SQL stored procedures, functions, and views for ETL and reporting use cases
Build and maintain scalable ETL pipelines to ingest and transform data from multiple source systems
Implement incremental loading strategies, change data capture, and historical tracking (Type 1 and Type 2)
Develop reusable SQL frameworks for data ingestion, transformation, and reconciliation
Implement and maintain data quality checks including row counts, schema validation, null checks, and duplicate detection
Perform source-to-target reconciliation and investigate discrepancies in data
Ensure auditability and compliance through well-documented, traceable SQL logic
Tune SQL queries and stored procedures for performance, efficiency, and scalability
Support and enhance dimensional and relational data models used for reporting and analytics
Collaborate with reporting and analytics teams to ensure data accuracy, consistency, and usability
Analyze execution plans, indexing strategies, and query patterns to resolve performance bottlenecks
Ensure ETL processes meet defined SLAs and execution windows
Troubleshoot ETL failures, production issues, and data inconsistencies
Implement and maintain logging, error handling, and restart/recovery mechanisms
Participate in code reviews, release planning, and production deployments
Comply with all company policies and procedures.
Maintain regular and punctual attendance.
Performs other related duties as assigned.