JOB SUMMARYThe ETL Developer will be responsible for the administration and development of ETL processes in support of analytics and reporting functions. ETL Administration includes automation, monitoring, and alerts for ETL processes. ETL development includes bringing data from various sources in support of the Enterprise Data Warehouse, or ad-hoc analytics. The developer will also be responsible for insuring data integrity, and providing detailed documentation of developed processes.MAJOR DUTIES AND RESPONSIBILITIESActively and consistently support all efforts to simplify and enhance the customer experienceResponsible for the ongoing operation of the data warehouse and analytic environments to include advanced technical issues such as ETL performance tuning.Design extensions and enhancements and ability to enhance the schema and ETL process in order to provide functionality and performance.Manage data integrity and accuracy of the data warehouse data and analytic environments.Develop optimized SQL to implement ETL job steps using ETL tools such as Informatica, SSIS, or Pentaho.Monitor, diagnose and repair all data loading and processing packages to ensure data integrity of the analysis data.Support ongoing user issues in the use of the systems.Communicate data warehouse and enhancements to the DBA from the requested analysis enhancements.Perform data profiling to insure efficient and accurate delivery of data.Other duties as requested by supervisor.REQUIRED QUALIFICATIONSSkills/Abilities and KnowledgeAbility to read, write, speak and understand EnglishProficiency in SQL query development and performanceProficiency with Unix/Linux shell scriptsFully trained on the operation of Informatica, SSIS, Pentaho, or other ETL toolsExperience in developing Informatica, SSIS, Pentaho, or other ETL toolsExperience with formal data warehouse architectureDemonstrated skills with troubleshooting and resolving technical issuesProven ability and desire to learn and apply current technology to data analysis solutionsExperience with business information reconciliationExperience with training staff on the use of ETL toolsExperience in designing data warehouse schema from business requirementsEducationBS degree in Information Technology; MBA, MIS or equivalent preferredRelated Work Experience Number of YearsData warehouse operations and development 5+PREFERRED QUALIFICATIONSSkills/Abilities and KnowledgeInformatica certificationExperience in TeradataExperience in HadoopExperience in developing SSIS ETL packages and SSAS OLAP cubesWorking knowledge of SSRSDatabase Administrator certification or equivalent knowledgeBusiness Intelligence Developer certification or equivalent knowledgeEducationBS degree in Information Technology; MBA, MIS or equivalent preferredRelated Work Experience Number of YearsData warehouse operations responsibilities 3+Data warehouse operations and development 3+Media business operations experience may be applicable 5+WORKING CONDITIONSOffice environmentTravel as requiredEOE Race/Sex/Vet/DisabilityCharter is an equal opportunity employer that complies with the laws and regulations set forth in the following EEO Is the Law poster: http://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdfCharter is committed to diversity, and values the ways in which we are different.
A little about us:
Spectrum is the nation’s fastest growing TV, internet and voice company. We’re committed to integrating the highest quality service with superior entertainment and communications products.