What are the responsibilities and job description for the Lead Data Warehouse Developer position at Veracity Software Inc?
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 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
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:
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 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
- Additional years beyond:
- 5 years troubleshooting
- 3 years data modeling
- 3 years performance tuning guidance
- Experience supporting large-scale enterprise DW programs
- 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
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: