Lead Data Warehouse Developer

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 monthsThe 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 Requirements5 years troubleshooting complex technical problems involving:NetworkingDatabasesApplicationsServers3 years data modeling for reporting & analytics5 years advanced SQL performance tuning3 years providing technical guidance to software development teams on:Implementing solutionsManaging concurrent tasksHandling complex technical issues3 years guiding teams on:Performance tuningEnterprise data warehouse systemsReporting & analytics optimization5 years Oracle SQL and PL/SQL developmentMust be onsite in Albany, NY for the first 6 monthsPreferred / Bonus Scoring ExperienceAdditional years beyond:5 years troubleshooting3 years data modeling3 years performance tuning guidanceExperience supporting large-scale enterprise DW programsKey ResponsibilitiesDevelop and optimize PL/SQL, stored procedures, and performance tuning scriptsDesign new data warehouse sources and modelsSupport ETL development, including AntiunityBuild, maintain, and optimize data pipelines (cloud/SFTP)Provide technical leadership and guidance to DW teamsOptimize enterprise DW performance and reporting ecosystemsWork with Tableau, OAS, and other analytics/reporting teamsEducation Requirements: Bachelor's in Computer Science, IT, or EngineeringRecruiter 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 #2Contact 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: