Company Name: AllCloud

Job Details: Hiring,Remotely,in,New,York,,NY,In-Office,or,Remote,Junior

Job Url: https://builtin.com/job/data-engineer/8284295

Job Description: Data Engineer Location: US / Canada (Eastern Time) - Home basedJob Type: Full-time, Permanent About AllCloudAllCloud is a global professional services company providing organizations with 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 and audited MSP, 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. 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 AmericaJob SummaryAre you passionate about data and delivering solutions for clients that turn data into valuable, actionable information for their business? We are hiring Data Engineers with strong experience across the entire Cloud Data stack. The ideal candidate will have extensive experience in data pipelines (ELT/ETL), data replication, data warehousing and dimensional modeling, and curation of data sets for Data Scientists and Business Intelligence users. This candidate will also have excellent problem-solving ability dealing with large volumes of data.How You'll Make Your Mark:Building scalable Cloud data solutions using MPP Data Warehouses (Snowflake, Redshift, or Azure Data Warehouse/Synapse), data storage (S3, Azure Blob Storage, Delta Lakes, or AWS Lake Formation) and analytics platforms (i.e. Spark, Databricks, etc.)Creation of data pipelines and transformationsKnowledge of ETL tools such as– Matillion, FiveTran, Informatica, Talend, SSIS, etc.Transformations – dbtExperience with elastic/open searchLoad historical data to a data warehouseScripting in Python, Java Script or ShellWorkflow Orchestrations using Apache Airflow, AWS Step Functions, etc.Familiarity with automated promotions, SCM tools, and CICD best practicesModeling and curation of data for visualization and predictive modeling usersDesign and implementation of AWS and/or Azure services such as Lambda, SNS, etc.Creating data integrations with scripting languages such as PythonWriting complex SQL queries, stored procedures, etc.Summary of Requirements & ExperienceBachelor’s degree, or equivalent experience, in Computer Science, Engineering, Mathematics or a related field. Commensurate work experience will be considered in lieu of degree2+ years’ experience building scalable Cloud data solutions using MPP Data Warehouses (Snowflake, Redshift, or Azure Data Warehouse/Synapse), data storage (S3, Azure Blob Storage, Delta Lakes, or AWS Lake Formation) and analytics platforms (i.e. Spark, Databricks, etc.)3+ years with complex SQL queries and scripting3+ years’ experience building data pipelines via Python, Spark, or GUI Based tools3+ years’ experience loading historical data to data warehouses3+ years’ experience with AWS and/or Azure Cloud3+ years developing, and deploying scalable enterprise data solutions (Enterprise Data Warehouses, Data Marts, ETL/ELT workloads, etc.)3+ years of supporting business intelligence and analytic projects2+ years’ DevOps experience2+ years’ experience working in an environment with automated promotions to productionFamiliar with ETL/ELT patterns and methodologies.Good understanding of code repositories such as GITExcellent written and oral communication skillsPlusesExperience with a Business Intelligence tool such as Tableau, PowerBI, Sigma, etc.Experience working at a consulting companyExperience with Data Vault architectureMatillion Associate CertificationSnowflake SnowProAWS Data & Analytics SpecialtyAWS Database SpecialtyAWS Solutions Architect AssociateAWS Developer AssociateAWS GlueWhy 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.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.