Data Engineer

About us:

Makor Group was established in 2011. Makor is a leading international brokerage firm with offices in London, New York, Tel Aviv, Paris, Geneva, Gibraltar, Singapore and Melbourne.

About the Role:

We are seeking a technically focused Data Engineer to drive data warehouse management, invoice reconciliation automation, and process optimization.

Key Responsibilities:

• Data Warehouse Management: Design, maintain, and optimize data warehouse architecture to support cross-departmental analytics and reporting needs
• Invoice Reconciliation: Lead automated reconciliation processes for invoices across the entire group and implementing data validation
• Process Automation: Develop and deploy automated reporting solutions and data pipelines to eliminate manual processes and improve data accuracy

Job Requirements:

Education & Experience:

• Bachelor’s degree in Computer Science, Business Administration, Economics, Finance, Mathematics, Statistics, or another related analytical field
• 4-6 years of experience in data engineering or related technical analytical roles
• Required: Hands-on experience with data warehouse design, implementation, and management
• Required: Experience with financial data automation

Technical Skills:

Core Requirements:

• Advanced SQL proficiency for complex database querying, data manipulation, and performance optimization - required
• Data warehouse management experience with dimensional modeling, ETL processes, and data architecture - required
• Process automation using scripting languages (Python, PowerShell) or automation tools - required
• Advanced proficiency in Microsoft Excel - required

Highly Preferred:

• PostgreSQL expertise including query optimization, stored procedures, and database administration
• Power Query for advanced data transformation and data modelling
• AWS cloud services experience (RDS, S3, Lambda, Glue) for data storage and processing
• API integration experience for data extraction and system connectivity

Core Competencies:

• Proven ability to design and implement automated solutions for complex business processes
• Ability to work independently and manage multiple technical projects simultaneously in a fast-paced environment
• Strong collaborative skills for working with IT, Finance, and Operations teams

Language Requirements:

• Fluent in English (written and verbal) - required
• Hebrew language is not required

Role Focus: This position is strictly internal facing with primary emphasis on technical data analysis, system automation, and data infrastructure management.

Hybrid position 50% in Ramat Gat / 50% remote.