Idan Avrahami

Data Engineer at Jutomate
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Israel, IL
Languages
  • Hebrew Native or bilingual proficiency
  • English Professional working proficiency
  • Spanish Limited working proficiency

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • Rivery Developer Certificate
    Rivery
    Nov, 2022
    - Nov, 2024

Experience

  • Jutomate
    • United Kingdom
    • Software Development
    • 1 - 100 Employee
    • Data Engineer
      • Nov 2021 - Present

      ✔ Project management that included building an end-to-end data model ✔ Transferring data between Postgresql and BigQuery databases ✔ Transfer of BI infrastructure from Graphana tools to Postgresql and BigQuery ✔ Building an effective, fast and cost-effective data model from the queries that exist in the BI infrastructure ✔ Mapping the data model and optimizing the use of data usage tables Building a data model: ✔ Data Ingestion ✔ Data transformation and cleansing ✔ Modeling - query translation, QA, data validation ✔ Connection to the business logic ✔ Meetings with the customers to understand the business model ✔ Building a data model that fits the client's needs ✔ Transferring the BI infrastructure successfully. Database Administration: ✔ Managed database versions, ensuring proper database maintenance and updates. ✔ Developed stored procedures, functions, rules, and triggers to support the development team, improving workflows and efficiency. ✔ Formatted all database tables with consistent naming conventions and applied primary and foreign keys, ensuring data accuracy and integrity ✔ Monitored database performance using cloud tools, identifying and resolving issues to minimize downtime and improve performance. Project with the marketing team- Meeting all the requirements of our customers: - Connecting the database to all marketing and analytics platforms (Facebook, Twitter, Google Analytics...) - Building an end-to-end data model - entering the data from each platform - Cleaning the data and consolidating it into a data model. Show less

  • The Open University of Israel
    • Israel
    • Higher Education
    • 700 & Above Employee
    • English Exams Tutor / Logistics and Technical Support for the examinations department.
      • Oct 2017 - Oct 2021

      - In charge of organizing and dispatching the exams equipment to the university's exams centers. - Reading and dictation in English exams. - In charge of organizing and dispatching the exams equipment to the university's exams centers. - Reading and dictation in English exams.

  • Israel Airports Authority - IAA
    • Israel
    • Airlines and Aviation
    • 200 - 300 Employee
    • Security Agent at Ben Gurion Airport
      • Aug 2014 - Oct 2017

      - Questioning passengers for possible security threats. - Issuing passengers pre-flight security classification. - Patience, tolerance and representability towards the service recipients. - Questioning passengers for possible security threats. - Issuing passengers pre-flight security classification. - Patience, tolerance and representability towards the service recipients.

  • Israel Defense Forces
    • Israel
    • Armed Forces
    • 700 & Above Employee
    • Soldier and a Team Leader in combat unit 636 of Field Intelligence
      • Jul 2011 - Jul 2014

      - Managing a team of soldiers under harsh conditions. - Studying and using advanced intelligence systems. - Finding creative solutions for complex situations. - Managing a team of soldiers under harsh conditions. - Studying and using advanced intelligence systems. - Finding creative solutions for complex situations.

Education

  • Ben-Gurion University of the Negev
    Bachelor of Science - BS, Industrial Engineering & Management
    2017 - 2022

Community

You need to have a working account to view this content. Click here to join now