Programming Analyst for Group Pricing

Awarded a Healthiest Employer, Blue Cross Blue Shield of Arizona aims to fulfill its mission to inspire health and make it easy. BCBSAZ 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.

This position requires residency and work to be performed within the state of Arizona.

PURPOSE OF THE JOB

· Conducts or supervises projects related to pricing or forecasting competitive premium levels for individual products.

QUALIFICATIONS

REQUIRED QUALIFICATIONS

1. Required Work Experience

· For grade level 27, no experience is required

· For grade levels 28 and higher, 2 years of experience in an actuarial field, or relevant work experience with programming skills in SQL and SSIS development

2. Required Education

· Bachelor's Degree in actuarial science, business, mathematics, statistics, economics or related field of study and information technology

3. Required Licenses

· N/A

4. Required Certifications

· N/A

PREFERRED QUALIFICATIONS

1. Preferred Work Experience

· 2+ years of experience working for a healthcare organization / health insurer

· 2+ years of experience assisting in the development group premium rates

· 2+ years of experience in SQL Server database development and SSIS development

· 1+ year of experience programming pricing engines with Optum StepWise tool

2. Preferred Education

· Bachelor's Degree in computer science, mathematics, statistics, or related field of study

3. Preferred Licenses

· N/A

ESSENTIAL JOB FUNCTIONS AND RESPONSIBILITIES

ANALYST I - II // ASSOCIATE II - III

· Under general supervision, develop and modify StepWise formulas. Formulas will be used to develop small and large group premium rates, invoicing, and compliance with federal and state regulations.

· Under general supervision develop and maintain the SQL code and SSIS packages which create the summarized data set for rating in StepWise.

· Under general supervision create automated tools, which help Underwriting and other departments for faster and cleaner work processes.

· Under general supervision analyze data sets and summarize results.

· Display initiative in research beyond the specific assignment.

· Meaningfully contribute to the area’s workload, considering volume and complexity.

LEAD ANALYST I - II / LEAD ASSOCIATE I - II

· Manage workload with minimal supervisory instructions, limited project management assistance, and limited review of results, beyond pre-release peer review.

· Provide support to business partners (Underwriting, Product development, Sales, Finance and Actuarial) with limited supervision.

· Communicate (both verbally and in writing) and interprets results, recommendations and abstract concepts to internal and external customers. Anticipate and addresses possible customer questions and concerns.

· Work with the members of the Information Technology department when assistance is needed with StepWise-related issues with limited supervision.

· Train and mentor other analysts and provide peer review.

SENIOR ANALYST I - IV / SENIOR ASSOCIATE I - IV

· Fully supports all SQL development and SSIS development for StepWise.

· Plan and lead complex projects from inception to completion. Includes working independently on creating timelines, working with other areas to define deliverables, monitoring progress, implementing the project and resolving/monitoring post-implementation issues.

· Understand all rating components for group pricing and is able to support all StepWise formulas. Has experience in StepWise Portal design and programming.

ALL LEVELS

· Each progressive level includes the ability to perform the essential functions of any lower levels and mentor employees in those levels.

· 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.

COMPETENCIES

REQUIRED COMPETENCIES

1. Required Job Skills

· Advanced skill in mathematics and statistics.

· Advanced skills in SQL Server database development and SSIS development.

2. Required Professional Competencies

· Broad understanding of health insurance terms and concepts; knowledge of benefit design and rating techniques.

· Analytical knowledge necessary to generate reports, based on available data and then make sound decisions based on reported data.

· Ability to solve problems independently and draw accurate conclusions from limited data.

· Ability to deal with ambiguity and make recommendations with less than complete or conflicting information while maintaining appropriate time management.

· Ability to maintain confidentiality and privacy.

· Ability to communicate effectively, both orally and in writing, to all levels in all departments.

· Ability to summarize technical information to a non-technical audience.

· Ability to build and maintain productive working relationships with others.

3. Required Leadership Experience and Competencies

· N/A

PREFERRED COMPETENCIES

1. Preferred Job Skills (Applies to grades 28 and above)

· Advanced proficiency in progamming.

· Intermediate proficiency with data warehouses and query tools / design (Applies to Level 1).

2. Preferred Professional Competencies (Applies to grades 29 and above)

· Project management skill needed to create timelines, track deliverables and progress, resolve issues, and communicate project status.

3. Preferred Leadership Experience and Competencies

· N/A

Our Commitment

BCBSAZ does not discriminate in hiring or employment on the basis of race, ethnicity, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status or any other protected group.

Thank you for your interest in Blue Cross Blue Shield of Arizona.  For more information on our company, see azblue.com.  If interested in this position, please apply.