Data Scientist

Spectrum; Yorkwood (NC); Hybrid; USD 110,000 - 170,000; Full time

Job summary

Spectrum is seeking a Data Scientist to design, develop, and maintain data analyses and visualizations that support our audit plan. You will extract data from Teradata, SQL, and Oracle, validate results, and present insights to the audit team for oversight and decision making.

This hybrid role (four days in office, one day remote) emphasizes collaboration with cross-functional teams to research requirements, create dashboards, and drive improvements in data quality and reporting across Spectrum.

Qualifications

• In-depth knowledge of database design, SQL and data warehousing
• Advanced SQL development and optimization background
• Knowledge of data visualization and presentation methods for data analysis and interpretation, including performance of dashboards, generating, managing and delivering presentations and reports capable of yielding insights and actionable results
• Ability to understand business processes to ensure data and information integrity when importing from source systems.
• Ability to present analysis to our audit teams clearly and concisely
• Excellent interpersonal, oral and written communication and presentation skills
• Ability to work in teams towards a shared goal
• Ability to interface with various levels in an organization
• Ability to prioritize and organize effectively
• Ability to learn new technologies and tools
• Capable of working independently to solve problems under deadlines and to manage multiple projects/priorities under time constraints
• Detail oriented with emphasis on accuracy and consistency

Responsibilities

• Understand the source data and business process
• Independently write code to extract data from various sources (Teradata, SQL, Oracle, etc.)
• Develop code to manipulate and clean data as needed based on requirements gathered in conjunction with the Manager, Data Science.
• Design and execute data validations and quality checks to ensure complete and accurate populations.
• Design and build visualization solutions with our end users in mind to drive efficiency and effective anomaly identification.
• Refreshing and optimizing existing analytics based on internal and external feedback.
• Identify risks and escape to management appropriately.
• Participate in discussions and interface with various departments to research, define, and document requirements.
• Proactively seek clarification of requirements and direction; takes responsibility when needed.
• Executes special projects as needed and performs other duties as requested.

Skills

Database design

SQL development

Data warehousing

Data visualization

Dashboards

Presentations

Oral communication

Written communication

Interpersonal skills

Teamwork

Interfacing with stakeholders

Prioritization

Organization

Learn new tech

Independent work

Attention to detail

Education

Bachelor’s degree in Computer Science

Tools

Tableau

Teradata

SQL

Oracle

Job description

This role requires the ability to work lawfully in the U.S. without employment-based immigration sponsorship, now or in the future.

The Data Scientist plays a key role in our data driven audits and is responsible for the design, development and maintenance of data analysis and visualizations to support the audit plan, including requirements gathering, data validation, analysis execution and results reporting using visualization tools. The position requires regular communication with the audit team to define requirements and present deliverables.

How You’ll Make an Impact

Actively and consistently support all efforts to simplify and enhance the customer experience.

Design and develop analytic solutions to support our audit plan, including but not limited to:

• Understanding the source data and business process
• Independently write code to extract data from various sources (Teradata, SQL, Oracle, etc.)
• Develop code to manipulate and clean data as needed based on requirements gathered in conjunction with the Manager, Data Science.
• Design and execute data validations and quality checks to ensure complete and accurate populations.
• Design and build visualization solutions with our end users in mind to drive efficiency and effective anomaly identification.
• Refreshing and optimizing existing analytics based on internal and external feedback.

Identify risks and escape to management appropriately.

Participate in discussions and interface with various departments to research, define, and document requirements.

Proactively seek clarification of requirements and direction; takes responsibility when needed.

Executes special projects as needed and performs other duties as requested.

Working Conditions

Office environment (four days in office/one day remote)

What You’ll Bring to Spectrum

Here, our employees don’t just have jobs, they're building careers. That’s why we offer a comprehensive pay and benefits package that rewards employees for their contributions to our success, supporting all aspects of their well-being at every stage of life.

Required Qualifications

Required Skills/Abilities and Knowledge

• In-depth knowledge of database design, SQL and data warehousing
• Advanced SQL development and optimization background
• Knowledge of data visualization and presentation methods for data analysis and interpretation, including performance of dashboards, generating, managing and delivering presentations and reports capable of yielding insights and actionable results
• Ability to understand business processes to ensure data and information integrity when importing from source systems.
• Ability to present analysis to our audit teams clearly and concisely
• Excellent interpersonal, oral and written communication and presentation skills
• Ability to work in teams towards a shared goal
• Ability to interface with various levels in an organization
• Ability to prioritize and organize effectively
• Ability to learn new technologies and tools
• Capable of working independently to solve problems under deadlines and to manage multiple projects/priorities under time constraints
• Detail oriented with emphasis on accuracy and consistency

Required Education

Bachelor’s degree in Computer Science or related field or an equivalent combination of education, training and experience

Required Related Work Experience and Number of Years

• Writing SQL / 3
• Designing and building analytics tools in Tableau / 2
• Big data analysis / 3
• Requirements analysis and documentation / 3
• Data validation, analysis, and debugging / 3

Preferred Skills/Abilities and Knowledge

• Telecomm/Cable industry experience
• Accounting/Financial/Audit experience
• Data mining experience

A qualified applicant’s criminal history, if any, will be considered in a manner consistent with applicable laws, including local ordinances.

Get to Know Us

Charter Communications provides superior communication and entertainment products for residential and business customers through the Spectrum brand. Our offerings include Spectrum Internet, TV, Mobile and Voice. Beyond our connectivity solutions, we also provide local news, programming and regional sports via Spectrum Networks and multiscreen advertising solutions via Spectrum Reach. When you join our team, you’ll be keeping our customers connected to what matters most in 41 states across the U.S. Watch this video to learn more.

Grow Your Career Here

We’re committed to growing a workforce that reflects the customers and communities we serve - providing opportunities for employment and advancement to all team members. Spectrum is an Equal Opportunity Employer, including job seekers with disabilities and veterans. Learn about Life at Spectrum.