Programmer II - 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 weekHybrid Individual Contributors: must reside in AZ, unless otherwise cited within this posting, required to be onsite at least once per weekHybrid 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 monthOnsite: daily onsite requirement based on the essential functions of the jobRemote: 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 buildingPlease 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 hybrid work opportunity requires residency, and work to be performed, within the State of Arizona.Purpose of the jobPerforms programming and maintenance on various programs and systems based on customer business requirements. Programmer II and Programmer III roles may be combined with SCRUM development responsibilities.REQUIRED QUALIFICATIONSRequired Work ExperienceExperience in computer / information technologyLevel 1: 1 yearLevel 2: 3 yearsLevel 3: 5 yearsLevel 4: 7 yearsExperience in programming, query design, and database developmentLevel 2: 1 yearLevel 3: 3 yearsLevel 4: 4 yearsExperience in project managementLevel 3: 1 yearLevel 4: 3 yearsRequired EducationHigh-School Diploma or GED in general field of study (Applies to All Levels)Required LicensesN/ARequired CertificationsN/APREFERRED QUALIFICATIONSPreferred Work ExperienceExperience in programming, query design, and database developmentLevel 2: 1 yearLevel 3: 3 yearsLevel 4: 4 yearsExperience in project managementLevel 3: 1 yearLevel 4: 3 yearsSupervisory ExperienceLevel 4: 1 yearPreferred EducationBachelor’s Degree in computer technology, business, or related field (Applies to All Levels)Preferred LicensesN/APreferred CertificationsTechnical Certifications in programming languages (Applies to All Levels)ESSENTIAL JOB FUNCTIONS AND RESPONSIBILITIESLevel 1With assistance from Programmer III or Lead, maintain and develop basic-level systems and programs.Participate in the development, review, and creation of documentation used to support associated systems.Design and code basic-level systems, programs, and interfaces, using the appropriate structured programming techniques and programming languages.Develop and maintain databases.Create logic, system, and program flows.Write and execute unit test plans. Track and resolve any processing issues.Participate in small to medium projects.Create ad-hoc reports for internal and external customers.Research, respond to, and finalize questions or requests for research received from internal customers.Participate in the review of code and/or systems for proper design standards, content and functionality.Assist with development and delivery of presentations to staff and managementParticipate in all aspects of the Systems Development Life CycleAnalyze files and map data from one system to anotherAdheres to established source control versioning policies and proceduresMeet timeliness and accuracy goals.Communicates status of work assignments to stakeholders and management.Level 2With assistance from Programmer III or Lead, maintain and develop moderately complex systems and programsParticipate or lead medium projects.Track and resolve processing problems, coordinating with all appropriate areasAssist Users/Analysts with the development of system interface specificationsDevelop, write and implement processing requirements and post implementation reviewDevelop time and cost estimates and system modification schedules.Create and deliver presentations to staff and management.Maintain code base and configuration in development and test system environments.Level 3Participate or lead large projects.Independently maintain and develop complex systems and programs.In cooperation with Lead Programmer, mentor and review work for levels 1 and 2.Maintain an extensive knowledge of new developments in programming and healthcare-related topics.Plan, lead, and implement large-scale or cross-functional projects using sound project management methodology.Work with Management to prepare Requests for Proposals (RFPs) for software systemsAssist in implementing new procedures, including workflows, manuals, and training materials.Coordinate and develop training materials for Programmers.Participate in technology planningParticipate in the project prioritization process.Train new staff in the use, understanding, and configuration of the files, terms, and methods used in programming.LEVEL 4Review production and operating policies to ensure that the most efficient processes are in place and determine tactical plans to improve processes and services that can be streamlined and/or improved.Define and implement quality assurance procedures for all assigned activities. Implement quality assurance measures to check adherence to assure continuity, including across lines-of-business when appropriate.Assume leadership role in initiating and completing projects related to increased efficiencies, productivity, and quality.With management, establish and meet short- and long-term department goals in accordance with overall company objectives and divisional strategic planning.Develop staff, including the development and maintenance of training materials for new and existing staff, establishing performance goals, regular follow up with staff and year-end performance evaluations.Ensure service level agreements are established, monitored and managed effectively. Implement action plans to resolve any issues preventing the area from meeting goals.Review and consult on the design and content of projects to ensure consistency.Assure the proper change management protocols are followed to maximize benefit and alleviate unnecessary disruption to the organization and customers.SCRUM Responsibilities (LEVEL 2S AND LEVEL 3S)Levels 2 and 3 may assume SCRUM responsibilities on an interim or project basis. These functions are in addition to those outlined in Level 2 or Level 3.Act as SCRUM master for 1-2 SCRUM teams with a focus on guiding the teams towards process improvement.Participate in project teams as necessary.Facilitate sprint planning, retrospective and sprint demos.Assist product owner with management of backlog.Ensure cross-team coordination.Maintain relevant metrics that help the team monitor performance.Liaise between developers and User Experience/Visual Designers. Foster communication between the disciplines.ALL LEVELSEach progressive level includes the ability to perform the essential functions of any lower levels and mentor employees in those levels.The position requires a full-time work schedule. Full-time is defined as working at least 40 hours per week, plus any additional hours, including evening and weekend hours, as requested or as needed to meet business requirements.Perform all other duties as assigned.REQUIRED COMPETENCIESRequired Job Skills (Applies to All Levels)T-SQL (Transact-SQL)Extensive experience in writing complex T-SQL queries, stored procedures, and functions.Proficiency in optimizing and tuning T-SQL queries for performance.SSIS (SQL Server Integration Services)Strong experience in designing, developing, and deploying SSIS packages.Ability to perform ETL (Extract, Transform, Load) operations using SSIS.Knowledge of SSIS best practices and performance tuning.SSRS (SQL Server Reporting Services)Proficiency in creating, managing, and deploying SSRS reports.Experience in designing and implementing drill-down and drill-through reports.Ability to use SSRS for data visualization and reporting..NET FrameworkExperience with .NET development, including C# and ASP.NET.Knowledge of .NET Core is a plus.Ability to integrate .NET applications with SQL Server.EDI (Electronic Data Interchange)Understanding of EDI standards and protocols.Experience in developing and maintaining EDI transactions.Ability to troubleshoot and resolve EDI-related issues.Familiarity with GitProficiency in using Git for version control.Ability to work with code repositories and collaborate with other developers.Required Professional Competencies (Applies to All Levels)Ability to identify and resolve complex technical issuesProficiency in analyzing data and making data-driven decisionsStrong analytical skills to support independent and effective decisionsPerseverance in the face of resistance or setbacksStrong verbal and written communications skills and the ability to interact professionally with a diverse group, executives, managers, and subject matter expertsAbility to prioritize tasks and work with multiple priorities, sometimes under limited time constraintsEffective interpersonal skills and ability to maintain positive working relationship with othersRequired Leadership Experience and Competencies (Applies to All Levels)Ability to take appropriate risks, using available data.Ability to build synergy with a diverse team in an ever-changing environment.PREFERRED COMPETENCIESPreferred Job Skills (Applies to All Levels)Intermediate skills with spreadsheet, flowcharting, presentation, word processing, and database software.Advanced knowledge and experience with database, programming, and documentation.Knowledge of HIPAA security and privacy standards.Preferred Professional Competencies (Applies to All Levels)Ability to work with ambiguous and conflicting information while keeping focused on the end goal.Preferred Leadership Experience and CompetenciesN/AOur CommitmentAZ 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. #J-18808-Ljbffr