Software Engineer (ETL/Informatica)

About the Role

This Software Engineer position focuses on ETL and Informatica work, involving the full Software Development Life Cycle (SDLC) methodology and framework. The role includes directing software system validation, testing methods, and programming initiatives while collaborating with clients and cross-functional departments to communicate project statuses and proposals.

Responsibilities

• Level I:
  • Develops code, analyzes, researches, and resolves system issues.
  • Participates in on-call production support rotation.
  • Supports, maintains, creates, and follows documented IT processes, standards, and application documentation.
  • Collaborates with team members and business associates to understand requirements and identify application impacts.
  • Creates work plans, specifications, and programs with guidance using development procedures and standards.
  • Develops proficiency in one tool and approved source control.
  • Establishes a basic understanding of the SDLC methodology within one year.
  • Maintains high standards of integrity, member privacy, and corporate compliance.
  • Performs other functions as assigned by management.
• Level II (in addition to Level I):
  • Participates in strategic discussions and decision-making.
  • Serves as a mentor in areas of technical expertise.
  • Provides input for organizational standards documentation.
  • Develops skills in a second programming language and one tool/platform.
  • Implements an intermediate understanding of the SDLC methodology.
  • Develops understanding of one supported enterprise technology within one year.
• Level III (in addition to Level II):
  • Proactively identifies process and technical deficiencies, troubleshooting and offering solutions.
  • Identifies best practices and participates in creating organizational standards.
  • Advances the SDLC methodology by demonstrating advanced understanding and application.
  • Provides intermediary understanding of one enterprise technology and develops basic understanding of another.
• Level IV (in addition to Level III):
  • Assists with software and system design and architecture within the assigned portfolio.
  • Develops risk mitigation strategies and translates them into action plans.
  • Acts as a subject matter expert in areas of technical expertise.
  • Drives creation of organizational standards and processes.
  • Demonstrates advanced understanding and application of the SDLC methodology.
  • Provides expertise in two supported enterprise technologies and develops understanding of another.

Requirements

• All Levels:
  • Associate’s degree in computer science, information technology, or related field (or 3 years of experience in lieu of a degree). Bachelor’s degree preferred.
  • Basic knowledge of at least one programming language (e.g., C#/.NET, Java, SQL, C++, Python, Visual Basic, or JavaScript).
  • Basic understanding of one tool/platform (e.g., Informatica, CI/CD, Pega, Power BI, Cognos).
  • Basic knowledge of at least one operating system (Unix-Based or Windows).
  • Basic database experience.
  • Basic understanding of software testing and quality.
  • Demonstrated ability to communicate and partner with team members and leadership.
  • Advanced problem-solving skills.
  • Basic technical knowledge of security architecture principles, authentication, authorization, encryption, and OWASP vulnerabilities.
• Level II (in addition to Level I):
  • Intermediate knowledge of at least one programming language.
  • Intermediate experience with one tool/platform (e.g., Informatica, CI/CD, Pega, Power BI, Cognos).
  • Intermediate knowledge of an operating system (Unix-Based or Windows).
  • Intermediate database experience.
  • Intermediate understanding of software testing and quality.
  • Intermediate knowledge of SDLC methodologies and source control processes.
  • Intermediate technical knowledge of security standards and OWASP risks.
• Level III (in addition to Level II):
  • Advanced knowledge of at least one programming language.
  • Advanced knowledge and experience with one tool/platform (e.g., Informatica, CI/CD, Pega, Power BI, Cognos).
  • Advanced knowledge of an operating system (Unix-Based or Windows).
  • Advanced database experience.
  • Advanced understanding of software testing and quality.
  • Advanced experience with SDLC methodology and source control processes.
  • Advanced technical knowledge of security standards and OWASP risks.
• Level IV (in addition to Level III):
  • Expert experience with one tool/platform (e.g., Informatica, CI/CD, Pega, Power BI, Cognos) or programming language.
  • Expert knowledge of an operating system (Unix-Based or Windows).
  • Expert database experience and understanding of software quality.
  • Expert technical knowledge of security standards and OWASP risks.

Physical Requirements

• Ability to work prolonged periods sitting and/or standing at a workstation using a computer.
• Ability to work while sitting/standing at a workstation for three 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 for business continuity.

Pay

Compensation ranges by level:

• Level I: $60,410 – $106,929
• Level II: $71,880 – $129,384
• Level III: $87,766 – $157,978
• Level IV: $98,297 – $176,935

Actual salary will vary based on experience, knowledge, skills, education, and internal equity.

Benefits

• Group health and/or dental insurance.
• Retirement plan participation.
• Wellness program.
• Paid time off and holidays.

Schedule

Remote work may be possible on a case-by-case basis.