Goods & Services - Senior Data Warehouse and Integration Engineer
Requirements
• Strong Microsoft SQL Server experience • Data warehouse design and architecture • Dimensional modeling and enterprise data modeling • Data warehouse support and production troubleshooting • Stored procedures, views, functions, and SQL Agent jobs • SSIS / SSISDB or equivalent ETL experience • ETL architecture and data pipeline design • Data integration and troubleshooting • Data reconciliation and reporting support • Query performance and optimization • Production database support • Root cause analysis • Data lineage and dependency analysis • APIs, files, feeds, and system integrations • Production deployment and change management • Azure data services where applicable • Enterprise data warehouse environments • Complex operational, financial, or regulatory reporting • Multi-system integrations • Large production SQL environments • Data warehouse modernization or redesign initiatives
Responsibilities
• Design, develop, maintain, and troubleshoot SQL Server databases, stored procedures, views, jobs, and related database objects. • Design and support enterprise data warehouse architecture, data models, schemas, and data flows. • Evaluate and improve data warehouse structure, scalability, performance, and maintainability. • Support data warehouse production operations, including failures, performance issues, data quality issues, and downstream dependencies. • Support and troubleshoot SSIS, ETL processes, integrations, APIs, files, feeds, and scheduled data processes. • Design reliable data movement between source systems, staging layers, data warehouse environments, and reporting platforms. • Investigate production database, data warehouse, integration, and reporting issues and drive them to root cause and resolution. • Reconcile report and data discrepancies against source systems. • Review database, warehouse, and integration changes for dependencies and downstream impact. • Support query performance, data integrity, reliability, and production stability. • Define and execute technical testing for database, warehouse, and integration changes. • Support DEV, TEST/UAT, and PROD deployments, including rollback planning where needed. • Build monitoring, failure detection, retry, and recovery processes for automated integrations and warehouse processes. • Maintain documentation for critical databases, warehouse architecture, integrations, jobs, reports, data flows, and support procedures. • Work directly with Development, BA, PM, Applications, Infrastructure, and Support teams. • Maintain clear status, target dates, blockers, risks, and next steps for assigned work. • Escalate risks and dependencies early instead of allowing work to remain indefinitely in investigation. • Ensure completed technical work is tested, validated, documented, deployed, and supportable.
Apply in one click
Upload My Resume
Drop here or click to browse · Tap to choose · PDF, DOCX, DOC, RTF, TXT