Description

You will design, develop, and optimize data warehouse solutions for business analytics and reporting.

This role is remote.

Responsibilities

• Design 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 and BI teams to translate business requirements into technical solutions.

Required Skills

• 10+ years of hands-on experience in MS SQL Server development.
• Solid understanding of data warehouse concepts, including star/snowflake schemas and dimensional modeling.
• Experience building efficient ETL processes.
• Proficiency in MS SQL for data extraction, transformation, and loading.
• Experience in performance tuning and query optimization.
• Strong analytical and troubleshooting skills.
• Ability to document ETL workflows, data mappings, and database structures.

Key Skills

Education

Any Graduate