Senior Data Engineer
About this role
About AllCloud
AllCloud is a leader in amplifying organizations’ cloud potential through AI. With a track record of hundreds of successful migrations and implementations across AWS and Salesforce, AllCloud has developed strategies and solutions that enable businesses of all sizes to remain at the forefront of innovation.
AllCloud is a leader in AI-led professional and managed services. As an AWS Premier and audited managed services Partner, and Salesforce Consulting partner, AllCloud provides comprehensive AI-led cloud journey support, from initial migration to ongoing management through our Engage Managed Services. Our expertise ensures that clients remain aligned with ecosystem best practices while focusing on their core business growth.
AllCloud serves clients across the globe with offices in EMEA and North America. www.allcloud.io
Job Description
We are looking for a talented and experienced Mid-Level Data Engineer with a passion for data and cloud technologies to join our team. In this role, you will be a key player in designing, developing, and maintaining our AWS and Databricks-based data platform. You will bridge the gap between robust Data Engineering, Database Administration (DBA), and high-performance Analytics Engineering.
The ideal candidate understands the Lakehouse architecture, has experience managing modern cloud data warehouses like Snowflake, and possesses the ability to build scalable ETL pipelines that drive data-driven business decisions.
Key Responsibilities
- End-to-End Pipelines: Develop and maintain complex ETL/ELT pipelines using Python/PySpark on the Databricks platform, as well as loading and transforming data within Snowflake.
- Data Architecture: Implement and manage data layers following the Medallion architecture (Bronze, Silver, Gold) using Delta Lake.
- Optimization & Analytics: Set up and manage Databricks SQL Warehouses, perform query optimization, and utilize internal visualizations for rapid data exploration.
- Cloud Infrastructure: Leverage AWS cloud services to manage data storage, compute resources, and secure data movement.
- DBA & Performance Tuning: Act as a custodian for our data platform—managing indexing, clustering, vacuuming, and performance tuning across both Delta Lake and relational/warehouse environments to ensure cost-efficiency and high speed.
- Data Modeling: Design data models (Star Schema / Snowflake) in the Gold layer to ensure optimal performance for BI tools (e.g., Power BI, Tableau).
- Data Governance: Manage metadata, permissions, and lineage using Unity Catalog and platform-specific access controls.
- Quality Control: Implement automated Data Quality tests as an integral part of the CI/CD data pipelines.
Requirements
- Professional Experience: 5+ years of experience as a Data Engineer or Data Engineer/DBA – Must.
- Cloud & Warehouse Expertise: Strong hands-on experience with the AWS ecosystem (S3, IAM, EC2, etc.) and modern cloud data warehouses, specifically Snowflake.
- Databricks Expertise: At least 1 year of intensive, hands-on experience with the Databricks platform (including Notebooks and Workflows).
- Development & DBA Skills:
- High proficiency in PySpark (or Spark Scala).
- Expertise in writing complex SQL (Window Functions, CTEs) alongside DBA-level performance tuning (query profiling, indexing, partition pruning).
- Technical Knowledge: Practical experience with Delta Lake, file formats (Parquet), and working with Cloud Storage (AWS S3 / Azure ADLS).
- Modeling: Proven experience in designing Fact and Dimension tables.
Advantages (Nice to Have)
- Experience with Delta Live Tables (DLT) or dbt (Data Build Tool) on Databricks or Snowflake.
- Familiarity with MLOps concepts and MLflow.
- Official AWS, Snowflake, or Databricks Certifications.
- Experience with external orchestration tools (e.g., Apache Airflow).
Soft Skills
- Ability to work independently and lead tasks end-to-end in an Agile environment.
- Strong troubleshooting skills for complex, distributed processes and database bottlenecks.
- Excellent communication skills and the ability to collaborate with various stakeholders (Analysts, Product Managers, and Data Scientists).
AllCloud is an Equal Opportunity Employer and considers applicants for employment without regard to race, color, religion, sex, orientation, national origin, age, disability, genetics or any other basis forbidden under federal, provincial, or local law.
Company at a glance
AllCloud is a global professional services company providing organizations with the tools for cloud enablement and transformation. Through a unique combination of expertise and agility, AllCloud accelerates cloud innovation and helps organizations fully unlock the value received from cloud technology and data and analytics.
As an AWS Premier Consulting Partner, a Salesforce Platinum Partner and Snowflake Premier Partner, AllCloud helps clients connect their front office and back office by building a new operating model that allows them to harness the benefits of cloud technology and data and analytics. AllCloud is supported by a robust ecosystem of technology partners, proven methodologies, and well-documented best practices. Thereby elevating customers by achieving operational excellence on the cloud, within a secure environment, at every milestone of the journey to becoming cloud first.
With years of experience and a portfolio of thousands of successful cloud deployments, AllCloud serves clients across the globe. AllCloud has offices in Israel, Europe and North America. https://allcloud.io/
Tired of cold applications?
Sign up with Clera and we'll reach out the moment a role actually fits you — no more spraying applications into the void.
Know someone who'd be great for this?