Business Intelligence Developer

  • AvaTrade
  • Tel Aviv, Israel
  • 09/11/2022
Full time Analysts Fintech Forex IT - Software Development

Job Description

AvaTrade, located in Herzliya, is an award-winning online broker operating in the retail trading domain. The company offers a suite of investment tools, products, and services to online traders around the globe.

We are looking for a passionate, and creative Social Media Manager to join our Marcom Team.

Job purpose and scope

The BI Developer will be a part of the Data Core team responsible for design, manage and maintain Datawarehouse’s, analytical products and BI solutions.

Development and operational support of live systems. The BI Developer will report to the BI Team Lead Manager.

Specific responsibilities

  • Responsible for Data development tasks and working across both production and development environments and providing development resource on a project and BAU basis.
  • T-SQL development and performance optimization – design, debugging, and optimization.
  • Design and manage relational data structures.
  • ETL Development - designing and developing data warehousing/business intelligence solution
  • Working Agile, being a Team player, working closely with other units in the company.
  • Support BI live systems when required.

Essential skills/attributes

  • At least 3+ years of experience as BI developer or Data Engineer.
  • Proven experience in Data warehousing and ETLs
  • Proven experience in MS SQL Server 2016 is a must.
  • Proven experience in PostgreSQL.
  • Proven experience with reporting tools such as Tableau/PowerBI/ Qliqview
  • Very Strong in SQL, Store Procedures etc - Strong experience in database performance tuning and query optimizations.

Desirable skills/attributes

  • Experience with BigQuery
  • Experience with Snowflake
  • Work experience with 24x7 high load production environments
  • Appropriate education in computer science/informatics/telecommunications etc.
  • Familiarity with online gaming industry and systems is a big advantage.
  • Experience with Big Data/NoSQL technologies (e.g , Hadoop and spark), and coding data processes via Scala/Java/Python.
  • Experience with data manipulation using Python.
  • Experience with ETL processes using different tools (Airflow,Talend..)