This job has expired, please see additional jobs below
Sr. Architect, Data Warehouse/ETL (Pentaho)
Comcast
Philadelphia, PA, United States
Job Details - this job has expired, please see similar jobs below
Job Responsibilities:
Position Summary:
This is a senior position within the Strategic Development organization reporting to the Director of Database. This group has responsibility for Analytical Data Service for Comcast, one of the major goal is to harmonize the data ingestion and consumption layer across Comcast. The group has responsibility for creating the EDW-Enterprise Data Warehouse to serve as a single version of truth for data analysis for Comcast technical/business requirements.
This position will be responsible for designing, developing, testing, tuning and the deployment of software solutions within the Teradata and Hadoop Ecosystems. The Engineer will work closely with the administrators and application teams to insure business applications are highly available and performing within agreed upon service levels. This position will also work closely with business, architects and other development teams in an agile manner to quickly realize business value. The Engineer will play a lead role in these activities with a focus on successful and timely execution of the following responsibilities:
-The engineer will be the Extract-Transform-Load (ETL) master architect of scalable, well-performing, cohesive, and integrated ETL processes for the data warehouse, intermediate data stores, and data marts for source data acquisition, data hygiene, staging, transformations, loading, error handling, updating, change control, integration, and data transmission to partner organizations.
-Five to seven years leading data warehousing design and development as an ETL Lead, ETL Architect, Senior DW developer, DW consultant, or similar role required.
-Provides direction for diverse and complex initiatives and is accountable for a variety of tasks to architect and deliver data warehousing solutions that exceed customer expectations in content, usability, accuracy, reliability and performance while assuming a leading role within agile teams (both on-shore and off-shore).
-Interprets business strategy and develops organizational objectives to align with this strategy. Typically manages multiple teams of professionals.
-Development of End to End ETL architecture within the Oracle, Teradata, NoSQL and Hadoop Environments
-Solid Experience with SQL & BTEQ Scripting: Strong data management and data analysis and performance tuning required.
-Preferred experience with Hive, Pig, Flume, Sqoop, Kafka, and Storm
-Strong skills in data warehousing process design and development using the Informatica data warehousing tool suite required. (PowerCenter, IDQ)
-Conscientious of Enterprise Data Warehouse Release management process; Conduct Operations readiness and environment compatibility review of any changes prior to deployment with strong sensitivity around Impact and SLA
-Experience with data modeling tools a plus.
-Expert in data warehousing methodologies and best practices required.
-Strong verbal and written communication skills required.
-Effective interpersonal relations skills, ability to effectively collaborate with others and work as part of a team required.
-Skills in navigating a large organization in order to accomplish results required
-Ability to initiate and follow through on complex projects of both short and long term duration required.
-Excellent organizational and time management skills required.
-Excellent analytical and problem solving skills required.
-Works independently, assumes responsibility for job development and training, researches and resolves questions and problems, requests supervisor input and keeps supervisor informed required.
-Develop strong team relationships with Tier 1, Tier 2, and Tier 3 support team for problem resolution and root cause.
-Proactive recommendation for improving the performance and operability of the data warehouse and reporting environment.
-Participate on interdepartmental teams to support organizational goals
-Perform other related duties and tasks as assigned
-Punctual, regular, and consistent attendance
Required Skills/Experience:
-Advanced Degree in technical discipline preferred or equivalent work experience.
-Generally requires 7-11 years related experience
-Strong preference End to End System Data Warehouse and ETL Architecture with a minimum 5 years' experience within Oracle and Hadoop Ecosystems.
-End to End System Data Warehouse and ETL Architecture
-Requires understanding of complete SDLC and Experience with continuous integration, test-driven/behavior-driven development, and agile development methodologies
-Five to seven years leading data warehousing design and development as an ETL Lead, ETL Architect, Senior DW developer, DW consultant, or similar role required.
-Development of End to End ETL architecture using Linux, Informatica, Teradata, SQL, BTEQ, Hadoop Hive, Pig, Flume, Sqoop, and UC4
-Experience facilitating user sessions and gathering requirements
-Experience designing logical and physical architectures for data warehousing solutions
-Experience managing teams of senior technologists
-Experience working in an Agile development methodology in a data warehouse environment
-Ability to work effectively across organizational boundaries
-Excellent oral, written, analytical, problem solving, and presentation skills
-Manage and Co-ordinate 1-5 team resources, Matrix resources and off-shore management
-Experience with mange service and on-shore and off-shore development experience is must
Desired Skills/Experience:
-Pentaho experience is strongly preferred
-Telecommunications experience Knowledge of Telecommunication/Cable billing, customer care systems e.g. DST, CSG and AMDOC etc.
-Two plus years of Java programming, SOA, and software architecture
-Knowledge of Java virtual machines (JVM) and multithreaded processing
-Knowledge of NoSQL/AWS/Cloudera platforms
-Hadoop Developer Certified
Comcast is an EEO/AA/ Drug Free Workplace
Comcast is an EOE/Veterans/Disabled/LGBT employer