Data Management Analyst - Big Data (Remote in AZ)

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

C orporate 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 Competencie