BI Administrator I/II/III/IV-21062

Company: Excellus BlueCross BlueShield
Location: Buffalo
Posted on: June 12, 2021

Job Description:

Summary

The Business Intelligence (BI) Administrator is responsible for deploying reporting solutions across the Health Plan organization. The BI Administrator designs, develops, implements and maintains Health Plan Business Intelligence software environments (Cognos, Power BI, SAS, RStudio). The BI Administrator works very closely with project teams and with the business community in general to support organizational decision making by turning disparate data into concise and actionable information.

Essential Responsibilities/Accountabilities

All Levels

Under the guidance of the Director, Business Intelligence, this position is responsible for all aspects of implementing and supporting BI applications including:

* Installs, configures, administers and troubleshoots the BI software environment in order to achieve a reliable, highly available, well performing system. * Provides direct technical support to BI user community, and triages support to appropriate personnel when BI technical support is not sufficient. * Develops standards, policies and procedures for the form, structure and attributes of the business intelligence tools and systems. Develops data/information quality metrics. Researches new technology. * Consistently demonstrates high standards of integrity by supporting the Lifetime Healthcare Companies' mission and values and adhering to the Corporate Code of Conduct. * Maintains high regard for member privacy in accordance with the corporate privacy policies and procedures. * Regular and reliable attendance is expected and required. * Performs other functions as assigned by management.

Levels I - V - Demonstrates increased skill level in core skills as follows:

Level I:

* Develops BI solutions, researches and resolves BI application and data issues * Provides solution through SQL and SAS * Provides technical reporting and support to BI user community * Configures and tunes BI software environment * Communicates system notifications and other status updates to user community * Follows and helps streamline procedures for provisioning access to the BI system and establishing security * Creates and maintains user documentation addressing common questions * Monitors system uptime and performance * Escalates appropriately to management and/or more senior BI Administrators

Level II - In addition to Level I responsibilities:

* Provides technical reporting and support for BI system * Develops, documents and enforces policies needed to maintain the integrity of the BI system * Interfaces with development teams, software vendors and other parties to ensure BI system best accommodates their needs and makes changes where necessary * Proactively identifies and addresses risks on system before they become systems issues.

Level III - In addition to Level II responsibilities:

* Serves as a technical expert and mentor to the organization on the administration of BI tools * Proactively plans for growth, system improvements, upgrades, etc * Assists in development of presentations as a technical or subject matter expert * Identifies and documents best practices and makes recommendations for standards improvement. * Interacts regularly with business area partners at a high level, presenting recommendations and statuses. * Proactively identifies system risks/issues as they occur and provides recommendations for remediation.

Level IV - In addition to Level III responsibilities:

* Responsible for developing, implementing and planning strategic BI environment crossing multiple lines of business and influencing manager and director levels. * Advises others of technical/business directions, issues and needs and defines and leads training seminars. * Strategizes alignment of BI solutions with other technology architectural solutions within the organization and effectively recommends strategy updates of changes in direction. * Considers risk and impacts of development across organization.

Minimum Qualifications

NOTE: We include multiple levels of classification differentiated by demonstrated knowledge, skills, and the ability to manage increasingly independent and/or complex assignments, broader responsibility, additional decision making, and in some cases, becoming a resource to others. In addition to using this differentiated approach to place new hires, it also provides guideposts for employee development and promotional opportunities.

Level I:

* Bachelor's degree in Computer Science, Information Technology or relevant field (or four additional years related work experience in lieu of bachelors). * Related work experience (i.e. Co-ops/Internships) preferred. * Solid understanding of data warehousing, database design and Business Intelligence technologies. * Good written and verbal communication skills. * Demonstrated skills in quality principles especially root cause analysis and problem solving. * Demonstrated business and technical problem solving skills. * Demonstrated analytical and business process development skills. * Understanding of application delivery, management structures, and reporting procedures and expertise in SQL and SAS programming and reporting. * Consistently demonstrates high standards of integrity by supporting the Lifetime Healthcare Companies' mission and values and adhering to the Corporate Code of Conduct. * Maintains high regard for member privacy in accordance with the corporate privacy policies and procedures. * Regular reliable attendance is expected and required. * Performs other functions as assigned by management.

Level II - All qualifications of Level I in addition to:

* Three years related work experience. * Demonstrated experience with Data Warehousing in an Oracle environment.

Level III - All qualifications of Level II in addition to:

* Five years related work experience. * Training facilitation skills. * Ability to facilitate effective presentations to front line management staff.

Level IV - All qualifications of Level III in addition to:

* Eight years related work experience. * Ability to facilitate effective presentations to senior management. * Viewed as an expert in the field.

Physical Requirements

* Ability to travel across regions

The Lifetime Healthcare Companies aims to attract the best talent from diverse socioeconomic, cultural and experiential backgrounds, to diversify our workforce and best reflect the communities we serve.

Our mission is to foster an environment where diversity and inclusion are explicitly recognized as fundamental parts of our organizational culture. We believe that diversity of thought and background drives innovation which enables us to provide leading-edge healthcare insurance and services. With that mission in mind, we recruit the best candidates from all communities, to diversify and strengthen our workforce.

OUR COMPANY CULTURE:

Employees are united by our Lifetime Way Values & Behaviors that include compassion, pride, excellence, innovation and having fun! We aim to be an employer of choice by valuing workforce diversity, innovative thinking, employee development, and by offering competitive compensation and benefits.

In support of the Americans with Disabilities Act, this job description lists only those responsibilities and qualifications deemed essential to the position.

Equal Opportunity Employer

#06022021

Keywords: Excellus BlueCross BlueShield, Buffalo , BI Administrator I/II/III/IV-21062, Other , Buffalo, New York