Data AnalystLocation: Philadelphia, PAPosition Type: ContractRate: DOE – (W2/1099) W2-36/hrInterview View: F2F Interview RequiredNote: Preferred only GC or CitizenDeep SQL and SQL coding within Excel (analytical functions - windowing/partitioning etc.)Deep Excel - pivot tables and graphsSome DW backgroundDB backgroundCompany Overview: This fast-paced employer is one of America's largest video, high-speed Internet, and phone providers. It also enjoys an international reputation as a leading media, entertainment, and communications company. The corporate culture presented by the employer provides an innovative and diverse environment for employees, and reflects the individuality of its customer base.
Working for this company will guarantee access to innovative technology, and it has also been consistently competitive in "top places to work" lists.Scope: The Enterprise Business Intelligence – Customer Initiatives team at Comcast have an initiative that has recently launched that will require the assistance of two contract resources (through year-end) to help collect, access, summarize and analyze data.The general "Wish List":Ideally but NOT required, has worked at Comcast (or another Cable Provider) previouslyUnderstanding of processes and data related to Customer Ops, Billing, Service, Tech OpsStrong attention to detail and ability to identify and navigate underlying data sources to conduct root cause analysis from high level data pointsGood interpersonal skills and ability to follow-up with data owners for context/explanationStrong Data manipulation skills aimed at staging for analysis more-so than architecting/reportingTools to be employed:SQL (Teradata, Oracle, SQL Server)ExcelSAS (likely limited use, but a bonus)Hadoop (likely limited)Ability to re-model data and employ advanced analysis within above tools (i.e. SQL/Excel) to quickly address questionsSQL Analytical Functions (Windowing/Partitioning/Binning)Pivot Tables/GraphingWillingness to "forage for data" among many data stores and operational toolsStrong business acumen and ability to leverage those skills to focus on the most meaningful and actionable data pointsIdeally, we would like to land on candidates with complementary skills (i.e. Strong Technical/Lighter Business Analysis skills teamed with Lighter Technical/Stronger Business) but also an adequate balance to ensure flexibility in assigning tasks.Type of Assignment: ContractInterview Process: Phone followed by a F2F