ETL Developer

Company Overview:

Join us in our mission to transform healthcare! RxAdvance, now doing business as nirvanaHealth, is committed to bringing the art of possible to the payer and PBM industries, which is why we strive to invest in our employees throughout all stages of life. Success radiates through all levels of employees here, with competitive benefits, a strong focus on employee wellness, and optional education courses offered through UDEMY: we aim to support all aspects of employee growth.

Characterized by curiosity, innovation, and an entrepreneurial mindset, nirvanaHealth is the first to offer medical and pharmacy benefit management solutions that run on the same platform, made possible by our creation, Aria – the first robotic process automation cloud platform designed for healthcare.

Led by our chairperson John Sculley (former Apple CEO) and noted healthcare entrepreneur and founder of ikaSystems Ravi Ika, nirvanaHealth endeavors to sizably reduce the $900 billion in waste in healthcare administrative and medical costs. We are seeking A-players to join our team – folks who embrace the grind and hustle of a growing company, are collaborative and innovate, are life-long learners and growers, and have an entrepreneurial and positive mindset.

Job Summary :

The ETL Developer is responsible for the design and development of company databases. They are responsible for the technical quality and successful & timely delivery of the project(s). Responsible for managing multiple technical development projects and providing guidance to both onshore and offshore teams.

Job Responsibilities (but not limited to):

• Design, develop, automate, and support complex applications to extract, transform, and load data.
• Create and enhance data solutions, enabling seamless delivery of data.
• Responsible for collecting, parsing, managing, and analyzing large sets of data.
• Use various data warehousing concepts to build a data warehouse for internal departments of the organization.
• Ensure data quality, and cleanup, validate, and verify as needed.
• Work with Data Architects to come up with optimal design for data storage (database) and assist in data modeling.
• Work with the QA team to come up with test cases for different business scenarios and assist and support testing activities.
• Create and update documentation for ETL processes and data flow implemented for building the database needed for application/data warehouse.
• Other duties as assigned

Qualifications:

Education and/or Training:

• Bachelor’s degree in Computer Science or Engineering

Professional Experience:

• Ability to write complex queries to extract data from source databases (Oracle preferred).
• ETL tools experience, such as Talend (preferred) Or Informatica.
• Some level of NoSQL databases experience (MongoDB preferred).
• Object oriented language experience like Python (preferred) or Java and/or .NET experience.
• Data Lake/Warehouse Cloud platform experience (AWS, Redshift preferred).
• Analytics/Reporting tool for OLAP experience (Tableau preferred).
• Oracle PL/SQL development experience (not mandatory but preferred).
• Experience in Unix, Shell scripts and/or PowerShell.

Specialized Skills:

• Team player with a collaborative working style.
• Ability to multitask on different projects and timelines.

Technical Skills:

• 3 years of Oracle/MongoDB database/ETL/Warehouse experience.
• 1 year of AWS Python experience.
  

Additional Considerations:

• Applicants must be able to pass a background investigation as all offers are pending a successful completion of background check per the company policy.