Programmer II - Hybrid

Blue Cross Blue Shield of Arizona•Phoenix, AZ

3d•Hybrid

About The Position

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

Requirements

1 year of experience in computer / information technology (Level 1).
3 years of experience in computer / information technology (Level 2).
1 year of experience in programming, query design, and database development (Level 2).
High-School Diploma or GED in general field of study.
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 ASP.NET. 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.
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.
Ability to take appropriate risks, using available data.
Ability to build synergy with a diverse team in an ever-changing environment.
Residency within the State of Arizona.
Work to be performed within the State of Arizona.

Nice To Haves

Knowledge of .NET Core is a plus.
Preferred Work Experience in programming, query design, and database development Level 2: 1 year Level 3: 3 years Level 4: 4 years.
Preferred Work 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 Certifications Technical Certifications in programming languages (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.
Ability to work with ambiguous and conflicting information while keeping focused on the end goal.

Responsibilities

Maintain and develop basic-level systems and programs with assistance.
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.
Maintain and develop moderately complex systems and programs with assistance.
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.
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.
Perform all other duties as assigned.