Business Intelligence Analyst Lead - Hybrid

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 QUALIFICATIONS

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 review

Analysis

• 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.

Business Intelligence / Database

• Educate users on data warehouse capabilities; gain consensus among users on common data definitions
• Understand business opportunities for information usage
• Schedule data updates and report generation
• Develop business intelligence and EIS applications
• Convert existing reporting applications to use the data warehouse and datamarts
• Develop periodic reporting systems
• Develop monitoring systems to ensure data has been updated as expected
• Monitor data quality
• Implement data access tools
• Develop metadata management processes and/or systems

Project Management

• Develop programs, time estimates and project schedules based on prioritization and business requirements.
• Use sound project management methodology and demonstrate solid time management skills.
• Creates and delivers presentations.
• Monitor and create priority list(s) that are agreed to by user management

User Support

• Assist users with data requests and end-user support
• Create basic ad-hoc reports for internal usage and external usage

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

• Facilitate and resolve customer requests and inquiries for all levels of management within the Corporation. (Applies to Levels 2 - 4)
• Build synergy with a diverse team in an ever changing environment. (Applies to Levels 3 - 4)

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. If interested in this position, please apply.