Software Engineer - ETL Developer (Remote)

CareFirst BlueCross BlueShield is a health insurance organization seeking a Software Engineer - ETL Developer to support its Health Insurance Billing and Finance systems. The role designs, develops, tests, documents, debugs, and maintains ETL software and data integrations while analyzing requirements, resolving defects, and collaborating with stakeholders and development teams.

Responsibilities:

• Performs software analysis, including requirements and uses case development and design including ETL requirements and data integration design. Implements and documents source code to design specifications. Performs software testing including developing and running automated unit tests, drafting, and executing structured automated test cases. Develop and/or analyze interface design documentation. Comply with hardware and software systems standards and procedures. Assist in the estimation of development of application features, ETL solutions, and data integration
• Analyzes, debugs, and corrects reported ETL software bugs and enhancements. Updates user and software documentation. Compile, assess, and report data results from software testing and analysis
• Analyzes and implements ETL functional requirements and designs, implements, and tests software. Performs operations & maintenance (O&M) of existing systems. Identifies areas for improvement and streamlining
• Writes system design and application code documentation, including ETL and data integration documentation. Gathers, analyzes, and composes technical information
• Analyzes data and provides expertise in interpreting results and gathers and documents technical and functional user requirements and specifications
• Participates in regular meetings, providing status on current tasks. Participates in peer reviews of software development artifacts. Continuous learning of technologies trends, and best practices

Requirements:

• Education Level: Bachelor's Degree in Information Technology or Computer Science OR in lieu of a Bachelor's degree, an additional 4 years of relevant work experience is required in addition to the required work experience
• Experience: 3 years software development experience in object-oriented language
• Knowledge of ETL programming language
• Knowledge and understanding of software development life cycle (SDLC)
• Excellent communication skills both written and verbal
• Ability to recognize, analyze, and solve a variety of problems
• Basic understanding of cloud technologies (e.g. Azure, AWS)
• Basic understanding of database technologies (e.g. Cloud, SQL, Oracle, PostgreSQL, etc.)
• Fundamental knowledge of software engineering best practices, agile methodologies, and CI/CD pipelines
• Knowledge of test-first practices including Test-Driven Development (TDD) for unit tests and Behavior-Driven Development (BDD) for automated acceptance tests
• Knowledge of DevOps practices and tools
• Knowledge of code quality and promotion practices
• Must be eligible to work in the U.S. without Sponsorship
• Knowledge of reporting tool preferred (e.g. Power Bi)