Business Intelligence Analyst Lead - Hybrid

Blue Cross Blue Shield of Arizona; Phoenix (AZ); Hybrid; USD 75,000 - 110,000; Full time

Benefits offered by this job

Hybrid work model

Job summary

Blue Cross Blue Shield of Arizona is seeking a skilled BI/Data Warehouse Analyst to develop reports, map data across source systems, and design new BI solutions using warehouse tools. The role supports multiple levels of complexity and collaborates with IT, analytics, and business teams.

The position offers a hybrid work arrangement within Arizona, with onsite requirements as described. Strong SQL, data modeling, and BI reporting background are preferred for progression across Levels 1–4.

Qualifications

• Level 1–4 duties include BI, data processing and programming.
• Ability to translate business needs into technical solutions.
• Experience with SQL, VB.NET and ETL tooling is expected across levels.

Responsibilities

• Perform analysis track and resolve data processing issues; coordinate with multiple areas.
• Develop and document business objectives, requirements and data mappings.
• Design, test, and implement data warehouse components and BI reports.
• Provide production support and maintain data quality and documentation standards.
• Lead or support BI projects and maintain data marts as applicable.

Education

High-School Diploma or GED

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 Hybrid 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

Develops reports using data-warehouse and data-access tools; provides user support and training for data structure and use of Data Warehouse; creates mapping specifications from source systems to new and expanded business-intelligence systems, and designs, tests and implements new business intelligence systems.

Qualifications REQUIRED QUALIFICATIONS

Required Work Experience

• 1 year of experience in computer technology and/or information systems (Level 1)
• 2 years of experience in computer technology and/or information systems (Levels 2 – 4)
• 2 years of experience in data management and report analysis, design or development (Levels 2 – 4)

Required Education

• High-School Diploma or GED in general field of study (All Levels)

Required Licenses

• N/A

Required Certifications

• N/A

Preferred Work Experience

• 2 years of experience in computer technology and/or information systems (Level 1)
• 3 - 5 years of experience in computer technology and/or information systems (Level 2)
• 5 years of experience in data management and report analysis, design or development (Levels 3 - 4)
• 2 years of experience working in healthcare-related systems as a business analyst or programmer (Levels 3 - 4)

Preferred Education

• Bachelor’s Degree in Computer Science, Information Systems, Business, or related field (All Levels)

Preferred Licenses

• N/A

Preferred Certifications

• N/A

ESSENTIAL job functions AND RESPONSIBILITIES

Level 1 - Performs job functions under close supervision or peer reviewAnalysis Track and resolve processing problems, coordinating with all areas Track and resolve programming problems Develop and document business objectives, processing requirements, and specifications Develop and document system and data diagrams, program flows Develop test plans, scripts and test bases Analyze files and map data from one system to another Draft or modify internal procedures; implement new procedures including workflows, manuals and training Utilize corporate data tools to ensure quality and documentation standards are achieved. Provide backup support to SME’s in two or more of areas as assigned: BI Project Management BI Production Reporting Application Architecture Application Architecture and Support Training Provide backup support to SME’s in one or more datamarts Technical/Programming Learn process and data flow; and how it affects surrounding systems and operational areas. Map logical data models to physical data models. Maintain existing programs/routine changes and major enhancements. Document programs, systems, manuals, etc. Review code for proper design, standards, content and functionality. Design and code complex programs. Responsible for production cycles, solving abends and notification of problems. Responsible for production support documentation in accordance with department standards and industry best practices. Review code for proper design, standards, content and functionality. Program in multiple programming languages (SQL, VB.net, 3GL/4GL). Translate business needs into technical solutions with knowledge of Bl Tools (SQL, ETL, and OLAP). Implement and maintain operational and disaster-recovery procedures. Manage Metadata Conduct capacity planning Write or modify procedures for internal use, user operational areas, and computer operations, as applicable. Utilize ODBC and OLE DB methodology.

Level 2 - Performs job functions with general supervision Train data warehouse users Ensure the department leverages internal tools and applications effectively Build, support, and maintain moderately complex processes, programs, and data Participate or lead small to medium scoped projects Create moderately complex ad-hoc reports for internal usage and external usage Research and become proficient in two or more of areas as assigned: BI Project Management BI Production Reporting Application Architecture Application Architecture and Support Training Research and become proficient in one or more data marts

Level 3 - Performs job functions with minimal supervision Facilitate and/or create new procedures and processes that support advancing technologies or capabilities Build, support, and maintain moderately complex processes, programs, and data Evaluate high-level project information and assess project components to forecast work effort required Provide peer-level review and mentoring to levels 1 and 2 Participate and/or lead large- or complex-technical projects Create complex ad-hoc reports for internal usage and external usage Act as subject matter expert in two or more of areas as assigned: BI Project Management BI Production Reporting Application Architecture Application Architecture and Support Training Act as subject matter expert in one or more Data Marts

Level 4 - Performs job functions in a lead capacity Serve as primary operational contact for internal and external customers when needed or in the absence of the Manager Ensure Service Level Agreements between department and operational or technical areas are met Lead, develop and mentor staff by providing opportunities for growth through delegation, training, and assignment to various project teams Inform the manager of any issues impacting the efficient and effective performance of the department—including system, resource, and informational barriers; Provide timely feedback to team member on performance Assist the manager in the day-to-day operations of the department

ALL LEVELS Each progressive level includes the ability to perform the essential functions of any lower levels and mentor employees in those levels. Maintain current knowledge of 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. Participate in on-call rotation Perform all other duties as assigned competencies REQUIRED COMPETENCIES

Required Competencies

Required Job Skills (Applies to All Levels)

• 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
• Advanced knowledge of business intelligence, programming, and data analysis sotfware
• Intermediate knowledge of Microsoft Applications and Suites, Windows Server, and Microsoft SQL databases.

Required Professional Competencies (Applies to All Levels)

• 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 business intelligence documentation
• Demonstrate the ability to stay current on global threats and vulnerabilities.
• Experience working with and managing third parties
• Knowledge of business requirements development and user acceptance testing.
• Maintain confidentiality and privacy
• Analytical knowledge necessary to generate reports based on available data and then make decisions based on reported data
• Strong understanding of data governance best practices and data quality improvement principles.

Required Leadership Experience and Competencies (Applies to Levels 2 - 4)

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

Preferred Competencies

Preferred Job Skills (Applies to All Levels)

• Advanced skill in use of office equipment, including copiers, fax machines, scanner and telephones
• Advanced PC proficiency
• Advanced knowledge of Business Objects
• Advanced knowledge of Microsoft Applications and Suites, Windows Server, and Microsoft SQL databases.
• Advanced knowledge of decision support systems
• Intermediate to advanced expertise using Profisee Maestro and Infomratica Power Center corporate data tools

Preferred Professional Competencies (Applies to All Levels)

• Advanced systems research and analysis expertise
• Impeccable project management skills
• Solid technical ability and problem solving skills knowledge of internal departments and operations
• Strong technical documentation skills and a strong ability to translate technical concepts so that they are easily understood by laymen.

Preferred Leadership Experience and Competencies (Applies to Levels 3 - 4)

• Mentor junior business intelligence analysts
• Ability to build lesson plans and deliver lessons to junior team members

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.

Explore what's possible with a career at Blue Cross® BlueShield® of Arizona