Comcast brings together the best in media and technology. We drive innovation to create the world's best entertainment and online experiences. As a Fortune 50 leader, we set the pace in a variety of innovative and fascinating businesses and create career opportunities across a wide range of locations and disciplines. We are at the forefront of change and move at an amazing pace, thanks to our remarkable people, who bring cutting-edge products and services to life for millions of customers every day. If you share in our passion for teamwork, our vision to revolutionize industries and our goal to lead the future in media and technology, we want you to fast-forward your career at Comcast.
This data modeler role has been created to support our Business Intelligence / Data Analysis team for Xfinity Wireless. Through in-depth onboarding and enrichment of data this role helps support critical lines of business in Wireless as well as Product Research. You will also provide summarized information to our Business Intelligence Dashboard developers who will create interactive platforms allowing for day-to-day evaluation of current marketing initiatives. This resource will be primarily responsible for strategic projects that focus on source system knowledge/analysis, complex business requirements, design and delivery, and ETL Specifications. This role is expected to form a deep relationship and partnership with the ETL Development team. You will work closely with all business units; understand their purpose and intended goals so that information can be incorporated into the end result with extreme accuracy.
The ideal candidate will have advanced Data Modeling and Data Warehouse/Business Intelligence skills along with strong Hive ETL Architecture / ETL Development skills. This person will be responsible for helping Comcast develop systems and interfaces in support of a new wireless initiative. The senior data modeler must possess the skill-sets necessary to hit the ground running. You must be comfortable working with extremely large volumes of data and the desire to learn about wireless technologies, sales and marketing businesses while solving problems quickly.
Essential Functions:
- Reviews current data models to understand the as is environment.
- Reviews report design documents to understand where data model structures can address requirements.
- Works with the key business representatives, data owners, end users, application designers and data architect to model the current data (where models do not already exist) and for the to be system.
- Creates logical and physical data models for as is and proposed or to be system.
- Creates entity-relationship diagrams for relational systems and dimensional diagrams for the Data Warehouse, Data Marts and data cubes.
- Works with data architect to define and create required metadata.
- Maintains data models continuously as modifications and enhancements are made.
- Creates data model structures to enhance performance of the application by creating aggregation and summarization structures.
Job Requirements
Minimum Requirements:
- Excellent written, verbal and interpretation skills.
- 8+ years of related responsible experience in large corporate system environments working with and programming large and complex data warehouse systems
- 6+ years of strong SQL (Oracle dialect preferred)
- 5+ years of experience in writing complex ETL packages.
- 5+ years of hands on experience in database and SQL performance tuning.
- 5+ years of experience in developing ETL programs in relational databases
- 5+ years of experience with data analysis, modeling, creating technical documentation
- 3+ years of scripting experience in Linux shell / python / Perl (understanding of Linux environment is a plus)
- 3+ years of experience manipulating XML, JSON, SOAP and other structure file formats
- Excellent understanding of relational database concepts, impact of various design on performance
- Strong experience with data warehousing concepts and data modeling best practices.
- Proficiency in one or more of the following: Java, python, bash, spark, hive, and impala
- Strong knowledge of extremely large database optimization practices (indexing, partitioning, etc.) in Hadoop environment.
Extended Requirements:
- Experience using Hadoop / Cloudera / Impala / Hive
- Experience with industry standard version control systems-like CVS or SVN or GIT
- Extensive experience working with Business Intelligence data visualization tools, optimally with specialization on Tableau versions 9 and higher.
- Experience in a Cable, Telcom or a Wireless company is a plus.
Comcast is an EOE/Veterans/Disabled/LGBT employer
Comcast is an EOE/Veterans/Disabled/LGBT employer
by via developer jobs - Stack Overflow
No comments:
Post a Comment