Full TimeStamford, ConnecticutPosted 11/22/2021Areas of interest: Business Analysis, Business Intelligence, Research/AnalysisRequisition Number: 282642BRSRT300
JOB SUMMARY The Senior Data Analyst will be responsible for using data and analytics to evaluate and assess strategies to retain customer accounts for Spectrum Community Solutions' Retention team. Towards this goal, this individual will manage and track competitors' presence, available technology capabilities, performance, and other data to identify drivers of churn, develop solutions to improve customer retention, and report on progress.
MAJOR DUTIES AND RESPONSIBILITIES
Actively and consistently support all efforts to simplify and enhance the customer experience. Responsible for integrating intelligence from internal and external sources to assess the footprint, market share, product offerings, and marketing tactics of national and local/regional competitors using a Teradata database.
Lead the development of tools for identifying competition, product availability, technologies, Internet speeds, and other relevant competitive information. Leverage knowledge of programming and query languages to manage, analyze, and report findings using available data. Performs datamining against raw data to identify business trends, assess competitive threats, and identify growth opportunities. Assess retention opportunities and threats by geography and product. Identify, assess, and source intelligence from internal and external sources. Utilize KML files and APIs to create customizable mapping capabilities; visually display competitive presence and intensity via Google Earth or other mapping tool. Leverage big data to drive new insights and reporting capabilities. Build and develop tools to visualize data and report to the organization using Tableau or other tools. Develop competitor profiles and statistical analyses to include footprint, product set, internet speed, marketing tactics, channels employed, trend of historical performance and growth strategies. Work cross-functionally with Sales and Operations teams to integrate solutions into existing tools to improve customer service and sales efforts.
REQUIRED QUALIFICATIONS: Advanced proficiency in SQL or similar tools to directly query data, manage ETL processes with large data sets, joining tables, datamining, stored procedures; experience with tools like Alteryx (preferred), SAS, or Informatica Ability to develop tables and stored procedures related to managing tables and large datasets within Teradata warehouse environment Experience using analysis and visualization tools (i.e., Tableau, Microstrategy, BI, SAS, R, etc.) preferred Experience with statistical and predictive modeling (Alteryx, SAS, R, etc.) preferred Experience working with KML files and APIs preferred, especially with regard to customized mapping capabilities Understanding of cable industry products, technology, marketing, and sales/retention techniques and processes Strong communication skills, including experience presenting complex information in a concise and easy to understand fashion MS Office: including PowerPoint, Excel, and Word (with high level of proficiency in Excel/Think Cell) Ability to manage projects with strong organizational skills and attention to detail Ability to succeed in a fast-paced dynamic environment with limited oversight
Education: Bachelor's degree from accredited four-year college with major in Business Analytics, Computer Science, Marketing, Statistics, Economics, Management, or Finance or equivalent work experience
Related Work Experience: 3 to 5 years professional experience working within a data management, reporting, or analytics function of a large organization with an established reputation for measuring business performance (e.g., telecom, media, financial services, publishing, retail, consulting, etc.)
WORKING CONDITIONS Office environment Occasional travel
#LI-NO1 SRT300 282642 282642BR
Our Commitment During COVID-19 Your health and safety is important to us, as such we’re using virtual recruiting tools to safely meet with qualified candidates. We are working in the office, following CDC guidelines. Get to Know Us Charter Communications is known in the United States by our Spectrum brands, including: Spectrum Networks, Spectrum Enterprise and Spectrum Reach. When you join us, you’re joining a strong community of more than 95,000 individuals working together to serve more than 31 million customers in 41 states. Watch this video to learn more. Who You Are Matters Here We’re committed to growing a workforce that reflects our communities, and providing equal opportunities for employment and advancement. Learn about our inclusive culture.