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.
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 (Terradata, 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 escalate 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.
WHAT YOU’LL BRING TO SPECTRUM
Required Qualifications
Required Skills / Abilities and Knowledge
In-depth knowledge of database design, SQL and data warehousingAdvanced SQL development and optimization backgroundKnowledge 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 resultsAbility 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 conciselyExcellent interpersonal, oral and written communication and presentation skillsAbility to work in teams towards a shared goalAbility to interface with various levels in an organizationAbility to prioritize and organize effectivelyAbility to learn new technologies and toolsCapable of working independently to solve problems under deadlines and to manage multiple projects / priorities under time constraintsDetail oriented with emphasis on accuracy and consistencyRequired 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 / 3Designing and building analytics tools in Tableau / 2Big data analysis / 3Requirements analysis and documentation / 3Data validation, analysis, and debugging / 3Preferred Skills / Abilities and Knowledge
Telecomm / Cable industry experienceAccounting / Financial / Audit experienceData mining experienceWorking conditions
Office environment 4 days in office / one day remote.Travel as required (10%)SPECTRUM CONNECTS YOU TO MORE
Dynamic Growth : The growth of our industry and evolving technology powers our employees’ careers as they move up or around the companySupportive Teams : Who you are matters here. And, we aim to foster an inclusive workplace where every person is empowered to bring their best ideasLearning Culture : With a dedicated focus on training and development, employees can have confidence that day one is truly just the beginning of a dynamic careerTotal Rewards :