Senior Data Warehouse and Integration Engineer
Core
Design, develop, maintain, and troubleshoot SQL Server databases, data warehouse architecture, and ETL/integration processes for enterprise clients.
Role type
Senior Data Warehouse and Integration Engineer
Builds
Enterprise data warehouses, data models, ETL pipelines, and reporting platforms
Domain
Financial services and life sciences
Required skills
SQL Server, T-SQL, Data warehouse architecture, Dimensional modeling, SSIS/ETL, Data integration, Query optimization, Production troubleshooting, Root cause analysis, Azure data services
Preferred skills
Enterprise data warehouse environments, Complex operational/financial reporting, Multi-system integrations, Data warehouse modernization
Responsibilities
Design and support enterprise data warehouse architecture and data models; Develop, maintain, and troubleshoot SQL Server databases, stored procedures, and jobs; Design and support ETL processes, integrations, and data movement; Investigate and resolve production database and reporting issues; Reconcile data discrepancies; Define and execute technical testing for changes; Support DEV, TEST/UAT, and PROD deployments; Build monitoring and recovery processes for automated integrations; Maintain documentation for databases and data flows.
Seniority
Senior, hands-on IC