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: Networking, Databases, Applications, Servers3 years data modeling for reporting & analytics5 years advanced SQL performance tuning3 years providing technical guidance to software development teams on: Implementing solutions, Managing concurrent tasks, Handling complex technical issues3 years guiding teams on: Performance tuning, Enterprise data warehouse systems, Reporting & 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 troubleshooting, 3 years data modeling, 3 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 Engineering