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 Remote within the state of AZ only. This Remote work opportunity requires residency, and work to be performed, within the State of Arizona.
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.
Assists with the implementation, optimization, and ongoing support of the Enterprise Data Warehouse (EDW), ensuring scalable architecture, data integrity, operational stability, and continuous enhancement to meet evolving business needs. 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
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, Snowflake and Tableau/Power BI
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 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
Perseverance 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
Corporate Responsibilities
Comply with BCBSAZ corporate and departmental policies and procedures, including, but not limited to Code Blue, Compliance, HIPAA, Computer Responsibility, Accreditation Standards, Attendance, Staff Qualifications and Quality Management Accountabilities
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
AZ Blue 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.