Lead Data Warehouse DeveloperLocation: 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-FridayOnsite Requirement: Must be onsite in Albany, NY for minimum first 6 months
The Lead Data Warehouse Developer will serve in a
senior 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 providing technical 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 Oracle SQL 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 optimize PL/SQL, stored procedures, and performance tuning scripts
- Design new data warehouse sources and models
- Support ETL development, including Antiunity
- Build, maintain, and optimize data pipelines (cloud/SFTP)
- Provide technical 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: 
