Data Warehouse Support Specialist
Core
Ensure stability and smooth operation of the Production Data Warehouse environment by monitoring daily processes, supporting EOD/EOM cycles, and resolving ETL and performance issues.
Role type
Data Warehouse Support Specialist
Builds
Production Data Warehouse environment stability and operational continuity
Domain
Financial services / Data Warehousing
Deliverable
production ML models | product features | dashboards & analysis | infrastructure
Required skills
Relational Database development (Oracle, Sybase IQ, MS SQL Server), Data Warehouse architecture, ETL principles, T-SQL, PL/SQL, Root cause analysis, Operational procedure documentation
Preferred skills
Managing production workloads under time constraints, EOD/EOM business processes knowledge
Technologies
Oracle, Sybase IQ, MS SQL Server, T-SQL, PL/SQL
Responsibilities
Monitor and support the Production Data Warehouse environment daily, Ensure successful execution of EOD and EOM processes, Troubleshoot and resolve ETL job and performance issues, Coordinate with development, infrastructure, and business teams, Perform root cause analysis for incidents, Document and maintain operational procedures and runbooks
Seniority
Individual Contributor