Back to jobs

Data Warehouse Lead Developer

Pay
Pay not listed
Work setting
On-site — work setting source
Work setup in the employer’s posting: On-site
From the employer’s posting
Employment
Full-time — employment source
Employment type in the employer’s posting: Full time
From the employer’s posting

What you’ll work on

Full posting
  • Design, develop and maintain complex SQL queries, stored procedures, functions and views

  • Optimize SQL queries and database performance, including indexing and execution plans

  • Troubleshoot job failures, alert triggers and production issues with root cause analysis

  • Support data extraction, transformation and reporting requirements

  • Ensure data accuracy, consistency and integrity across systems

From the employer’s posting
Design, develop, and maintain complex SQL queries, stored procedures, functions, and views.
Optimize SQL queries and database performance (indexing, execution plans, tuning).
Support production issues and perform root cause analysis.
Support data extraction, transformation, and reporting requirements.
Ensure data accuracy, consistency, and integrity across systems.

What you’ll bring

All qualifications

Core experience

  • 6 to 8 years of experience
  • Strong hands-on experience in data warehousing concepts and architecture
  • Hands-on SQL Server Jobs, Alerts and stored procedure, trigger and function skills
  • Expertise in complex joins, subqueries, CTEs and window functions
  • Experience with cloud data platforms
Qualification wording
Experience: 6 to 8 years
Strong hands-on experience in Data Warehousing concepts and architecture.
Hands‑on experience with SQL Server Jobs for scheduling and automation
Expertise in writing complex joins, subqueries, CTEs, and window functions.
Experience with cloud data platforms

Tools in this posting

  • SQL
  • Power BI
  • SQL Server
Source — Tool mentions in context
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.
Check the employer’s page ↗

Posting record

Report an error

Open 5 monthsWe first saw this posting 172 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.

Status in our records
Live
First seen by us
Jun 3, 2026172 days ago
Recorded sightings
87
Last seen by us
Nov 21, 2026
Employer says posted
Jan 14, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 172

Up longer than most. Similar jobs usually come down between day 6 and day 56.

From 14,771 similar postings that came down. Coming down is not always a hire.

Devoir Software Solutions is hiring

1 open job

  • No new data jobs since June
Hiring record

Your next step

Check the employer’s posting for the current role and application details.

Already applied? Track this application

Job description

View original posting ↗

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.

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Saidapet, Tamil Nadu, India

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

AI answers unavailable

We couldn’t identify enough role detail in this saved description to support an AI answer. Read the full posting