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 demo