Senior Database Administrator & Data Engineer

Description

Have you ever checked the price of something before you bought it? Yep, thought so (and if you haven’t, please start!). For millions of organizations (literally!) around the world who import, getting a read on global freight prices is way, way harder than a quick Amazon search. And in order for it to work well, the companies that ship need to be able to understand exactly how much it costs on a day to day basis.

That’s where we come in.

Freightos Terminal is the world’s leading freight market intelligence solution. It gives the largest companies in the world - retailers, manufacturers, car makers, freight companies and universities, a real-time pulse into global freight. But for it to work…the numbers have to add up. 

Call it a full stack engineer…but it’s so much more. This role combines the precision of data engineering with software development to keep the bits and bytes moving…so that the companies that move the boxes can do the same.

Responsibilities

• Architect, implement, and maintain highly scalable, available, and performant relational and non-relational databases to handle huge datasets efficiently. 
• Develop, test, and optimize SQL queries for performance and scalability, ensuring low latency and minimal errors.
• Handle database backup, recovery, and disaster recovery planning to ensure data integrity and availability.
• Create new ETL/ELT processes and optimize existing ones. Own data warehousing process and data quality monitoring, using the latest tools and frameworks to enhance efficiency.
• Deploying, managing, and optimizing databases within Docker containers, including creating and maintaining Docker images for databases like MySQL
• Build and maintain APIs and back-end services that enable seamless access to large datasets. Which also keeps us hAPI..
• Mentor and guide junior engineers in best practices related to data engineering and SQL optimization. 
• Work closely with product and data teams to define and deliver technical solutions aligned with business goals. 
• You’ll make sure that the bytes behind the container boxes are shipshape, leading the collection, validation, and analysis of data behind global shipping rates.
• Large organizations can ship well over half a million containers a year. So one decimal in the wrong place is kinda a big deal. You’ll help make sure that doesn’t happen, implementing QA protocols to ensure accuracy, integrity and general awesomeness of our indexes and other data products.

Requirements

Basic Requirements

• 5+ years of experience in data engineering and data analysis (or, as you probably know, SELECT * FROM candidates WHERE career_start_date < DATEADD(year, -5, GETDATE());
• Strong proficiency in SQL and Python programming experience.
• Experience with ETL and data orchestration tools like Airflow. Actual music orchestra experience is cool too but totally unrelated.
• Understanding of RESTful APIs.
• High level of business English (written & verbal).
• Strong project management, problem solving, organizational skills, attention to detail, and ownership. 

Preferred Requirements

• Experience with low-latency databases such as TimescaleDB, Cassandra, ClickHouse, CockroachDB, or similar technologies.
• Experience with Google Cloud Platform (GCP).
• Knowledge of statistical analysis, regression models, and forecasting techniques.
• Familiarity with data visualization tools (e.g., Domo, Zoho Analytics, Tableau, Power BI) and big data technologies (e.g. Hadoop, Spark).
• Experience with logistics is nice. Hey, a company can dream, right?