Senior ETL Developer

Senior ETL Developer

The healthcare landscape has never been more dynamic than it is today. Aver is at the forefront of developing leading-edge technology and advanced analytics to navigate this complex environment. Our team is driven by a passion to simplify value-based healthcare through innovation and customized solutions for our clients. Our platform revolutionizes the way payers and providers design, implement, and administer value-based programs.

At Aver, our people are our greatest asset. Our culture is founded upon integrity, hard work, and the relentless pursuit to make a difference. We think creatively, we like a challenge and draw inspiration from each other. As the Senior ETL Developer, you will help implement and improve our existing ETL processes. The ideal candidate will have prior experience working in healthcare, specifically at a payer.

Essential duties include:

• Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.
• Gather requirements and business process knowledge in order to transform the data in a way that’s geared towards the needs of end users.
• Maintain and improve already existing processes.
• Ensure that the data architecture is scalable and maintainable.
• Investigate data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions.

Position Requirements:

• 7+ years of experience as an ETL Developer working in a fast-paced environment.
• In-depth knowledge and understanding of SQL (query performance tuning, index maintenance, etc.), as well as an understanding of database structure.
• Prior experience working in healthcare, specifically at a payer, is a plus.
• Knowledge of data modeling principles.
• Knowledge of at least one ETL tool (Pentaho, SSIS, Informatica, Talend, etc.).
• Knowledge of various SQL/NoSQL data storage mechanisms and Big Data technologies.
• Knowledge of EDI tools and standard data formats is a plus.
• Experience with Bash, Python or other scripting languages is a plus.
• High attention to detail.
• Passionate about complex data structures and problem solving.
• Ability to pick up new data tools and concepts quickly.

Position Perks:

Aver offers competitive benefits and perks to all our “Averians!” Our comprehensive benefits package is one of the many ways we show our employees how valued they are. All full-time Averians are eligible for the following:

• FREE medical, dental, and vision insurance for employees on select plans
• $600 annual contribution into qualifying HSAs
• Matching 401(k) plan
•  
• 4 weeks of paid time off
• Mac laptop and accessories
• Company-paid short-term and long-term disability
• Company-paid life insurance
• Annual professional development stipend

All employees are required to maintain confidentiality as related to patient information. Employees are required to follow the acceptable use policy while using any information systems owned or controlled by Aver. Any disclosures of confidential information made unlawfully outside the proper course of duty will be treated as a serious disciplinary offence. Security roles and responsibilities include:

• Implementing and acting in accordance with the organization’s information security policies
• Protecting assets from unauthorized access, disclosure, modification, destruction, or interference
• Executing particular security processes or activities
• Ensuring responsibility is assigned to the individual for actions taken
• Reporting security events or potential events or other security risks to the organization

The above statements are intended to describe the general nature and level of work being performed by people assigned to this position. The requirements listed above are representative of the minimum knowledge, skill, and/or ability required. To perform this job successfully, an individual must be able to satisfactorily perform the essential functions of the job according to specific company requirements. Reasonable accommodations will be made to enable individuals with disabilities to perform the essential functions. Qualified applicants will be afforded equal employment opportunities without discrimination because of race, creed, color, national origin, sex, disability, or marital status.