Database Analyst
Core
Manage enterprise-level SQL Server databases, optimize performance, and support data warehousing infrastructure for Deloitte's internal applications and system integrations.
Role type
Database Analyst (IC)
Builds
Enterprise database environments, data warehouse architectures, and ETL pipelines
Domain
Technology / Data Management / Cloud Infrastructure
Deliverable
production ML models | product features | dashboards & analysis | infrastructure
Required skills
SQL Server administration, Azure PaaS SQL, ETL/ELT processes (Azure Data Factory, SSIS), dimensional modeling, CI/CD automation, Power BI, SSAS Tabular
Preferred skills
Data normalization, slowly changing dimensions, troubleshooting complex database issues
Technologies
Microsoft SQL Server, Azure PaaS SQL, Azure Data Factory, SSIS, SSRS, Azure DevOps, Power BI, SSAS Tabular
Responsibilities
Design and implement databases for local applications and system integrations; performance-tune complex queries; manage SQL Server databases (optimization, patching, support); provide Level 2 and 3 support for database issues; perform routine maintenance and release deployment activities; support Business Continuity and Disaster Recovery efforts; ensure security and compliance through monitoring and logging; contribute to Data Warehousing projects and optimize cloud data infrastructure; develop and maintain comprehensive documentation for system configurations.
Seniority
Mid-level, hands-on IC