Lead Data Warehouse Developer

Lead Data Warehouse Developer

Location: Albany, NY 12236 (Hybrid – up to 50% remote with approval)
Contract: 5-Year Contract | (Minimum 6-Month Commitment Before Replacement)

Work Hours: 40 hrs / week | Monday–Friday

Onsite Requirement: Must be onsite in Albany, NY for minimum first 6 months

The Lead Data Warehouse Developer will serve in asenior technical capacity, responsible for troubleshooting complex system issues, designing enterprise data models, developing and tuning SQL/PL/SQL programs, and guiding development teams. The resource must possess strong leadership skills and hands-on expertise to support enterprise data warehouse initiatives, performance optimization, ETL development, cloud/SFTP data pipelines, and advanced reporting environments.

Mandatory Experience Requirements

• 5 years troubleshooting complex technical problems involving:
  • Networking
  • Databases
  • Applications
  • Servers
• 3 years data modeling for reporting & analytics
• 5 years advanced SQL performance tuning
• 3 years providingtechnical guidance to software development teams on:
  • Implementing solutions
  • Managing concurrent tasks
  • Handling complex technical issues
• 3 years guiding teams on:
  • Performance tuning
  • Enterprise data warehouse systems
  • Reporting & analytics optimization
• 5 years OracleSQL and PL/SQL development
• Must be onsite in Albany, NY for the first 6 months

Preferred / Bonus Scoring Experience

• Additional years beyond:
  • 5 years troubleshooting
  • 3 years data modeling
  • 3 years performance tuning guidance
• Experience supporting large-scale enterprise DW programs

Key Responsibilities

• Develop and optimizePL/SQL, stored procedures, and performance tuning scripts
• Design newdata warehouse sources and models
• SupportETL development, including Antiunity
• Build, maintain, and optimizedata pipelines (cloud/SFTP)
• Providetechnical leadership and guidance to DW teams
• Optimize enterprise DW performance and reporting ecosystems
• Work with Tableau, OAS, and other analytics/reporting teams

Education Requirements:Bachelor's in Computer Science, IT, or Engineering

Recruiter Submission Template –

Full Name:
Highest Degree (Field, University & Completion Year):

Total experience as Lead Data Warehouse Developer?
Do you have at least 5 years troubleshooting complex technical problems (networking, databases, applications, servers)?
Do you have at least 3 years of data modeling experience for reporting & analytics?
Do you have at least 5 years SQL & PL/SQL development in Oracle?
Do you have at least 5 years SQL performance tuning experience?
Do you have at least 3 years providing technical guidance to software development teams?
Do you have at least 3 years guiding teams on performance tuning and enterprise DW systems?
Do you have strong experience with ETL development (Attunity or similar tools)?
Do you have experience building data pipelines (cloud/SFTP)?
Are you able to work onsite in Albany, NY for the first 6 months (mandatory)?
Do you reside within the contiguous United States?
Total Years of Overall DW/ETL/SQL Experience:
Motivation for Interest in This Position:
Contact Number:
Email ID:
LinkedIn Profile URL:
Full Address (Street, City, State, Zip):
Notice Period (in weeks):
Current Work Authorization Status (e.g., US Citizen, Green Card, H1B, etc.):
Expected Hourly Rate:

Is it W2 / C2C, If C2C, May I know your corporation name?
Are you ready to relocate on your own expenses at Albany, NY and commit to the minimum 6-month onsite requirement and full-time 40 hrs/week schedule?

Professional References (3 Required):

Reference Company #1:

Contact Person:

Address:

City, State, Zip:

Telephone Number:

Email Address:

Number of years Proposer or candidate provided services to this entity:

Brief description of the services provided:

Reference Company #2

Contact Person:

Address:

City, State, Zip:

Telephone Number:

Email Address:

Number of years Proposer or candidate provided services to this entity:

Brief description of the services provided:

Reference Company #3:

Contact Person:

Address:

City, State, Zip:

Telephone Number:

Email Address:

Number of years Proposer or candidate provided services to this entity:

Brief description of the services provided: