Business Intelligence Analyst II
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