Sr. Analyst, Data Management (Multiple Openings)-7160
Apply NowCompany: Comcast
Location: Philadelphia, PA 19102
Description:
Job Summary
Job Description
DUTIES: Contribute to a team responsible for providing data, metrics, reporting assets, and data self service capabilities to enable informed business decisions that drive profitable growth; participate in the complete project lifecycle for new data integration, integrity, and standardization; write complex SQL queries to perform Extract, Transform, and Load (ETL) processes on data; process large data sets from multiple applications and platforms, using Teradata, AWS, Hadoop, and Horton Works; create technical and data quality requirements using source to target mapping (STTM), pseudo code, and Data Quality rule logic; perform User Acceptance Testing; perform post-deployment validation, including designing tables and storing procedures, views, and functions; collaborate across multiple teams to understand business needs, analyze complex data, and integrate Sales & Marketing data with other Comcast data assets; work with business units to document the requirements for enterprise base and semantic layers; identify and build source to target mapping for Sales & Marketing data attributes; develop the business rules and logic to harmonize data; own the creation and execution of test plans; and support standardization efforts for referential data used for data analysis and project output.
REQUIREMENTS: Bachelor's degree, or foreign equivalent, in Computer Science, Engineering, or related technical field, and two (2) years of experience writing complex SQL queries to perform Extract, Transform, and Load (ETL) processes on data; processing data using Teradata and Hadoop; creating technical and data quality requirements using source to target mapping (STTM), pseudo code, and Data Quality rule logic; performing User Acceptance Testing; and performing post-deployment validation, including designing tables and storing procedures, views, and functions; of which one (1) year of experience includes using AWS.
Disclaimer: This information has been designed to indicate the general nature and level of work performed by employees in this role. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications.
Comcast is proud to be an equal opportunity workplace. We will consider all qualified applicants for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability, veteran status, genetic information, or any other basis protected by applicable law.
Job Description
DUTIES: Contribute to a team responsible for providing data, metrics, reporting assets, and data self service capabilities to enable informed business decisions that drive profitable growth; participate in the complete project lifecycle for new data integration, integrity, and standardization; write complex SQL queries to perform Extract, Transform, and Load (ETL) processes on data; process large data sets from multiple applications and platforms, using Teradata, AWS, Hadoop, and Horton Works; create technical and data quality requirements using source to target mapping (STTM), pseudo code, and Data Quality rule logic; perform User Acceptance Testing; perform post-deployment validation, including designing tables and storing procedures, views, and functions; collaborate across multiple teams to understand business needs, analyze complex data, and integrate Sales & Marketing data with other Comcast data assets; work with business units to document the requirements for enterprise base and semantic layers; identify and build source to target mapping for Sales & Marketing data attributes; develop the business rules and logic to harmonize data; own the creation and execution of test plans; and support standardization efforts for referential data used for data analysis and project output.
REQUIREMENTS: Bachelor's degree, or foreign equivalent, in Computer Science, Engineering, or related technical field, and two (2) years of experience writing complex SQL queries to perform Extract, Transform, and Load (ETL) processes on data; processing data using Teradata and Hadoop; creating technical and data quality requirements using source to target mapping (STTM), pseudo code, and Data Quality rule logic; performing User Acceptance Testing; and performing post-deployment validation, including designing tables and storing procedures, views, and functions; of which one (1) year of experience includes using AWS.
Disclaimer: This information has been designed to indicate the general nature and level of work performed by employees in this role. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications.
Comcast is proud to be an equal opportunity workplace. We will consider all qualified applicants for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability, veteran status, genetic information, or any other basis protected by applicable law.