Software Engineer - ETL
The Software Engineer at Confidential Client is responsible for developing, testing, and maintaining software systems within the healthcare domain, following the Software Development Life Cycle methodology. This role involves collaboration with clients and cross-functional teams to deliver high-quality software solutions, support production environments, and contribute to continuous process and technical improvements. The position offers progressive levels of responsibility, including mentorship, strategic input, and expertise in enterprise technologies and security practices.
About Careertakes
👉 Important disclosure: Careertakes is a third-party recruiting platform supporting this hiring process. If selected, you will be employed directly by our client, Insurance.
Applicants for this role may also receive access to additional matched opportunities through the Careertakes platform.
What You’ll Do
Confidential Client is hiring a Software Engineer - ETL to design, build, test, and support ETL pipelines that move and transform data used across analytics, reporting, and operational systems. This role follows SDLC best practices and works closely with product owners, data analysts, QA, and operations teams.
- Develop, maintain, and optimize ETL jobs and data transformations (Informatica, SQL, Python, etc.).
- Participate in the full Software Development Life Cycle: design, code, review, test, deploy, and operate.
- Troubleshoot production issues; participate in an on-call rotation for production support.
- Implement automated testing and CI/CD pipelines for ETL deployments.
- Ensure data quality, security, and compliance with privacy requirements.
- Produce and maintain technical documentation, runbooks, and code reviews.
- Collaborate across teams to translate user stories and data requirements into implementation plans.
- Mentor junior engineers (Level II and above) and contribute to technical standards and best practices.
Qualifications
All levels are considered; the role is classified across four levels (I–IV) with increasing responsibility and complexity.
- Associate’s degree in Computer Science, Information Technology or related field; or 3 years of relevant experience. Bachelor’s degree preferred.
- Practical experience with at least one programming language (C#/.NET, Java, SQL, C++, Python, Visual Basic, or JavaScript).
- Working knowledge of ETL tools/platforms such as Informatica, CI/CD tools, Pega, Power BI, or Cognos.
- Familiarity with Unix-based or Windows operating systems and relational databases.
- Understanding of software testing, quality assurance, and source control processes.
- Awareness of security principles: authentication/authorization, applied cryptography, data masking, encryption, and remediation of vulnerabilities.
- Familiarity with OpenAPI (OAS) and OWASP risks.
- Strong problem-solving, communication, and teamwork skills.
- Levels II–IV require intermediate to advanced skills and additional hands-on experience as described in the Confidential Client’s leveling guidelines.
Preferred / Nice-to-have
- Hands-on experience building CI/CD pipelines for data workflows.
- Deep SQL tuning and performance optimization.
- Experience with Power BI or Cognos for reporting and analytics.
- Prior experience in healthcare, insurance, or highly regulated environments.
Compensation & Benefits
The Confidential Client provides a competitive total rewards package. Salary ranges (annually) posted by the hiring organization:
- 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 depend on experience, skills, education, and internal equity. Benefits may include medical/dental, retirement plan, paid time off, and paid holidays.
Location & Work Model
- Job location: Buffalo, NY (on-site). The Confidential Client notes the opportunity for remote work may be possible on a case-by-case basis; final decisions are made by the hiring team.
- Ability to travel within the service region for meetings or training may be required.
- Reasonable accommodations are available in accordance with the Americans with Disabilities Act (ADA).
Why Join
- Work on meaningful data projects that support analytics and business decisions in the Insurance industry.
- Opportunity to grow across technical levels (I–IV) with mentorship, training, and cross-functional collaboration.
- Join a team that values security, data quality, and continuous improvement.
Equal Opportunity & Hiring Transparency
Careertakes and our client are Equal Opportunity Employers committed to building a diverse and inclusive workforce. We prohibit discrimination or harassment of any kind. To support a fair and efficient hiring process, AI tools may be used to assist with application review or resume screening. These tools do not replace human decision-making. Final hiring decisions are made by people.
If you have questions about how your data is used, please contact us directly.
Negotiate a higher salary! Check the salary ranges for this job type in your area.
View My Salary Range