Data Management Analyst - Big Data (Remote in AZ)

Blue Cross Blue Shield of AZ; Phoenix (AZ); Remote; USD 85,000 - 120,000; Full time

Job summary

Blue Cross Blue Shield of Arizona seeks a data analytics professional to query and analyze data related to quality measures, reporting findings to Executive Leadership for informed decisions.

Designs and maintains data extracts from enterprise data stores, supports the Enterprise Data Warehouse, and delivers scalable analytics solutions using SQL, ETL, and BI tools to meet evolving business needs.

Qualifications

• 1 year of experience in SQL, query design, data management technologies and databases
• 2 years of experience in SQL, query design, data management technologies and databases
• 3 years of experience in SQL, query design, data management technologies and databases
• Bachelor's degree in Data Analytics or related field
• Preferred Master’s degree in Data Analytics or related field
• MS SQL or SSIS Certification is a plus

Responsibilities

• Creates and maintains analytics, visualization, reports and presentations
• Creates ad-hoc reports and provides analytic support
• Automates business processes and develops on-demand reports and dashboards
• Analyzes monthly and quarterly performance measure reporting
• Designs and maintains data extracts from enterprise data stores
• Designs and implements ETL solutions including SQL programming
• Codes systems, programs, and interfaces using appropriate structured approaches

Skills

SQL programming

Data management

Query design

Education

Bachelor's degree in Data Analytics or related field

Master’s degree in Data Analytics or related field

Tools

Tableau/Power BI

Snowflake

SSIS

Job description

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