{"schemaVersion":"jobsearcher.job.v1","id":"ccd7c545f90ea5d0256c50a8","url":"https://jobsearcher.com/jobs/ccd7c545f90ea5d0256c50a8","canonicalUrl":"https://jobsearcher.com/jobs/ccd7c545f90ea5d0256c50a8","title":"Lead Snowflake Data Engineer","description":"Position overview:\r\nWe are looking for a hands-on Lead Data Engineer to join our team! In this role, you will be responsible for leading the team of data engineers (Onsite/Offshore) to build new data pipelines (loading millions of transformed true records into our cloud data warehouse in a timely manner) to support evolving analytical needs for critical business decisions. Manage existing data pipelines keeping data relevant and true, ready for analytical consumption.\r\nKey responsibilities\r\n\r\nLead data warehouse development activities for a team,\r\nLead more than one project in parallel.\r\nAssign data warehouse development tasks to team of 1-6 developers (Onsite/Offshore).\r\nBe a subject-matter expert (SME) in Data Warehouse domain and relevant business function.\r\nWork with minimal supervision and provide status updates and escalation to leadership as appropriate.\r\nProvides application support as partof an on-call rotation to work on resolving outages and user questions.\r\nReview project objectives and determine best technology to apply.\r\nDesign and build large scale datasets for a wide range of consumer needs.\r\nBuild, test and implement highly efficient data pipelines using a variety of technologies.\r\nDevelop best practice standards for solution design and data structures.\r\nCreate and maintain project specific documentation like architecture diagrams, flow charts\r\nAnalyze new data sources to understand quality, availability, and content.\r\nWrite technical design documentation.\r\nConducts peer code reviews.\r\nCreate and executes unit tests.\r\nSupports QA team during testing.\r\nMentor less experienced members of the development team.\r\n\r\nTechnical skills\r\n\r\n6 years+ experience on Snowflake SQL – advanced SQL expertise\r\n6 years+ experience on data warehouse experiences – hands on knowledge with the methods to identify, collect, manipulate, transform, normalize, clean, and validate data, star schema, normalization / denormalization, dimensions, aggregations etc,\r\n6 years+ experience working in reporting and analytics environments – development, data profiling, metric development, CICD, production deployment, troubleshooting, query tuning, Atlassian Bitbucket and Bamboo etc,\r\n4 years+ on Python – advanced Python expertise\r\n4 years+ on any cloud platform – AWS preferred\r\no Hands on experience on AWS on Lambda, S3, SNS / SQS, EC2 is a bare minimum,\r\n4 years+ on any ETL / ELT tool – Informatica, Pentaho, Fivetran, DBT etc.\r\n4 years+ with developing functional metrics in any specific business vertical (finance, retail, telecom etc),\r\n\r\nMust have soft skills\r\nEnterprise Experience – Understands and follows enterprise guidelines for CICD, security, change management, RCA, on-call rotation etc,\r\nNice to have\r\nTechnical certifications from AWS, Microsoft, Azure, GCP or any other recognized Software vendor,\r\n4 years+ on any ETL / ELT tool – Informatica, Pentaho, Fivetran, DBT etc.\r\n4 years+ with developing functional metrics in any specific business vertical (finance, retail, telecom etc),\r\n4 years+ with team lead experience,\r\n3 years+ in a large-scale support organization supporting thousands of users,\r\nJ-18808-Ljbffr","company":"TechDigital Group","rawCompany":"techdigital group","city":"Rosemont","state":"IL","isRemote":false,"isActive":false,"createdAt":"2026-08-08T01:06:47.940Z","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-2051.00","title":"Data Scientists","slug":"data-scientists"}],"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 Snowflake Data Engineer","description":"Position overview:\r\nWe are looking for a hands-on Lead Data Engineer to join our team! In this role, you will be responsible for leading the team of data engineers (Onsite/Offshore) to build new data pipelines (loading millions of transformed true records into our cloud data warehouse in a timely manner) to support evolving analytical needs for critical business decisions. Manage existing data pipelines keeping data relevant and true, ready for analytical consumption.\r\nKey responsibilities\r\n\r\nLead data warehouse development activities for a team,\r\nLead more than one project in parallel.\r\nAssign data warehouse development tasks to team of 1-6 developers (Onsite/Offshore).\r\nBe a subject-matter expert (SME) in Data Warehouse domain and relevant business function.\r\nWork with minimal supervision and provide status updates and escalation to leadership as appropriate.\r\nProvides application support as partof an on-call rotation to work on resolving outages and user questions.\r\nReview project objectives and determine best technology to apply.\r\nDesign and build large scale datasets for a wide range of consumer needs.\r\nBuild, test and implement highly efficient data pipelines using a variety of technologies.\r\nDevelop best practice standards for solution design and data structures.\r\nCreate and maintain project specific documentation like architecture diagrams, flow charts\r\nAnalyze new data sources to understand quality, availability, and content.\r\nWrite technical design documentation.\r\nConducts peer code reviews.\r\nCreate and executes unit tests.\r\nSupports QA team during testing.\r\nMentor less experienced members of the development team.\r\n\r\nTechnical skills\r\n\r\n6 years+ experience on Snowflake SQL – advanced SQL expertise\r\n6 years+ experience on data warehouse experiences – hands on knowledge with the methods to identify, collect, manipulate, transform, normalize, clean, and validate data, star schema, normalization / denormalization, dimensions, aggregations etc,\r\n6 years+ experience working in reporting and analytics environments – development, data profiling, metric development, CICD, production deployment, troubleshooting, query tuning, Atlassian Bitbucket and Bamboo etc,\r\n4 years+ on Python – advanced Python expertise\r\n4 years+ on any cloud platform – AWS preferred\r\no Hands on experience on AWS on Lambda, S3, SNS / SQS, EC2 is a bare minimum,\r\n4 years+ on any ETL / ELT tool – Informatica, Pentaho, Fivetran, DBT etc.\r\n4 years+ with developing functional metrics in any specific business vertical (finance, retail, telecom etc),\r\n\r\nMust have soft skills\r\nEnterprise Experience – Understands and follows enterprise guidelines for CICD, security, change management, RCA, on-call rotation etc,\r\nNice to have\r\nTechnical certifications from AWS, Microsoft, Azure, GCP or any other recognized Software vendor,\r\n4 years+ on any ETL / ELT tool – Informatica, Pentaho, Fivetran, DBT etc.\r\n4 years+ with developing functional metrics in any specific business vertical (finance, retail, telecom etc),\r\n4 years+ with team lead experience,\r\n3 years+ in a large-scale support organization supporting thousands of users,\r\nJ-18808-Ljbffr","datePosted":"2026-08-08T01:06:47.940Z","dateModified":"2026-08-08T01:06:47.940Z","hiringOrganization":{"@type":"Organization","name":"TechDigital Group","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Rosemont","addressRegion":"IL","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"ccd7c545f90ea5d0256c50a8"},"url":"https://jobsearcher.com/jobs/ccd7c545f90ea5d0256c50a8"}}