BI Admin I/II/III

Univera Healthcare•Buffalo, NY

13h•Remote

About The Position

Summary: The BI Administrator is responsible for designing, developing, implementing, securing, and maintaining Business Intelligence (BI) software environments that drive analytical and data driven decision making across the organization. The BI Administrator works closely with project teams, technical teams, data scientists, enterprise data experts, business teams and external vendors to support organizational decision making through systems that turn disparate data into actionable information. This role will engage in one or more of current technologies: Power BI, Power Platform, Databricks, Azure DevOps, Cognos Analytics, SAS, SAS Data Management Studio, R, Python, TIBCO. Essential Accountabilities: Level I Installs, configures, administers, and troubleshoots BI software environments in order to achieve reliable, highly available, well performing systems. Conducts testing, systems troubleshooting, performance optimization and maintenance of BI and analytical platforms. Conducts, monitors and maintains system configuration and backups. Monitors system uptime and performance. Provides direct technical support to BI user community, triages and engages support of appropriate personnel when needed or BI technical support is not sufficient. Performs and streamlines functions such as managing user and system accounts, network rights and access to BI, analytical and related integrated systems Creates and maintains documentation, standards and policies for the form, structure and attributes of the BI applications and systems. Research new and upcoming 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. Level II (in addition to Level I Accountabilities) Serves as a technical expert and mentor to the organization on the administration of BI tools. 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 plans for growth, system improvements, upgrades and other system activities Defines and leads training seminars, users’ groups and other educational activities for the organization’s BI user community. Advises others of technical/business directions, issues and needs. Assists in development of presentations as a technical or subject matter expert. Identifies and documents best practices and makes recommendations for standards improvements Interacts regularly with business area partners at a high-level presenting recommendations and statuses Proactively identifies system risks/issues and provides recommendations Level III (in addition to Level II Accountabilities) Acts as a subject matter expert across a wide range of BI software components, systems, and vendors. Responsible for developing, implementing and planning a strategic BI environment crossing multiple lines of business and influencing manager and director levels. Identifies and provides long term strategy alignment updates. Considers changes in technology or direction and risks/impacts across organization. Mentors and trains other team members. 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. Continuously optimizes the enterprises analytics assets, including driving change on BI development/administration teams, IT platform teams and business partners. Provides leadership with recommendations and status updates through presentations and meetings. 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. All Levels Bachelor’s degree in Computer Science, Information Technology or related field. In lieu of a degree six (6) cumulative years of experience required. Prior professional, internship, or co-op experience in reporting or analytical platforms preferred. Experience with Business Intelligence, visualization and data science technologies such as, but not limited to, Cognos, Power BI, SAS, Databricks, SQL, R, python. Understanding of data warehousing and database design using, but not limited to, Oracle, Azure SQL, AWS Redshift or other database management system. Demonstrated skills in quality principles especially root cause analysis and technical problem-solving Flexibility to learn and work with a variety of technologies. Understanding of application delivery, management structures and reporting procedures. Effective communication skills both written and verbal, and across multiple channels of communication. Level II (in addition to Level I Qualifications) Intermediate experience in BI and data science technologies, data warehousing, database design involving, but not limited to, Cognos, Power BI, SAS, Databricks, SQL, R, python, Oracle, Azure SQL Intermediate experience in operating systems (windows, Linux) and cloud platforms (Azure, Amazon Web Services (AWS), Google Cloud Platform (GCP), Databricks). Intermediate experience in SQL, SAS, python, power shell or other related programming languages. Intermediate experience in securing data and analytical platforms using Active Directory or application-based security roles, including Role-Based security practices. Intermediate experience in SDLC and DevOps practices. Experience in developing training, process documentation and facilitating presentations. Master’s degree preferred. Level III (in addition to Level II Qualifications) Extensive, advanced experience in BI and data science technologies, data warehousing, database design involving, but not limited to, Cognos, Power BI, SAS, Databricks, SQL, R, python, Oracle, Azure SQL Extensive experience in operating systems (windows, Linux) and cloud platforms (Azure, Amazon Web Services (AWS), Google Cloud Platform (GCP), Databricks). Advanced experience in SQL, SAS, python, power shell or other related programming languages. Extensive experience in securing data and analytical platforms in Azure, AWS or application-based security roles, including Role-Based security practices. Extensive experience in SDLC and DevOps practices. Extensive experience in presenting technical information to key stakeholders across all levels of the organization. Physical Requirements: Ability to work prolonged periods sitting and/or standing at a workstation and working on a computer. Ability to work while sitting and/or standing at a workstation viewing a computer and using a keyboard, mouse and/or phone for three (3) or more hours at a time. Ability to travel across the Health Plan service region for meetings and/or trainings as needed. Ability to work in a home office for continuous periods of time for business continuity. 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 Compensation Range(s): Level I - Min 60,410 Mid 76,300 Max 96,081 Level II - Min 71,880 Mid 100,632 Max 129,384 Level III - Min 87,766 Mid 122,872 Max 157,978 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: The opportunity for remote work may be possible for all jobs posted by the Univera Healthcare 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.

