Software Engineer IV - ETL Developer

Excellus BCBS; City of Albany (NY); Hybrid; USD 87,766 - 157,978; Full time

Benefits offered by this job

Group health and dental insurance

Retirement plan

Paid time away from work

Paid holidays

Job summary

Excellus BCBS is seeking a Software Engineer in Albany, New York, responsible for ETL process development and software programming initiatives. The ideal candidate will have knowledge in programming languages like SQL, XML, and JavaScript, along with experience in tools such as Git and Informatica. Responsibilities include code development, system issue resolution, and collaboration across departments. The position may offer remote work opportunities, with a competitive salary range depending on experience.

Qualifications

• Basic knowledge of at least one programming language, such as C#/.NET, Java, SQL, C++, Python, Visual Basic or JavaScript.
• Intermediate understanding of software testing and quality.
• Basic database experience.

Responsibilities

• Develops code, analyzes, researches, and resolves associated system issues.
• Participates in on-call production support rotation.
• Collaborates and communicates with team members and associates.

Skills

XML

JavaScript

SQL

C#/.NET

Python

Education

Associate's degree in computer science, information technology or related field

Bachelor’s degree preferred

Tools

Informatica

Git

Azure Devops

Job description

Overview

Job Description: The Software Engineer is responsible for working on projects that are currently being visualized or developed by our organization. This role will be involved with the Software Development Life Cycle methodology and framework, directing software system validation and testing methods, as well as directing software programming initiatives. This position works closely with clients and cross-functional departments to communicate project statuses and proposals.

Summary

The Software Engineer is responsible for working on projects that are currently being visualized or developed by our organization. This role will be involved with the Software Development Life Cycle methodology and framework, directing software system validation and testing methods, as well as directing software programming initiatives. This position works closely with clients and cross-functional departments to communicate project statuses and proposals.

This Role Is Specific To ETL Development

• Key information - Knowledge of Programming languages: XML, JavaScript, SQL
• Developer Tools: Git, Azure Devops, CDIPC - Cloud Data Integration for PowerCenter
• ETL Process Development: Design, develop, and maintain ETL processes using Informatica PowerCenter or other relevant Informatica tools.
• SQL Proficiency: Utilize SQL/PLSQL to extract, transform, and load data.
• Exposure to advanced transformations like data transformations, Parsing JSON/XML messages

Essential Accountabilities

Level I

• Develops code, analyzes, researches, and resolves associated system issues.
• Participates in on-call production support rotation.
• Supports, maintains, creates and follows all documented IT processes and standards, application documentation and design and code reviews.
• Collaborates and communicates with team members and associates throughout the business to understand requirements and identify application impacts.
• Creates individual work plans, specifications and programs with guidance utilizing development procedures and standards.
• Develops skillset in one tool and ability to utilize the approved source control.
• Establishes a basic understanding of the Software Development Life Cycle methodology and framework used by the team, post one year demonstration of basic understanding and application of this skill.
• Consistently demonstrates high standards of integrity by supporting the Lifetime Healthcare Companies’ mission and values, adhering to the Corporate Code of Conduct, and aligning with the Lifetime Way values and beliefs.
• Maintains high regard for member privacy in accordance with corporate privacy policies and procedures.
• Regular and reliable attendance is expected and required.
• Performs other functions as assigned by management.

Level II (in addition to Level I Accountabilities)

• Participates in strategic discussion and decision-making.
• Provides mentorship in their area(s) of technical expertise.
• Provides input to creation and documentation of organizational standards.
• Continual development including the skillset of a second programming language and one tool/platform.
• Develops and implements an intermediate understanding of the Software Development Life Cycle methodology and framework.
• Develops understanding in one supported enterprise technology, post one year demonstration of intermediate understanding and application.

Level III (in addition to Level II Qualifications)

• Proactively identifies process and technical deficiencies, troubleshooting and offering solutions to resolve.
• Identifies best practices and participates in creation of organizational standards.
• Progresses the Software Development Life Cycle methodology and framework forward by demonstrating advanced understanding and application.
• Provides intermediary understanding of one supported enterprise technology and developing an additional basic understanding of another enterprise technology. Post one year demonstration of intermediate understanding, and application of an additional technology.

Level IV (in addition to Level III Qualifications)

• Assists with software and system design and architecture within the assigned portfolio.
• Develops strategies to mitigate risk and translates those strategies into specific action plans.
• Acts as a subject matter expert in their area(s) of technical expertise. Identifies best practices and drives creation of Organizational Standards and processes.
• Progresses the Software Development Life Cycle methodology and framework forward by demonstrating advanced understanding and application.
• Provides understanding and expertise of two (2) supported enterprise technologies and developing an additional basic understanding of another enterprise technology. Post one year demonstration of advanced understanding, and application of, additional technologies.

