Join the Revolution

Why take a job when you can grow your career?

We’re expanding globally and always looking for talented, exceptional employees to add to our expertise. Browse and apply for one of our many open positions below and embark on your professional journey. Learn more about life at AllCloud.

Analytics Engineer, dbt

United States · Full-time · Intermediate

About The Position

AllCloud is a global professional services company providing organizations with tools for cloud enablement and transformation. As an AWS Premier Consulting Partner and an official AWS Authorized Training Partner (ATP)., AllCloud helps clients connect their front office and back office by building a new operating model that allows them to harness the benefits of both Salesforce and AWS. With over 12 years of experience and a portfolio with thousands of successful cloud deployments, AllCloud serves clients across the globe. AllCloud has offices in Israel, Europe, and North America. 

About The Position

Are you passionate about data and delivering solutions for clients that turn data into valuable, actionable information for their business?

We’re hiring an Analytics Engineer with strong experience delivering analytics and insights from data, leveraging Cloud tools and modern ETL/ELT techniques. The ideal candidate will have extensive experience in developing data models to support the deployment and evolution of data warehouses based on standard methodologies. This candidate would be proficient in writing highly efficient transformations using SQL, and comfortable with standard version control and code promotion practices using git, experience with transformation tools, dbt. Experience with modern cloud data warehouses (such as Snowflake) would be highly desirable. Excellent problem-solving ability dealing with large volumes of data will round out the ideal candidate.

How You'll Make Your Mark:

  • Work with cross-functional teams to research, develop and deliver data solutions, from concept to design and implementation
  • Actively participate in data and metrics requirements gathering process with business stakeholders, SMEs and end users
  • Actively contribute to development of data warehouses and data marts
  • Actively contribute to and collaborate with Data Modelers in designing data models
  • Transformation and curation of data using complex SQL queries, stored procedures, macros, etc.
  • Support BI Developers and Data Scientists in analyzing complex data sets to uncover insights and provide recommendation.
  • Support data preparation and curation for ingestion into ML models


  • Bachelor’s degree, or equivalent experience, in Computer Science, Data Science, Mathematics or a related field. Commensurate work experience will be considered in lieu of degree
  • Experience supporting scalable Cloud data solutions using MPP Data Warehouses (Snowflake, Redshift, or Azure Synapse), data storage (AWS S3 or Azure Blob Storage) and analytics platforms (i.e. Spark, Databricks, etc.)
  • Demonstrated ability to communicate data insights and model results in business terms and articulate business value
  • Demonstrated ability to work with any variety of data for the purpose of retrieval, movement, transformation and storage
  • Experience with dbt is a must have.
  • 3+ years developing and deploying scalable data warehouse/data marts by incorporating standard methodologies such as Dimensional modeling and DataVault 2.0.
  • 3+ years supporting needs of Business Intelligence teams that use Tableau, PowerBI, Sigma, or similar tools
  • 3+ years working with any relational or non-relational data platform(s)
  • 3+ years working with business SME’s and end-users to understand and document their needs
  • 1+ years supporting data preparation and ingestion for ML models


  • Experience with Snowflake
  • Experience working at a consulting company
  • Data visualization tools like Tableau, Looker, PowerBI

Why Work For Us?

Our team inspires progress in each other and in our customers through our relentless pursuit of excellence; you will work with leaders who promote learning and personal development. We offer competitive salaries, bonus incentives, benefits, flexible hours, and mentoring. Apply now to become part of the team.


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.

Apply for this position

Copyright 2021 | AllCloud | All Rights Reserved

John Hanchak

John Hanchak joined AllCloud in 2021 and is responsible for the talent strategy across the company.  As Chief People Officer, John leads the global Employee Success (ES) team and is responsible for leading all ES functions worldwide, including talent acquisition and management, compensation, ES operations, and employee experience and engagement.

He has over 20 years of experience with high-growth technology companies, leading talent acquisition within both large global brands and start-up organizations. In previous positions, John worked as the leader in Talent Acquisition at Egnyte, Hitachi Vantara, Jive Software, Achievers, and inCode Wireless. He has spent his career focused on talent strategies to ensure maximum business growth and the best employment experience.