Excel)- Hybrid

Blue Cross Blue Shield of Arizona•Phoenix, AZ

1d•Hybrid

About The Position

Awarded a Healthiest Employer, Blue Cross Blue Shield of Arizona aims to fulfill its mission to inspire health and make it easy. AZ Blue offers a variety of health insurance products and services to meet the diverse needs of individuals, families, and small and large businesses as well as providing information and tools to help individuals make better health decisions. At AZ Blue, we have a hybrid workforce strategy, called Workability, that offers flexibility with how and where employees work. Our positions are classified as hybrid, onsite or remote. While the majority of our employees are hybrid, the following classifications drive our current minimum onsite requirements: Hybrid People Leaders: must reside in AZ, required to be onsite at least twice per week Hybrid Individual Contributors: must reside in AZ, unless otherwise cited within this posting, required to be onsite at least once per week Hybrid 2 (Operational Roles such as but not limited to: Customer Service, Claims Processors, and Correspondence positions): must reside in AZ, unless otherwise cited within this posting, required to be onsite at least once per month Onsite: daily onsite requirement based on the essential functions of the job Remote: not held to onsite requirements, however, leadership can request presence onsite for business reasons including but not limited to staff meetings, one-on-ones, training, and team building Please note that onsite requirements may change in the future, based on business need, and job responsibilities. Most employees should expect onsite requirements and at a minimum of once per week. This position is hybrid within the state of AZ only. This hybrid work opportunity requires residency, and work to be performed, within the State of Arizona. Purpose of the job Responsible for the development of Reporting and Analytics tools to support the driving of more accurate and profitable business decisions. Develop and support customer facing reporting and insight to improve the effectiveness and value of sales interactions with clients and brokers. Work with IT to ensure key metrics and other data related information is available to the Sales Organization through the CRM application. Support ad hoc and project based reporting and analytics needs (benchmark light, incentive comp planning, broker business reviews, business planning, etc.).

Requirements

2 years of experience working with data and information in an analytical role
1 year of experience with Business Intelligence/Data Visualization tools
1 year of experience with forecasting and projections related to revenue and business growth objectives
High School Diploma
Strong PC proficiency
Project management skills
Knowledge and proficiency with Business Intelligence and Data Visualization applications
Excellent analytical and problem solving capabilities with special attention to accuracy and detail
Ability to understand business requirements and processes and translate them to technical application
Self-starter with a proven ability to take ownership of job responsibilities and ensure successful completion of all projects and requests
Ability to facilitate cross-functional teams with internal stakeholders.
Ability to orally communicate effectively in a 1-1 or group setting.
Ability to identify issues and drive them to resolution.
Act with diplomacy and sensitivity with our clients and internal departments.
Ability to manage time effectively.
Maintain confidentiality and privacy.

Nice To Haves

5 years of experience within the Health Insurance Industry
1 years of experience with Customer Relationship Management applications (MS Dynamics, Salesforce)
2 years of experience working with ERP and Data Lake source systems
Understanding of health insurance and related specialty products
Knowledge of a wide range of matters pertaining to the organization's sales and service operations.

Responsibilities

Work collaboratively with IT and other internal departments to acquire and consume key data sources
Create client facing reports with the input of the sales team
Be involved in internal sales related projects requiring reporting, specifically business planning and forecasting/projections
Develop and support client profitability models for Sales
Develop and support broker performance metrics scorecard and associated reporting
Work collaboratively with IT to develop key client, broker and sales performance metrics to be delivered via CRM
Convert complex data from multiple sources into meaningful, professional and easy to understand formats for various audiences
Assist in the creation of business models to align Incentive comp plans to revenue and membership projections annually
The position requires a full-time work schedule.
Full-time is defined as working at least 40 hours per week, plus any additional hours as requested or as needed to meet business requirements.
Perform all other duties as assigned.