Software Engineer IV - ETL Developer

Job Description:

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 use by your 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 leading to the Lifetime Way values and beliefs.
• Maintains high regard for member privacy in accordance with the 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.
• Serves as a mentor in their area(s) of technical expertise.
• Provides input to creation and documentation of organizational standards.
• Continuous 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 Accountabilities)

• 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 Accountabilities)

• 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, broader responsibility, additional decision making, and in some cases, becoming a resource to others. In addition to using this differentiated approach to place new hires, it 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 (1) programming language, such as C#/. NET, Java, SQL, C++, Python, Visual Basic or JavaScript.
• Basic understanding of one (1) of the following tools/platforms such as: Informatica, CI/CD, Pega, Power BI, Cognos.
• Basic knowledge of at least one (1) 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 (1) programming language, such as C#/.NET, Java, SQL, C++, Python, Visual Basic or JavaScript.
• Intermediate Experience with one (1) of the following tools/ platforms such as, Informatica, CI/CD, Pega, Power BI, Cognos.
• Intermediate knowledge of at least one (1) operating system, such as Unix-Based or Windows.
• Intermediate database experience
• Intermediate understanding of software testing and quality.
• Intermediate knowledge and familiarity with the Software Development Life Cycle development methodologies.
• Intermediate knowledge of source control processes and application.
• Intermediate technical knowledge of techniques, standards, and state-of-the-art capabilities for authentication and authorization, applied cryptography, data masking, encryption, security vulnerabilities, and remediation.
• Intermediate understanding of OpenAPI Specification (OAS) and Open Web Application Security Project (OWASP) vulnerabilities and risks.

Level III (in addition to Level II Qualifications)

• Advanced knowledge of at least one (1) programming language, such as C#/.NET, Java, SQL, C++, Python, Visual Basic or JavaScript.
• Advanced knowledge and experience with one (1) of the following tools/platforms, such as Informatica, CI/CD, Pega, Power BI, Cognos.
• Advanced knowledge of at least one (1) 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 application.
• Advanced technical knowledge of techniques, standards, and state-of-the-art capabilities for authentication and authorization, applied cryptography, data masking, encryption, security vulnerabilities, and remediation.
• Advanced understanding of OpenAPI Specification (OAS) and Open Web Application Security Project (OWASP) vulnerabilities and risks.

Level IV (in addition to Level III Qualifications)

• Expert experience with one (1) of the following tools/ platforms such as Informatica, CI/CD, Pega, Power BI, Cognos or the above programming languages.
• Expert knowledge of at least one (1) operating system, such as Unix-Based or Windows.
• Expert database experience and understanding of software quality.
• Expert technical knowledge of techniques, standards, and state-of-the-art capabilities for authentication and authorization, applied cryptography, data masking, encryption, security 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 Max157,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.