Senior Data Warehouse Developer

Job Description:

We are seeking a Datawarehouse Developer with strong ETL and MS SQL skills. Primary and secondary skills should include Datawarehouse Development with hands-on ETL and MS SQL experience.

Key Responsibilities

• Design, build, and maintain data warehouse schemas, tables, views, and materialized views.

• Create advanced MS SQL scripts to support data extraction, transformation, and loading (ETL).

• Improve and maintain database performance using query tuning, indexing, and partitioning.

• Develop and manage stored procedures, functions, triggers, and packages.

• Partner with data architects, business analysts, and BI teams to convert business needs into technical implementations.

• Maintain data accuracy, consistency, and security throughout the data warehouse environment.

• Back production systems by monitoring scheduled jobs, diagnosing failures, and resolving issues in a timely manner.

• Participate in code reviews and help elevate data engineering standards and best practices.

• Document ETL workflows, data mappings, and database structures.

Required Skills & Qualifications

• 5-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.

• Experience in performance tuning and query optimization.

• Good communication skills and ability to work collaboratively in a team environment.

Preferred Skills (Nice to Have)

• Good understanding of Capital Markets domain is a plus