Spectrum
The growth of our industry and evolving technology powers our employees’ careers as they move up or around the company.
Charlotte, NC

Business Intelligence Analyst II (Charlotte, NC)

| Charlotte, NC
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
JOB SUMMARY
This position is responsible for supporting a program of business unit-focused initiatives designed to help business partners drive value from information. The BI Analyst's primary contribution to the team involves load monitoring and incident management, performance tuning, and development of One Automation jobs to meet service level agreements, allowing transformation of data into meaningful and accurate information which the business can consume. Contributes to Charter's success by ensuring business needs and goals are realized through analysis and reporting activities of the Business Intelligence Group. Responsible for supporting the Sr Manager or Director of Business Intelligence to empower Charter business leaders with concise, high-quality information, helping them leverage it to identify and address business opportunities and threats.
MAJOR DUTIES AND RESPONSIBILITIES
Responsible for production operations activities, including load monitoring, incident management, change management, break/fix development and application administration.
Provide expert advice and education in the usage and interpretation of business data relevant to the business unit
Communicate data nuances and insights to all levels of the company in a clear and concise manner
Instill best practices and assists users at all levels within the company on how to leverage BI capabilities for accurate reporting and analysis
Leverage expert knowledge of Business Intelligence capabilities and familiarity with business trends in identifying patterns, opportunities and threats
Work closely with partners in gathering detailed requirements, establishing definitions, translating to technical requirements for team and gaining approval
Interact with senior management or executive level customers and provides support as needed
Design, develop, implement, and support new and existing data integration jobs using wide variety of tools
Support all scheduled and non-recurring information needs of the business users
Understand data elements in the warehouse at a very detailed grain to support any form of user needs from research to adhoc querying to managing large information projects
Query large datasets and tables comfortably to provide information requested by users
Manage detailed plans on projects to ensure successful completion
Maintain metadata dictionaries and report definitions
Work with cross functional teams to ensure alignment in business needs, timelines and department standards
Actively identify solutions to enhance the existing Business Intelligence infrastructure processes and technology
Identify areas of improvements, leverages industry best practices and guides team to continuously improve the practice of BI
Lead and mentors junior team members and takes responsibilities as subject matter expert (SME)
Understand and evaluate cross functional and system to system impacts of requirements and change requests
Use advanced Excel skills to capture and communicate data findings
Liaison among the business, development and support teams to ensure solutions being developed meet or exceed business needs
Troubleshoot, diagnose and resolve data quality and performance issues
Communicate complex topics and analyses to non-technical business personnel
Provide accurate level of effort estimates for development in support of operational efficiencies and scheduling to management
Work closely with IT, Architecture, Business Analysts and Report Developers to achieve business objectives
Develop technology documentation to support production deployments as well as ongoing maintenance of reporting and data solutions
Perform other duties as requested
REQUIRED QUALIFICATIONS
Skills/Abilities and Knowledge
Ability to read, write, speak and understand English
Exceptionally strong communication skills both written and verbal
Proven experience and passion for leveraging data to drive business impact
Expert SQL skills
Experience with reporting/Business Intelligence tools (MicroStrategy, Tableau)
Advanced working knowledge of ETL workflow and scheduling applications. (Informatica, IBM Infosphere, One Automation, UC4/Appworx, Tidal and Composite)
Advanced working knowledge of Teradata and other MPP data warehouse platforms
Strong working knowledge of Subversion, Bitbucket and Jenkins
Strong working knowledge of Unix scripting and python
Knowledge of cloud services (AWS)
Ability to speak to large groups with excellent presentation skills
Ability to perform critical thinking in the area of data analysis with advanced analytical skills
Strong team and relationship building skills
Strong leadership skills with ability to lead and mentor
High attention to detail and quality
Ability to work independently, prioritize and organize effectively and manage multiple projects/assignments
Ability to perform in a fast-paced environment
Excellent project management skills
Ability to understand complex business processes, rules and gain business acumen to become subject matter expert
Experience with data visualization standards and techniques to visually summarize data and insights is a plus
Expertise with BI Data Modeling concepts such as Star/Snowflake Schema, Dimensions and Facts
Education
Bachelor's degree or foreign equivalent in Information Technology or business related field, or equivalent experience
RELATED WORK EXPERIENCE
4+ years of production operations experience
4+ years of SQL Query Design in large-scale data warehouse environments
4+ years relevant technical or business work experience
Experience with Cable TV, Internet, and/or Phone products & services or other related industry experience is a plus.
PREFERRED QUALIFICATIONS
Experience with Teradata and/or other MPP data warehouse platforms
Experience working with MicroStrategy, Tableau
Experience working with ETL workflow and scheduling applications. (Informatica, One Automation, UC4, Composite)
WORKING CONDITIONS
Office Environment
#LI-LB1
BBL317 296724 296724BR
See More
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
  • Product
    • JavaLanguages
    • JavascriptLanguages
    • KotlinLanguages
    • PerlLanguages
    • PythonLanguages
    • ReactLibraries
    • HadoopFrameworks
    • OracleDatabases
    • Google AnalyticsAnalytics
    • TableauAnalytics
    • SprinklrAnalytics
    • CanvaDesign
    • IllustratorDesign
    • PhotoshopDesign
    • AsanaManagement
    • JIRAManagement
    • SmartsheetManagement

