BI Analyst II

Company: SPECTRUM
Location: Maryland Heights
Posted on: May 27, 2023

Job Description:

JOB SUMMARY
This position is responsible for supporting and managing a program of business unit-focused initiatives designed to help business partners drive value from information. 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 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. Provides consultation on the interpretation of data to various business partners throughout the organization.

MAJOR DUTIES AND RESPONSIBILITIES
Actively and consistently support all efforts to simplify and enhance the customer experience

Communicate data nuances and insights to all levels of the company in a clear and concise manner

Instill best practices and support users at all levels of the organization in leveraging BI capabilities for accurate reporting and analysis

Collaborate closely with business partners to gather detailed business requirements that includes identification and mapping of source system data, and rules for data cleansing, integration and validation

Create report mock ups based on requirements and coordinate with technical team to finalize designs

Understand data elements in the warehouse at a fine grain to support any form of user needs from research to adhoc querying to managing large information projects

Interact with senior management or executive level customers and provide support as needed

Document, present and recommend solutions for handling data anomalies and issues

Maintain metadata dictionaries and report definitions

Work with cross functional teams to ensure alignment in business needs, timelines and department standards

Create test plans and scenarios and conduct testing to ensure quality and requirements traceability to final deliverable

Perform other duties as requested

REQUIRED QUALIFICATIONS
Required Skills/Abilities and Knowledge
Ability to read, write, speak and understand English
Demonstrated communication skills both written and verbal
Proven experience and passion for leveraging data to drive business impact
Project management skills
Advanced SQL skills
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
Demonstrated team and relationship building skills
Intermediate to advanced statistical knowledge
High attention to detail and quality
Ability to work independently with minimal guidance, prioritize and organize effectively and manage multiple projects/assignments
Ability to perform in a fast-paced environment
Ability to understand complex business processes, rules and gain business acumen to become subject matter expert

Required Education
Bachelor's degree or foreign equivalent in Information Technology or business-related field, or equivalent experience

Required Related Work Experience and Number of Years
Experience performing business analysis across a variety of industries, business functions and technologies - 4+
Data Analytics, or equivalent experience demonstrated through one or a combination of the following: work experience, training, military experience, education - 2+

PREFERRED QUALIFICATIONS
Preferred Skills/Abilities and Knowledge
Experience with Teradata and/or other MPP data warehouse platforms
Experience working with Telecom/Cable MSO data and applications
Experience working with Tableau or MicroStrategy
Expertise with BI Data Modeling concepts such as Star/Snowflake Schema, Dimensions and Facts

Preferred Related Work Experience and Number of Years
Experience with reporting/Business Intelligence tools (MicroStrategy, Terradata)
Experience with Cable TV, Internet, and/or Phone products & services or other related industry

WORKING CONDITIONS
Office environment
BBLBR

Keywords: SPECTRUM, Springfield , BI Analyst II, Professions , Maryland Heights, Illinois