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 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 hybrid work opportunity requires residency, and work to be performed, within the State of Arizona. Purpose of the job Performs 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 QUALIFICATIONS Required Work Experience Experience in computer / information technology Level 1: 1 year Level 2: 3 years Level 3: 5 years Level 4: 7 years Experience in programming, query design, and database development Level 2: 1 year Level 3: 3 years Level 4: 4 years Experience in project management Level 3: 1 year Level 4: 3 years Required Education High-School Diploma or GED in general field of study (Applies to All Levels) Required Licenses N/A Required Certifications N/A PREFERRED QUALIFICATIONS Preferred Work Experience Experience in programming, query design, and database development Level 2: 1 year Level 3: 3 years Level 4: 4 years Experience in project management Level 3: 1 year Level 4: 3 years Supervisory Experience Level 4: 1 year Preferred Education Bachelor’s Degree in computer technology, business, or related field (Applies to All Levels) Preferred Licenses N/A Preferred Certifications Technical Certifications in programming languages (Applies to All Levels) ESSENTIAL JOB FUNCTIONS AND RESPONSIBILITIES Level 1 With 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 management Participate in all aspects of the Systems Development Life Cycle Analyze files and map data from one system to another Adheres to established source control versioning policies and procedures Meet timeliness and accuracy goals. Communicates status of work assignments to stakeholders and management. Level 2 With assistance from Programmer III or Lead, maintain and develop moderately complex systems and programs Participate or lead medium projects. Track and resolve processing problems, coordinating with all appropriate areas Assist Users/Analysts with the development of system interface specifications Develop, write and implement processing requirements and post implementation review Develop 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 3 Participate 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 systems Assist in implementing new procedures, including workflows, manuals, and training materials. Coordinate and develop training materials for Programmers. Participate in technology planning Participate in the project prioritization process. Train new staff in the use, understanding, and configuration of the files, terms, and methods used in programming. LEVEL 4 Review 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 LEVELS Each 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 COMPETENCIES Required 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 Framework Experience with .NET development, including C# and . 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 Git Proficiency 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 issues Proficiency in analyzing data and making data-driven decisions Strong analytical skills to support independent and effective decisions Perseverance in the face of resistance or setbacks Strong verbal and written communications skills and the ability to interact professionally with a diverse group, executives, managers, and subject matter experts Ability to prioritize tasks and work with multiple priorities, sometimes under limited time constraints Effective interpersonal skills and ability to maintain positive working relationship with others Required 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 COMPETENCIES Preferred 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 Competencies N/A 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 . If interested in this position, please apply.