Software Engineer IV - ETL Developer

Lifetime Workforce Solutions, LLC; City of Rochester (NY); On-site; USD 87,766 - 157,978; Full time

Benefits offered by this job

Group health and dental insurance

Retirement plan

Paid time off

Paid holidays

Wellness program

Job summary

Lifetime Workforce Solutions, LLC is looking for a Software Engineer to join their team in Rochester, NY. The role involves involvement in the Software Development Life Cycle methodology, focusing on ETL development and collaborating with cross-functional teams.

We seek candidates with programming skills in XML, JavaScript, SQL, and experience with tools like Git and Azure DevOps. Strong problem-solving skills and an understanding of software testing are also required.

Qualifications

• Associate's degree in computer science or related field or three years of experience.
• Basic knowledge of at least one programming language such as C#, .NET, Java, or SQL.
• Basic understanding of one tool or platform such as Informatica or Power BI.

Responsibilities

• Develop code, analyze, research, and resolve associated system issues.
• Participate in on-call production support rotation.
• Collaborate and communicate with team members.

Skills

Programming languages: XML, JavaScript, SQL

ETL Process Development

SQL Proficiency

Basic knowledge of programming languages

Education

Associate’s degree in computer science or related field

Tools

Git

Azure DevOps

Informatica PowerCenter

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 skills and knowledge:

• 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 such as parsing JSON/XML messages.

Accountabilities

LevelI

• Develop code, analyze, research, and resolve associated system issues.
• Participate in on‑call production support rotation.
• Support, maintain, create and follow all documented IT processes and standards, application documentation, and design and code reviews.
• Collaborate and communicate with team members and associates throughout the business to understand requirements and identify application impacts.
• Create individual work plans, specifications and programs with guidance utilizing development procedures and standards.
• Develop skillset in one tool and ability to utilize the approved source control.
• Establish a basic understanding of the Software Development Life Cycle methodology and framework used by your team; demonstrate basic understanding and application one year after hire.
• Consistently demonstrate 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.
• Maintain high regard for member privacy in accordance with corporate privacy policies and procedures.
• Regular and reliable attendance is expected and required.
• Perform other functions as assigned by management.

LevelII (in addition to LevelI accountabilities)

• Participate in strategic discussion and decision‑making.
• Serve as a mentor in technical area(s) of expertise.
• Provide input to creation and documentation of organizational standards.
• Continue development, including the skillset of a second programming language and one tool/platform.
• Develop and implement an intermediate understanding of the Software Development Life Cycle methodology and framework.
• Develop understanding in one supported enterprise technology; demonstrate intermediate understanding and application one year after hire.

LevelIII (in addition to LevelII accountabilities)

• Proactively identify process and technical deficiencies, troubleshoot and offer solutions.
• Identify best practices and participate in creation of organizational standards.
• Progress the Software Development Life Cycle methodology and framework forward by demonstrating advanced understanding and application.
• Provide intermediary understanding of one supported enterprise technology and develop an additional basic understanding of another enterprise technology; demonstrate intermediate understanding and application after one year.

LevelIV (in addition to LevelIII accountabilities)

• Assist with software and system design and architecture within the assigned portfolio.
• Develop strategies to mitigate risk and translate those strategies into specific action plans.
• Act as a subject‑matter expert in technical area(s) of expertise. Identify best practices and drive creation of organizational standards and processes.
• Progress the Software Development Life Cycle methodology and framework forward by demonstrating advanced understanding and application.
• Provide understanding and expertise of two supported enterprise technologies and develop an additional basic understanding of another enterprise technology; demonstrate advanced understanding and application after one year.

Minimum Qualifications

All levels (common base qualifications):

• Associate’s degree in computer science, information technology or related field or three (3) years of experience in lieu of a degree (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 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 or Windows.
• Basic database experience.
• Basic understanding of software testing and quality.
• Demonstrated basic ability to 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 practices aligning with the organization’s business and strategy.
• Basic technical knowledge of authentication, authorization, applied cryptography, data masking, encryption, security vulnerabilities, and remediation.
• Basic understanding of OpenAPI Specification (OAS) and OWASP vulnerabilities and risks.

LevelII (in addition to LevelI qualifications):

• Intermediate knowledge of at least one programming language.
• Intermediate experience with one tool or platform.
• Intermediate knowledge of one operating system.
• Intermediate database experience.
• Intermediate understanding of software testing and quality.
• Intermediate knowledge and familiarity with the Software Development Life Cycle methodologies.
• Intermediate knowledge of source control processes and application.
• Intermediate technical knowledge of authentication, authorization, applied cryptography, data masking, encryption, security vulnerabilities, and remediation.
• Intermediate understanding of OAS and OWASP vulnerabilities and risks.

LevelIII (in addition to LevelII qualifications):

• Advanced knowledge of at least one programming language.
• Advanced knowledge and experience with one tool or platform.
• Advanced knowledge of one operating system.
• 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 authentication, authorization, applied cryptography, data masking, encryption, security vulnerabilities, and remediation.
• Advanced understanding of OAS and OWASP vulnerabilities and risks.

LevelIV (in addition to LevelIII qualifications):

• Expert experience with one tool or platform such as Informatica, CI/CD, Pega, Power BI, or Cognos.
• Expert knowledge of one operating system.
• Expert database experience and understanding of software quality.
• Expert technical knowledge of authentication, authorization, applied cryptography, data masking, encryption, security vulnerabilities, and remediation.
• Expert understanding of OAS and OWASP vulnerabilities and risks.

Physical Requirements

• Ability to work prolonged periods sitting or standing at a workstation and working on a computer.
• Ability to work while sitting or standing at a workstation viewing a computer and using a keyboard, mouse, or phone 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 of time for business continuity.

Equal Opportunity Employer

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.

Compensation Range

LevelIII E7: Min 87,766, Mid 122,872, Max 157,978
LevelIV E8: Min 98,297, Mid 137,616, Max 176,935

The salary range indicated represents the minimum and maximum of the salary range for this position. Actual salary will vary based on budget, experience, knowledge, skill, education, and internal equity. The posted salary range is one component of our total rewards package, which may also include group health and/or dental insurance, retirement plan, wellness program, paid time off, and paid holidays.