Job Description

Awarded the Best Place to Work 2021, Blue Cross Blue Shield of Arizona helps to fulfill its mission of improving the quality of life of Arizonans by delivering 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.

Purpose of the Job

  • Query and analyze data related to quality measures with the goal of accurately reporting findings to other departments and Executive Leadership for making informed decisions
  • Designs, implements and maintains data extracts from enterprise data stores for both internal and external customers
  • Creates and implements extract, transform, and load (ETL) solutions to provide source data for the Enterprise Data Warehouse and Data Lake.  Provide solutions based on BCBSAZ SQL database design and implementation standards, corporate policies, industry best practices, and customer-based business requirements.

REQUIRED QUALIFICATIONS

Required Work Experience
  • 1 year of experience in computer programming (SQL), query design, data management technologies and techniques, and databases (Applies to Level 1)
  • 2 years of experience in computer programming (SQL), query design, data management technologies and techniques, and databases (Applies to Level 2)
  • 3 years of experience in computer programming (SQL), query design, data management technologies and techniques, and databases (Applies to Level 3)

Required Education

  • Bachelor’s degree in Data Analytics, Health informatics, Epidemiology, Public Health, Biostatistics, Statistics, Applied Math, Data Science, Business intelligence or other related field

Required Licenses

  • N/A

Required Certifications

  • N/A
 

PREFERRED QUALIFICATIONS

Preferred Work Experience

  • Familiarity with AHCCCS Medicaid, NCQA HEDIS, and CMS Medicare Stars Ratings is desirable
  • Experience with extensive data analysis on healthcare payer data across multiple functional areas (e.g. Membership, Provider, Lab, Medical and Pharmacy Claims etc.,)
  • 2 years of experience in working with healthcare systems
    • 4 years of experience in computer programming, query design, and databases 
  • 4 years of experience with data management technologies and techniques
  • Intermediate knowledge of SQL and/or SSIS

Preferred Education

  • Master’s Degree in Data Analytics, Health informatics, Epidemiology, Public Health, Biostatistics, Statistics, Applied Math, Data Science, Business intelligence or other related field

Preferred Licenses

  • N/A

Preferred Certifications

  • MS SQL or SSIS Certification

Essential Job functions And Responsibilities

  • Creates and maintains meaningful analytics, visualization, reports and presentations most appropriate to users based on their role that enable insights to actionable next steps
  • Creates ad-hoc reports and provides analytic support, using project management tools to gather user requirements and confirm user acceptance
  • Suggests and implements automation of business processes, such as on-demand reports and interactive dashboards; identifies and implements opportunities to streamline and improve processes
  • Analyze monthly and quarterly performance measure reporting
  • Design, implement and maintain data extracts from enterprise data stores for both internal and external customers
  • Design & Implement Extract, Transform, and Load (ETL) solutions including SQL programming based on BCBSAZ database design and implementation standards
  • Design and code systems, programs, and interfaces, using the appropriate structured programming techniques and programming languages
  • Oversee and mentor junior analysts
  • Track and resolve any processing issues
  • Analyze files and map data from one system to another
  • Develop programs, time estimates and project schedules based on prioritization and business requirements
  • Demonstrate solid time management skills
  • Meet timeliness and accuracy goals
  • Communicate status of work assignments to stakeholders and management.
  • Maintain knowledge on new developments in technology-related industries
  • Participate in corporate quality and data governance programs
  • 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

REQUIRED COMPETENCIES

Required Job Skills

  • Intermediate skill in use of office equipment, including copiers, fax machines, scanner and telephones
  • Intermediate PC proficiency
  • Intermediate proficiency in spreadsheet, database and word processing software
  • Intermediate knowledge of Microsoft SQL databases.
  • Demonstrated problem solving skills

Required Professional Competencies

  • Strong analytical skills to support independent and effective decisions
  • Ability to prioritize tasks and work with multiple priorities, sometimes under limited time constraints
  • Perserverance in the face of resistance or setbacks
  • Effective interpersonal skills and ability to maintain positive working relationship with others            
  • Verbal and written communication skills and the ability to interact professionally with a diverse group, executives, managers, and subject matter experts
  • Systems research and analysis. Ability to write and present technical documentation
  • Knowledge of business requirements development and user acceptance testing
  • Maintain confidentiality and privacy

Required Leadership Experience and Competencies

  • Facilitate and resolve customer requests and inquiries for all levels of management in Corporation
  • Build synergy with a diverse team in an ever changing environment

PREFERRED COMPETENCIES

Preferred Job Skills

  • Advanced PC proficiency
  • Advanced knowledge of Microsoft Applications and Suites and Microsoft SQL databases.
  • Intermediate proficiency in SQL Programming language
  • Intermediate proficiency in SSIS, Power BI/Tableau, and data modeling
  • Strong technical documentation skills
  • Strong understanding of relevant big data & digital technologies, with the ability to harness their potential to drive customer and business value

Preferred Professional Competencies

  • Solid technical ability and problem solving skills
  • Strong ability to translate technical concepts so that they are easily understood by laymen. 
  • Strong personal impact and the ability to inspire confidence and positive action
  • Demonstrated ability to stay current on global threats and vulnerabilities.
  • Experience working with and managing third parties

Preferred Leadership Experience and Competencies

  • Strong communications and influencing skills
  • Ability to adapt to shifting priorities, demands, and tight timelines through analytical and problem solving capabilities
  • Ability to mentor and provide peer review to lower levels
  • Ability to build lesson plans and deliver lessons to junior team member
  • Demonstrated vision in problem solving
  • Ability to manage a solution and just not a checklist
  • Advanced systems research and analysis expertise

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.

Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!

Apply Online