{"schemaVersion":"jobsearcher.job.v1","id":"e15a1ada0cdf3de6b83f2a54","url":"https://jobsearcher.com/jobs/e15a1ada0cdf3de6b83f2a54","canonicalUrl":"https://jobsearcher.com/jobs/e15a1ada0cdf3de6b83f2a54","title":"Lead ETL Data Warehousing SQL (Azure)","description":"Lead Etl Data Warehousing Sql (Azure)Location: Dallas, TX (Onsite)Only on W2 OR Own corporationQualifications:15+ years of experience in ETL & Data WarehousingExcellent leadership & communication skillsIn depth knowledge on SSIS ETL Tool and good working knowledge on Power BIWorked on data sources such as SAP and SalesforceVery good knowledge of SSIS (ETL Tool), StreamSets (ETL Tool), Azure Cloud, ADF, Azure Synapse Analytics & Azure Hub EventsExecuted at least 2 Azure Cloud Data Warehousing projectsWorked at least 4 projects using Agile/SAFe methodologyDemonstrated working knowledge on ITIL V4 concepts such as Incident Management, Problem Management, Change Management & Knowledge ManagementWorking experience on any DevOps tools like GitHub, Jenkins, etc & on semi-structured data formats like JSON, Parquet and/or XML files & written complex SQL queries for data analysis and extractionIn depth understanding on Data Warehousing, Data Analysis, Data Profiling, Data Quality & Data MappingCross global location experience and led a team of at least 15+ members in a global delivery modelExperience in working with product managers, project managers, business users, applications development team members, DBA teams and Data Governance team on a daily basis to analyze requirements, design, development and deployment technical solutionsResponsibilities:Lead nearshore and offshore team to do production support of existing EDW, design, build & deploy enhancements and bug fixes to existing EDWSupport the existing EDW system built using Azure SQL, Microsoft SSIS, StreamSets & Power BIBe on call to support job incidents on rotational basisWork with business and technology stakeholders to communicate EDW incidents/problems and manage their expectationsLeverage ITIL concepts to circumvent incidents, manage problems and document knowledgeAnalyze the different source systems, profile data, understand, document & fix Data Quality issuesGather requirements and business process knowledge in order to transform the data in a way that is geared towards the needs of end usersWrite complex SQLs to extract & format source data for ETL/data pipelineCreate design documents, Source to Target Mapping documents and any supporting documents needed for deployment/migrationDesign, Develop and Test ETL/Data pipelinesWrite Unit Test cases, execute Unit Testing and document Unit Test resultsDeploy ETL/Data pipelinesUse DevOps tools to version, push/pull code and deploy across environmentsSupport team during troubleshooting & debugging defects & bug fixes, business requests, environment migrations & other adhoc requestsMaintain and improve already existing processesETL - StrongSSIR, SSRS - StrongSQL - StrongData Warehousing - StrongAzure, Azure data factory --Min expPower BI - Min ExpDash boards creation -- StrongThanks & RegardsMohan saiTechnical recruiterPhone# +1-619-605-0324|mohan.sai@stiorg.comSoftware Technology, Incwww.stiorg.","company":"Software Technology","rawCompany":"software technology","city":"Dallas","state":"TX","isRemote":false,"isActive":false,"createdAt":"2026-08-25T09:02:00.521Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"}],"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 ETL Data Warehousing SQL (Azure)","description":"Lead Etl Data Warehousing Sql (Azure)Location: Dallas, TX (Onsite)Only on W2 OR Own corporationQualifications:15+ years of experience in ETL & Data WarehousingExcellent leadership & communication skillsIn depth knowledge on SSIS ETL Tool and good working knowledge on Power BIWorked on data sources such as SAP and SalesforceVery good knowledge of SSIS (ETL Tool), StreamSets (ETL Tool), Azure Cloud, ADF, Azure Synapse Analytics & Azure Hub EventsExecuted at least 2 Azure Cloud Data Warehousing projectsWorked at least 4 projects using Agile/SAFe methodologyDemonstrated working knowledge on ITIL V4 concepts such as Incident Management, Problem Management, Change Management & Knowledge ManagementWorking experience on any DevOps tools like GitHub, Jenkins, etc & on semi-structured data formats like JSON, Parquet and/or XML files & written complex SQL queries for data analysis and extractionIn depth understanding on Data Warehousing, Data Analysis, Data Profiling, Data Quality & Data MappingCross global location experience and led a team of at least 15+ members in a global delivery modelExperience in working with product managers, project managers, business users, applications development team members, DBA teams and Data Governance team on a daily basis to analyze requirements, design, development and deployment technical solutionsResponsibilities:Lead nearshore and offshore team to do production support of existing EDW, design, build & deploy enhancements and bug fixes to existing EDWSupport the existing EDW system built using Azure SQL, Microsoft SSIS, StreamSets & Power BIBe on call to support job incidents on rotational basisWork with business and technology stakeholders to communicate EDW incidents/problems and manage their expectationsLeverage ITIL concepts to circumvent incidents, manage problems and document knowledgeAnalyze the different source systems, profile data, understand, document & fix Data Quality issuesGather requirements and business process knowledge in order to transform the data in a way that is geared towards the needs of end usersWrite complex SQLs to extract & format source data for ETL/data pipelineCreate design documents, Source to Target Mapping documents and any supporting documents needed for deployment/migrationDesign, Develop and Test ETL/Data pipelinesWrite Unit Test cases, execute Unit Testing and document Unit Test resultsDeploy ETL/Data pipelinesUse DevOps tools to version, push/pull code and deploy across environmentsSupport team during troubleshooting & debugging defects & bug fixes, business requests, environment migrations & other adhoc requestsMaintain and improve already existing processesETL - StrongSSIR, SSRS - StrongSQL - StrongData Warehousing - StrongAzure, Azure data factory --Min expPower BI - Min ExpDash boards creation -- StrongThanks & RegardsMohan saiTechnical recruiterPhone# +1-619-605-0324|mohan.sai@stiorg.comSoftware Technology, Incwww.stiorg.","datePosted":"2026-08-25T09:02:00.521Z","dateModified":"2026-08-25T09:02:00.521Z","hiringOrganization":{"@type":"Organization","name":"Software Technology","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Dallas","addressRegion":"TX","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"e15a1ada0cdf3de6b83f2a54"},"url":"https://jobsearcher.com/jobs/e15a1ada0cdf3de6b83f2a54"}}