Business Intelligence Administrator I/II/III at Excellus Health Plan Inc. in Dewitt, New York

Job Description:

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. 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, adhering to the Corporate Code of Conduct, and Leading to the Lifetime Way values and beliefs. • 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. Level V - In addition to Level IV responsibilities: • Offers the highest level of technical expertise within the team and works as a consultant on the most complex technical BI issues across the organization. • Acts as subject matter expert across a wide range of BI software components, systems and vendors. • Continuously optimizes the enterprises analytic assets, including driving change on BI development/administration teams, IT platform teams and business partners. • Adept presenting to both technical and business teams at any level of the 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. Level V - All qualifications of Level IV in addition to: • Eleven years of related work experience. • Ability to facility effective presentations to any level of the organization. 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 compet

Compensation Range(s):

Grade 206: Minimum -58,500 Maximum - 93,267

Grade 208: Minimum - 67,538 Maximum - 124,925

Grade 210: Minimum - 85,446 Maximum - 158,080

The salary range indicated in this posting represents the minimum and maximum of the salary range for this position. Actual salary will vary depending on factors including, but not limited to, budget available, prior experience, knowledge, skill and education as they relate to the position's minimum qualifications, in addition to internal equity. The posted salary range reflects just one component of our total rewards package. Other components of the total rewards package may include participation in group health and/or dental insurance, retirement plan, wellness program, paid time away from work, and paid holidays.

Please note: There may be opportunity for remote work within all jobs posted by the Excellus Talent Acquisition team. This decision is made on a case-by-case basis.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.