BI Analyst II (Production/UAT)

Company: SPECTRUM
Location: Charlotte
Posted on: January 16, 2022

Job Description:

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

BBL317 296724 296724BR

Keywords: SPECTRUM, Charlotte , BI Analyst II (Production/UAT), Professions , Charlotte, North Carolina