Minimum Qualifications

Note: We include multiple levels of classification differentiated by demonstrated knowledge, skills, and the ability to manage increasingly independent and/or complex assignments. This also provides guideposts for employee development and promotional opportunities.

All Levels

• Associate's degree in computer science, information technology or related field. In lieu of a degree, three (3) years of experience required. Bachelor’s degree preferred.
• Basic knowledge of at least one programming language, such as C#/.NET, Java, SQL, C++, Python, Visual Basic or JavaScript.
• Basic understanding of one of the following tools/platforms: Informatica, CI/CD, Pega, Power BI, Cognos.
• Basic knowledge of at least one operating system, such as Unix-Based or Windows.
• Basic database experience
• Basic understanding of software testing and quality.
• Demonstrated basic ability to effectively communicate and partner with team members and direct leadership to understand user stories and identify application and system impacts.
• Demonstrated advanced problem-solving skills.
• Demonstrated basic ability to implement security architecture principles, and best practice standards that align to the Organization’s overall business and strategy.
• Basic technical knowledge of techniques, standards, and state-of-the-art capabilities for authentication and authorization, applied cryptography, data masking, encryption, security vulnerabilities, and remediation.
• Basic understanding of OpenAPI Specification (OAS) and Open Web Application Security Project (OWASP) vulnerabilities and risks.

Level II (in Addition To Level I Qualifications)

• Intermediate knowledge of at least one programming language, such as C#/.NET, Java, SQL, C++, Python, Visual Basic or JavaScript.
• Intermediate Experience with one of the following tools/platforms such as Informatica, CI/CD, Pega, Power BI, Cognos.
• Intermediate knowledge of at least one operating system, such as Unix-Based or Windows.
• Intermediate database experience
• Intermediate understanding of software testing and quality.
• Intermediate knowledge and familiarity with Software Development Life Cycle methodologies.
• Intermediate knowledge of source control processes and application.
• Intermediate technical knowledge of security principles including authentication, authorization, cryptography, data masking, encryption, vulnerabilities, and remediation.
• Intermediate understanding of OpenAPI Specification (OAS) and OWASP risks.

Level III (in Addition To Level II Qualifications)

• Advanced knowledge of at least one programming language, such as C#/.NET, Java, SQL, C++, Python, Visual Basic or JavaScript.
• Advanced knowledge and experience with one tool/platform such as Informatica, CI/CD, Pega, Power BI, Cognos.
• Advanced knowledge of at least one operating system, such as Unix-Based or Windows.
• Advanced database experience
• Advanced understanding of software testing and quality.
• Advanced experience with the Software Development Life Cycle methodology and framework.
• Advanced knowledge of source control processes and applications.
• Advanced technical knowledge of security principles including authentication, authorization, cryptography, data masking, encryption, vulnerabilities, and remediation.
• Advanced understanding of OpenAPI Specification (OAS) and OWASP risks.

Level IV (in Addition To Level III Qualifications)

• Expert experience with one or more tools/platforms such as Informatica, CI/CD, Pega, Power BI, Cognos or the above programming languages.
• Expert knowledge of at least one operating system, such as Unix-Based or Windows.
• Expert database experience and understanding of software quality.
• Expert technical knowledge of security principles including authentication, authorization, cryptography, data masking, encryption, vulnerabilities, and remediation.
• Expert understanding of OpenAPI Specification (OAS) and Open Web Application Security Project (OWASP) vulnerabilities and risks.

Physical Requirements

• Ability to work prolonged periods sitting and/or standing at a workstation and working on a computer.
• Ability to work while sitting and/or standing at a workstation viewing a computer and using a keyboard, mouse and/or phone for three (3) or more hours at a time.
• Ability to travel across the Health Plan service region for meetings and/or trainings as needed.
• Ability to work in a home office for continuous periods of time for business continuity.

In support of the Americans with Disabilities Act, this job description lists only those responsibilities and qualifications deemed essential to the position.

Equal Opportunity Employer

Compensation Range(s)

• Level III E7 - Min 87,766 Mid 122,872 Max 157,978
• Level IV E8 - Min 98,297 Mid 137,616 Max 176,935

The salary range indicated in this posting represents the minimum and maximum of the salary range for this position. Actual salary will vary depending on factors including, but not limited to, budget available, prior experience, knowledge, skill and education as they relate to the position’s minimum qualifications, in addition to internal equity. The posted salary range reflects just one component of our total rewards package. Other components of the total rewards package may include participation in group health and/or dental insurance, retirement plan, wellness program, paid time away from work, and paid holidays.

Please note: There may be opportunity for remote work within all jobs posted by the Excellus Talent Acquisition team. This decision is made on a case-by-case basis.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.