Data Warehouse Lead Developer

Open 31d

Role: Data Warehouse Lead Developer

Experience: 6 to 8 years

Key Responsibilities:

· Design, develop, and maintain complex SQL queries, stored procedures, functions, and views.

· Optimize SQL queries and database performance (indexing, execution plans, tuning).

· Support data extraction, transformation, and reporting requirements.

· Work closely with applications, BI, and data teams to understand data needs.

· Ensure data accuracy, consistency, and integrity across systems.

· Troubleshoot and resolve database-related issues.

· Troubleshooting and resolving job failures or alert triggers

· Support production issues and perform root cause analysis.

· Work independently and collaborate with business, BI, and reporting teams.

Required Skills:

· Strong hands-on experience in Data Warehousing concepts and architecture.

· Strong knowledge of Stored Procedures, Functions, Views, and Triggers

· Hands‑on experience with SQL Server Jobs for scheduling and automation

· Ability to configure and manage Alerts & Notifications for proactive monitoring

· Design, develop, and maintain Data Warehouse solutions.

· Design star/snowflake schemas, fact and dimension tables.

· Ensure data quality, integrity, and performance optimization.

· Support data extraction, transformation, and loading from multiple source systems.

· Expertise in writing complex joins, subqueries, CTEs, and window functions.

· Experience in performance tuning and query optimization.

· Good understanding of relational database design and normalization.

· Experience with stored procedures, triggers, and functions.

· Familiarity with ETL concepts and data warehousing basics.

· Experience with cloud data platforms

Good to Have:

· Experience with Power BI and semantic models.

· Experience in performance optimization and large data volumes.

· Knowledge of CI/CD for data pipelines.

· Experience working in client-facing or onsite–offshore models.

Soft Skills:

· Strong analytical and problem-solving skills.

· Ability to work independently with minimal supervision.

· Good communication and stakeholder management skills.