Sr Business Intelligence Developer - Medicaid (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 remote work opportunity requires residency, and work to be performed, within the State of Arizona

Purpose of This Job

The Business Intelligence Developer

• Medicaid role is responsible for the design, creation, and maintenance of sustainable reporting solutions and analytical insights that improve efficiency, drive innovation, and inform data driven decision making in support of broader business and corporate strategies across the organization. This position partners with business leaders across the organization to provide high quality reporting and analysis that is accurate, thoroughly researched, assists in identifying risks & opportunities, and provides untapped insights and knowledge to enable data driven and data literate decision making for departments and teams throughout the entire Medicaid segment.

Required Qualifications

Required Work Experience

• Applies to All Levels
• 2 years of experience working with data, report development, and analysis in a workplace setting
• 1 year of experience in query design and effective reporting design structure
• Applies to Levels 2-3
• 4 years of experience working with data, report development, and analysis in a workplace setting
• 3 years of experience in query design and effective reporting design structure
• Applies to Levels 4-6
• 8 years of experience working with data, report development, and analysis in a workplace setting
• 6 years of experience in query design and effective reporting design structure Required Education
• Applies to All Levels
• High-School Diploma or GED in general field of study
• Applies to Levels 4-6
• Bachelor’s degree (B.S.), or equivalent education and/or experience, in Computer Information Systems, Computer Science, Information Technology, Business Administration, Healthcare Administration, or other pertinent degree obtained at a four-year college or university. Required Licenses
• N/A Required Certifications •

N/a Preferred Qualifications

Preferred Work Experience

• Applies to All Levels
• 1 year of experience in a healthcare, health insurance, or managed care environment
• 1 year of experience working with Medicaid and/or Medicare D-SNP programs
• 1 year of experience managing projects
• Applies to Levels 2-3
• 2 years of experience in a healthcare health insurance, or managed care environment
• 2 years of experience working with Medicaid and/or Medicare D-SNP programs
• 3 years of experience managing projects
• Applies to Levels 4-5
• 4 years of experience in a healthcare health insurance, or managed care environment
• 4 years of experience working with Medicaid or Medicare D-SNP programs
• 6 years of experience managing multiple projects
• Applies to Level 6
• 6 years of experience in a healthcare health insurance, or managed care environment
• 6 years of experience working with Medicaid or Medicare D-SNP programs
• 8 years of experience managing multiple projects
• 2 years of supervisory or management experience Preferred Education
• Applies to All Levels
• Bachelor’s degree (B.S.), or equivalent, in Computer Information Systems, Computer Science, Information Technology, Business Administration, or Healthcare Administration obtained at a four-year college or university.
• Applies to Levels 5-6
• Master’s degree, or equivalent, in Computer Information Systems, Computer Science, Information Technology, Business Administration, or Healthcare Administration obtained at a four-year college or university. Preferred Licenses
• N/A Preferred Certifications •

Ms SQL

Certification or other certification in current programming languages (Applies to All Levels)

Essential Job Functions and Responsibilities All Levels

• Each progressive level includes the ability to perform the essential functions of any lower levels and mentor employees in those levels.
• Meet timeliness and accuracy goals.
• Use sound project management methodology and demonstrate solid time management skills.
• Effectively communicate status of work assignments to stakeholders and management via department defined communication channels and policy.
• Design, develop, or maintain reporting and/or analysis of data to measure financial or clinical outcomes, network performance, care management, claims processing, operations and/or other areas of the business
• Design, develop, or maintain reporting and/or analysis of data for medical cost reporting, categories of service, unit cost and financial utilization metrics
• Design, develop, or maintain reporting and/or analysis of data for clinical utilization, authorization, care management, risk adjustment, and claims data to support departmental functions
• Receives, interprets, and completes data requests from Finance and other departments as necessary
• Responsible for technical and production support documentation in accordance with department standards and industry best practices.
• Adhere to established source control versioning policies and procedures
• Participate in all aspects of the Systems Development Life Cycle (SDLC)
• Participate in corporate quality and data governance programs
• Implement and maintain operational and disaster-recovery procedures.
• Maintain current knowledge on new developments in technology-related industries
• This position has an onsite expectation of 1 day per week and 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 Level 1
• Performs job functions with general supervision
• Learn area’s workflow, procedures, and processes.
• Become familiar with and demonstrate a basic understanding of:
• The various areas and types of Business Intelligence reporting and analysis.
• The various reporting platforms utilized by Business Intelligence (Excel, SSRS, Tableau, Qlik Sense, etc.)
• How the Business Intelligence reporting and analysis’ impact the operations and performance of the business.
• What the key departments are, their primary functions, and roles.
• The numerous systems and data sources utilized by Business Intelligence, their purpose, structure, limitations, and functional roles in Business Intelligence reporting and analysis.
• Participates in small projects of basic complexity.
• Designs, develops, and enhances basic-level