About the role
Responsibilities:
- Design, develop, and maintain data warehouse schemas, tables, views, and materialized views.
- Write complex MS SQL scripts for data extraction, transformation, and loading (ETL).
- Optimize database performance through query tuning, indexing, and partitioning.
- Develop and maintain stored procedures, functions, triggers, and packages.
- Collaborate with data architects, business analysts, and BI teams to translate business requirements into technical solutions.
- Ensure data accuracy, consistency, and security across the warehouse environment.
- Support production systems by monitoring jobs, troubleshooting failures, and resolving issues promptly.
- Participate in code reviews and contribute to improving data development standards and best practices.
- Document ETL workflows, data mappings, and database structures.
Requirements:
- 6-9 years of hands-on experience in MS SQL Server development.
- Solid understanding of data warehouse concepts, star/snowflake schema, and dimensional modeling.
- Experience with Python is a plus.
- Strong analytical and troubleshooting skills.