Software Engineer - ETL

Excellus BCBS•Rochester, NY

2d•$60,410 - $176,935

About The Position

The Software Engineer works on projects being visualized or developed by the organization. The role participates in the Software Development Life Cycle (SDLC), software system validation and testing, and software programming initiatives. It works closely with clients and cross-functional departments to communicate project status and proposals. The position is classified across four levels, with increasing technical expertise, independence, complexity, decision-making, and responsibility. At Level I, the engineer develops and reviews code, investigates and resolves system issues, participates in an on-call production support rotation, follows documented IT processes and standards, and collaborates with business partners to understand requirements and application impacts. The role creates work plans, specifications, and programs with guidance and develops proficiency in a tool and approved source control. Levels II through IV add progressively greater contributions: strategic participation and mentoring; identifying and resolving process and technical deficiencies; advancing organizational best practices and standards; and, at Level IV, contributing to software and system design and architecture, developing risk-mitigation strategies, and acting as a subject matter expert. Across the levels, the engineer is expected to develop deeper SDLC expertise and knowledge of supported enterprise technologies. The role supports the organization’s mission and values, adheres to its code of conduct and privacy policies, maintains member privacy, and requires regular, reliable attendance. Other functions may be assigned by management. The job may involve travel across the Health Plan service region for meetings or training and working from a home office for business continuity. Compensation varies by level, experience, knowledge, skills, education, budget, and internal equity. Remote work may be considered case by case.

Requirements

Associate's degree in computer science, information technology, or a related field; in lieu of a degree, three years of experience is required.
Basic knowledge of at least one programming language, such as C#/.NET, Java, SQL, C++, Python, Visual Basic, or JavaScript.
Basic understanding of at least one tool or platform, such as Informatica, CI/CD, Pega, Power BI, or Cognos.
Basic knowledge of at least one operating system, such as Unix-based systems or Windows.
Basic database experience.
Basic understanding of software testing and quality.
Ability to communicate and partner effectively with team members and direct leadership to understand user stories and identify application and system impacts.
Demonstrated advanced problem-solving skills.
Basic ability to implement security architecture principles and best-practice standards aligned with the organization's business and strategy.
Basic technical knowledge of 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.
For Level II and above, intermediate or higher knowledge and experience in programming, tools/platforms, operating systems, databases, software testing and quality, SDLC methodologies, and source control, with level-specific proficiency.
For Level III and above, advanced SDLC experience and advanced technical knowledge of security techniques, standards, and capabilities, as well as OAS and OWASP vulnerabilities and risks.
For Level IV, expert experience with a listed tool/platform or programming language, expert operating-system and database knowledge, and expert knowledge of software quality, security practices, and OAS and OWASP risks.
Ability to work for prolonged periods sitting and/or standing at a workstation and using a computer.
Ability to sit and/or stand at a workstation while viewing a computer and using a keyboard, mouse, and/or phone for three or more hours at a time.
Ability to travel across the Health Plan service region for meetings and/or training as needed.
Ability to work in a home office for continuous periods for business continuity.

Nice To Haves

Bachelor’s degree.

Responsibilities

Develop code and analyze, research, and resolve associated system issues.
Participate in the on-call production support rotation.
Support, maintain, create, and follow documented IT processes and standards, application documentation, and design and code reviews.
Collaborate and communicate with team members and associates across the business to understand requirements and identify application impacts.
Create individual work plans, specifications, and programs with guidance, using development procedures and standards.
Develop proficiency in tools, source control, programming languages, platforms, and enterprise technologies appropriate to the assigned level.
Participate in strategic discussions and decision-making at Level II and above.
Mentor colleagues in areas of technical expertise at Level II and above.
Contribute to the creation and documentation of organizational standards; identify best practices and, at higher levels, drive standards and process creation.
Proactively identify process and technical deficiencies, troubleshoot issues, and offer solutions at Level III and above.
Assist with software and system design and architecture within the assigned portfolio at Level IV.
Develop strategies to mitigate risk and translate them into specific action plans at Level IV.
Act as a subject matter expert in areas of technical expertise at Level IV.
Support the organization's mission and values, follow its Corporate Code of Conduct, and maintain member privacy in accordance with corporate policies and procedures.
Maintain regular and reliable attendance and perform other functions assigned by management.
Travel across the Health Plan service region for meetings and/or training as needed.
Work in a home office for continuous periods when needed for business continuity.