Sr. Data Analyst, Revenue Assurance

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.

Job Summary

Responsible for data integrity reporting for the Finance organization. Extract billing information to build audits focused on revenue opportunity and customer experience.  Responsible for analyzing and evaluating operational performance metrics and resources. Creates and facilitates reporting and analysis to evaluate operational initiatives and drive operational efficiencies. Develops and maintains standard reporting measures, quantitative explanation of relevant data and ongoing analysis of alternatives and solutions. May provide financial reporting, revenue analysis support, discount monitoring, promotional modeling and subscriber reporting issue resolution to various departments within the company. Has in-depth experience, knowledge and skills in own discipline. Acts as resource for colleagues with less experience or knowledge in subject matter.

Job Description

Core Responsibilities

• Integrating data from multiple sources into unified reports. Read, comprehend, and write complex SQL queries that pulls data from multiple tables and multiple schemas / servers. 

• Experience with one or more ETL software (ex. Informatica/Pentaho/Alteryx/SSIS)

• Querying disparate big data platforms including Teradata, SQL Server, Hadoop, and AWS using ETL software to support task automation. 

• Translate business requirements to technical requirements and map to back-end data sources. Collaborate with technology and platform management partners to optimize data sourcing and processing rules to ensure appropriate data quality and ensure optimal performance.

• Conduct regular audits to ensure data integrity.

• Identifies issues, analyzes available data and information and recommends changes to management.

• Provides analytical support of actual results against budget and feasibility of proposed business strategies.

• Ensures accuracy of data through partnerships with team members. Provides day-to-day validation and spot checks.

• May prepare reports to be used by other departments to correct billing issues.

• Other duties and responsibilities as assigned.

• Consistent exercise of independent judgment and discretion in matters of significance.

• Regular, consistent and punctual attendance. Must be able to work nights and weekends, variable schedule(s) and overtime as necessary.

Employees at all levels are expected to:

• Understand our Operating Principles; make them the guidelines for how you do your job.
• Own the customer experience - think and act in ways that put our customers first, give them seamless digital options at every touchpoint, and make them promoters of our products and services.
• Know your stuff - be enthusiastic learners, users and advocates of our game-changing technology, products and services, especially our digital tools and experiences.
• Win as a team - make big things happen by working together and being open to new ideas.
• Be an active part of the Net Promoter System - a way of working that brings more employee and customer feedback into the company - by joining huddles, making call backs and helping us elevate opportunities to do better for our customers.
• Drive results and growth.
• Support a culture of inclusion in how you work and lead.
• Do what's right for each other, our customers, investors and our communities.

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.

Skills

ETL Tools, Python (Programming Language), SQL Server Integration Services (SSIS), Structured Query Language (SQL), Teradata Database

Compensation

National Pay Range: $55,978.44 USD-$131,199.48 USD Illinois Pay Range: $59,477.10 USD - $115,455.54 USD Colorado Pay Range: $62,975.75 USD - $120,703.52 USD Hawaii Pay Range: