SQL Data Engineer
Core
Designing, building, and maintaining enterprise data warehouses and ETL pipelines to integrate data from multiple source systems for business stakeholders.
Role type
Senior SQL Data Engineer (ETL & Data Warehousing)
Builds
Enterprise data warehouse, ETL processes, complex T-SQL scripts, stored procedures, and database objects
Domain
Enterprise Data Warehousing, ETL, SQL Server ecosystem
Deliverable
production ML models | product features | dashboards & analysis | infrastructure
Required skills
SQL Server Integration Services (SSIS), T-SQL programming, data warehousing architecture, database design and indexing, query optimization, PowerShell/C#/Python scripting, data quality validation
Preferred skills
DB2 experience, WhereScape RED, cloud-based data platforms, data governance frameworks
Technologies
SQL Server, SSIS, T-SQL, PowerShell, C#, Python, DB2, WhereScape RED
Responsibilities
Map source data to existing data models and design database schemas, redevelop and enhance ETL processes for data ingestion and transformation, develop and maintain complex T-SQL scripts and stored procedures, optimize ETL processes and database performance, conduct testing and validation for data accuracy, troubleshoot data quality and integration issues, maintain technical documentation for ETL processes and mappings
Seniority
Senior, hands-on IC