Requirements

Bachelor’s degree in Computer Science, Information Technology or related field. In lieu of a degree six (6) cumulative years of experience required.
Prior professional, internship, or co-op experience in reporting or analytical platforms preferred.
Experience with Business Intelligence, visualization and data science technologies such as, but not limited to, Cognos, Power BI, SAS, Databricks, SQL, R, python.
Understanding of data warehousing and database design using, but not limited to, Oracle, Azure SQL, AWS Redshift or other database management system.
Demonstrated skills in quality principles especially root cause analysis and technical problem-solving
Flexibility to learn and work with a variety of technologies.
Understanding of application delivery, management structures and reporting procedures.
Effective communication skills both written and verbal, and across multiple channels of communication.
Intermediate experience in BI and data science technologies, data warehousing, database design involving, but not limited to, Cognos, Power BI, SAS, Databricks, SQL, R, python, Oracle, Azure SQL
Intermediate experience in operating systems (windows, Linux) and cloud platforms (Azure, Amazon Web Services (AWS), Google Cloud Platform (GCP), Databricks).
Intermediate experience in SQL, SAS, python, power shell or other related programming languages.
Intermediate experience in securing data and analytical platforms using Active Directory or application-based security roles, including Role-Based security practices.
Intermediate experience in SDLC and DevOps practices.
Experience in developing training, process documentation and facilitating presentations.
Extensive, advanced experience in BI and data science technologies, data warehousing, database design involving, but not limited to, Cognos, Power BI, SAS, Databricks, SQL, R, python, Oracle, Azure SQL
Extensive experience in operating systems (windows, Linux) and cloud platforms (Azure, Amazon Web Services (AWS), Google Cloud Platform (GCP), Databricks).
Advanced experience in SQL, SAS, python, power shell or other related programming languages.
Extensive experience in securing data and analytical platforms in Azure, AWS or application-based security roles, including Role-Based security practices.
Extensive experience in SDLC and DevOps practices.
Extensive experience in presenting technical information to key stakeholders across all levels of the organization.

Nice To Haves

Prior professional, internship, or co-op experience in reporting or analytical platforms preferred.
Master’s degree preferred.

Responsibilities

Installs, configures, administers, and troubleshoots BI software environments in order to achieve reliable, highly available, well performing systems.
Conducts testing, systems troubleshooting, performance optimization and maintenance of BI and analytical platforms.
Conducts, monitors and maintains system configuration and backups. Monitors system uptime and performance.
Provides direct technical support to BI user community, triages and engages support of appropriate personnel when needed or BI technical support is not sufficient. Performs and streamlines functions such as managing user and system accounts, network rights and access to BI, analytical and related integrated systems
Creates and maintains documentation, standards and policies for the form, structure and attributes of the BI applications and systems.
Research new and upcoming 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.
Serves as a technical expert and mentor to the organization on the administration of BI tools.
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 plans for growth, system improvements, upgrades and other system activities
Defines and leads training seminars, users’ groups and other educational activities for the organization’s BI user community.
Advises others of technical/business directions, issues and needs. Assists in development of presentations as a technical or subject matter expert.
Identifies and documents best practices and makes recommendations for standards improvements
Interacts regularly with business area partners at a high-level presenting recommendations and statuses
Proactively identifies system risks/issues and provides recommendations
Acts as a subject matter expert across a wide range of BI software components, systems, and vendors.
Responsible for developing, implementing and planning a strategic BI environment crossing multiple lines of business and influencing manager and director levels.
Identifies and provides long term strategy alignment updates. Considers changes in technology or direction and risks/impacts across organization.
Mentors and trains other team members.
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.
Continuously optimizes the enterprises analytics assets, including driving change on BI development/administration teams, IT platform teams and business partners.
Provides leadership with recommendations and status updates through presentations and meetings.