ETL Developer

Advantage Tech is looking for an ETL Developer for our remote client.

• Work with clients and other stakeholders to map client data into Current™ schema. This will require a good understanding of the client’s business processes and of the Current™ software
• Build data transformation pipeline if needed using ETL scripts to transform client data into a format usable by Current™
• Work with the IT teams to set up automated data transfer from the client system into Current™ using a variety of methods – file based, API etc.
• Diagnose, research, and resolve technical issues independently or with other team members
• Analyze and improve performance of data transformation and ingestion pipeline as needed

• Strong analytical skills to grasp the client’s needs and build the data map
• Problem solving attitude – being able to dive into an unexpected situation and come up with creative solutions
• In-depth knowledge of SQL 
• Strong written and verbal communication skills
• Experience in or knowledge of one of the following (the more, the better):
  • ETL tools
  • Web APIs is desired
  • Azure or other Cloud Based environment
  • Data Factory or similar Data Management and Transformation tool
  • Familiarity with CosmosDB or another noSQL database
  • Python or some other scripting language
• Expertise in Health & Human Services organizations will be a big plus