{"schemaVersion":"jobsearcher.job.v1","id":"bd1a47e9638a0451db0906d6","url":"https://jobsearcher.com/jobs/bd1a47e9638a0451db0906d6","canonicalUrl":"https://jobsearcher.com/jobs/bd1a47e9638a0451db0906d6","title":"Lead Data Warehouse Developer","description":"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","company":"Veracity Solutions","rawCompany":"veracity solutions","city":"Albany","state":"NY","isRemote":false,"isActive":false,"createdAt":"2026-08-25T04:09:53.252Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Lead Data Warehouse Developer","description":"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","datePosted":"2026-08-25T04:09:53.252Z","dateModified":"2026-08-25T04:09:53.252Z","hiringOrganization":{"@type":"Organization","name":"Veracity Solutions","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Albany","addressRegion":"NY","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"bd1a47e9638a0451db0906d6"},"url":"https://jobsearcher.com/jobs/bd1a47e9638a0451db0906d6"}}