What are Spectrum Perks + Benefits

Spectrum Benefits Overview

Working for Spectrum means working to keep people connected to what matters most, helping underserved communities be better connected, and powering the remote and essential workers which were critical in the past two years.

On top of this mission, the employment opportunity here is financially rewarding - with compelling wages, excellent benefits with no increase in cost, and healthy retirement savings options, we provide the security to build a financially sound future.

There are also many opportunities to learn new skills and grow fulfilling and lasting careers. We offer stability in this time of uncertainty.

We are pleased to offer free or discounted Spectrum services to employees depending on where they live. Employees who live in a Charter service area can receive residential TV, high-speed internet and voice services and have access to Spectrum Mobile. Employees who live outside of a Charter service area can get our Spectrum TV Essentials package and have access to Spectrum Mobile services.

Our employees' financial well-being is just as important as their physical and emotional well-being. With our market-leading company match, for every $1 employees put into their 401(k), we put in $1 up to 6% of their eligible pay. On top of that, most employees receive an additional company contribution equal to 3% of their eligible pay into a Retirement Accumulation Plan.

We're proud to provide employees with some of the best benefits in our industry and we're committed to keeping them affordable so you can keep more of your paycheck. For example, we put up to $1,500 into an account to help you pay for qualified health care expenses and we have absorbed the full cost increase for the medical, dental and vision coverage for 8 years in a row.

We're also proud of the ways our employees grow their knowledge. We help cover the costs, like $5,250 per year in tuition reimbursement, so you can focus on more important things, like your path to greater opportunities. With a dedicated focus on career development, employees can have confidence that day one is truly just the beginning.

Culture
Volunteer in local community
Partners with Nonprofits
Eat lunch together
Intracompany committees
Daily sync
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Diversity
Documented equal pay policy
Dedicated Diversity/Inclusion Staff
Highly diverse management team
Unconscious bias training
Diversity Employee Resource Groups
With our business resource groups, we welcome you to be part of a strong community that gives you opportunities to network, develop and grow your career.
Hiring Practices that Promote Diversity
We aim to foster an inclusive culture and workplace where every person feels empowered. No matter your background, identity or beliefs, we welcome you to explore a career with us.
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Onsite Gym
Mental Health Benefits
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Company Equity
Performance Bonus
Child Care & Parental Leave Benefits
Child Care Benefits
Spectrum offers discounts at specified per location daycares.
Flexible Work Schedule
Family Medical Leave
Adoption Assistance
Vacation & Time Off Benefits
Generous PTO
Paid Holidays
Paid Sick Days
Perks & Discounts
Commuter Benefits
Company Outings
Parking
Spectrum employees have plenty of on-site parking options including lots and a garage.
Relocation Assistance
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Diversity Program
Lunch and learns
Promote from within
Mentorship program
We believe mentoring plays a vital role in career growth. We're proud of our mentorship program here at Spectrum.
Online course subscriptions available

An Insider's view of Spectrum

How does your team reward individual success?

Building a culture of success is critical to our companies business success. We have numerous programs that allow peers and leaders to recognize individuals for their contributions. Our Spark allows you to earn points that can be used to purchase gift cards and items from your favorite merchant.

Mary

GVP, Network Security Operations

More Jobs at Spectrum