Data Warehouse Lead Developer

Devoir Software Solutions Pvt Ltd; Chennai District; On-site; INR 700,000 - 1,100,000; Full time

Job summary

Devoir Software Solutions Pvt Ltd in Chennai, India, seeks a Data Warehouse Engineer to design, implement, and optimize large SQL-based data pipelines. You will work with analytics, BI, and applications teams to deliver reliable data models, robust ETL, and scalable warehouse solutions.

The role requires strong SQL and DW concepts, with opportunities to leverage Power BI for semantic models and dashboards in a client-facing environment.

Qualifications

• 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

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.

Skills

Data warehousing concepts

Stored procedures

Functions

Views

Triggers

SQL Server jobs

Alerts & Notifications

Data warehouse solutions

Star schema

Snowflake schema

Fact and dimension tables

ETL concepts

Cloud data platforms

Tools

Power BI

CI/CD for data pipelines

Job description

• Design, develop, andmaintain complex SQL queries, stored procedures, functions, and views.
• Optimize SQL queries anddatabase performance (indexing, execution plans, tuning).
• Support data extraction,transformation, and reporting requirements.
• Work closely withapplications, BI, and data teams to understand data needs.
• Ensure data accuracy,consistency, and integrity across systems.
• Troubleshoot and resolvedatabase-related issues.
• Troubleshooting and resolving job failures or alert triggers
• Support productionissues and perform root cause analysis.
• Work independently and collaborate with business, BI, andreporting teams.

Required Skills:

• Strong hands-onexperience in Data Warehousing concepts and architecture.
• Strong knowledge ofStored Procedures, Functions, Views, and Triggers
• Hands‑on experience withSQL Server Jobs for scheduling and automation
• Ability to configure andmanage Alerts & Notifications for proactive monitoring
• Design, develop, andmaintain Data Warehouse solutions.
• Design star/snowflakeschemas, fact and dimension tables.
• Ensure data quality,integrity, and performance optimization.
• Support data extraction,transformation, and loading from multiple source systems.
• Expertise in writingcomplex joins, subqueries, CTEs, and window functions.
• Experience inperformance tuning and query optimization.
• Good understanding ofrelational database design and normalization.
• Experience with storedprocedures, triggers, and functions.
• Familiarity with ETLconcepts and data warehousing basics.
• Experience with clouddata platforms

Good to Have:

• Experience with Power BIand semantic models.
• Experience inperformance optimization and large data volumes.
• Knowledge of CI/CD fordata pipelines.
• Experience working in client-facing or onsite–offshore models.

Soft Skills:

• Strong analytical andproblem-solving skills.
• Ability to workindependently with minimal supervision.
• Good communication and stakeholder management skills.