Edvantis opens the position of ETL Engineer to extend the project of our partner, a US-based data analytics company that serves companies operating in the energy industry, especially those focused on exploration and production activities. Its product portfolio includes data sets, reports, alerts, analytics tools, databases, data management tools, and expert advisory, among other services designed to track, analyze and distribute information about onshore oil and gas drilling activities, giving its clients a complete perspective of the sector in the investment decision-making process. Customer develops a large ecosystem of products related to that domain including complex data storages and pipelines, web, mobile, and desktop.
Lots of challenging tasks, great communication with the client. Friendly team atmosphere.

Responsibilities:

  • Evaluate business requirements and write scripts that follow project architecture
  • Write scripts in Python for Extracting Data from TXT, CSV , PDF, JSON and XML files
  • Develop ETL process to migrate data from MS SQL to AWS using Python
  • Develop/support an ETL service that looks for the files in the S3 and load to DB
  • Work with Elasticsearch Indexes
  • Analyze system logs and troubleshooting

Requirements:

  • 4+ years of experience as ETL Developer or Data Engineer
  • 2+ years of experience with Python, PySpark
  • Strong knowledge of MS SQL
  • Experience in AWS concepts & services (specifically Glue, Lambda, Step Functions, S3)
  • CI/CD expertise (Hashicorp Vault, Terraform, and Atlantis; or equivalents)
  • English level – Upper-Intermediate or high

We offer:

  • Career and professional growth
  • Competitive salary
  • Friendly and highly professional teams
  • Big and comfortable office, own parking area, restaurants nearby
  • Medical insurance coverage for employees (Сovid-19 included), plus an option for family insurance coverage at a corporate rate
  • Paid 12 sick leaves and all holidays
  • Paid 18 working vacation days
  • English/German language courses

To Apply for this Job, Fill in the Form and Upload Your Resume

    This is a required field
    This is a required field
    This is a required field
    This is a required field
    The telephone number is invalid