Senior Data Engineer (Automated restaurant system) in Sigma Software

Weare looking for aSenior Data Engineer who will beworking with various workstreams, from anAutomation (Robotics) Control System toaSupply Chain &Inventory Management System, and uptoacustomer-facing, next-generation ordering platform. You will join amultidisciplinary team comprising Chefs, Marketers, UXDesigners, Fabricators, and Logistics Experts all working for aUS-based company.Sounds interesting, doesn’t it? Keep reading!ProjectWeare building anew model for sustainable and equitable restaurants bringing environmental and social justice tothe fast food world. The project isahighly automated restaurant and cooking line system.This new restaurant concept isbased onhigh-quality vegetable-based food, single-piece flow (nobatch production), and ahighly optimized supply system. These principles are inplace toattain our goal tooutput aslittle carbon aspossible.ResponsibilitiesDesign, develop, and maintain ETL pipelines using Azure Data Factory, ensuring efficient data flow and transformationUtilize Databricks for data processing tasks, leveraging PySpark for advanced data manipulation and analysisDevelop and optimize ETL processes within Azure Synapse Analytics, focusing onperformance and scalabilityApply expertise inMSSQL Server for data modeling, implementing stored procedures and analytical views tosupport business requirementsCreate visually appealing and insightful reports using Microsoft PowerBI, enabling stakeholders toderive actionable insights from the dataRequirementsAtleast 5years ofprofessional experience indata engineeringAdvanced experience with enterprise Data Warehouse modelingExperience with Complex ETL process implementationExperience with Power BIData Modeling and Reporting (DAX, Power Query, Dashboards Design)Experience with SQL Development (both MSSQL and Oracle)Solid experience with Azure Synapse/Data Factory Pipelines, Azure Notebooks/DatabricksFamiliarity with Cloud stack technology (AWS, Airflow)Deep understanding ofSAP BW/HANA Modeling, SAP ECC/S4 Corporate Data ExtractionExperience with PySpark Data ProcessingExperience with CI/CDAtleast Upper— Intermediate level ofwritten and spoken EnglishМишукаємо Senior Data Engineer, який працюватиме зрізними робочими напрямами: від систем управління автоматизацією (робототехніка) досистем управління ланцюгом постачання таінвентаризації, атакож зклієнтоорієнтованою платформою замовлень наступного покоління. Типриєднаєшся домультидисциплінарної команди, доскладу якої входять шеф-кухарі, маркетологи, UX-дизайнери, виробники таексперти злогістики, які працюють вамериканської компанії.Звучить цікаво, чинетак? Читай далі!ПроектМибудуємо нову модель сталого тачесного ресторану, яка принесе екологічну тасоціальну справедливість усвіт фаст-фуду. Проєкт являє собою високоавтоматизовану систему ресторанів такухонних ліній.Цянова концепція ресторану базується нависокоякісних продуктах харчування нарослинній основі, безперервному потоці (без серійного виробництва) тависокооптимізованій системі постачання. Ціпринципи застосовуються для досягнення нашої мети— мінімізувати викиди вуглекислого газу.Обов’язкиПроєктувати, розробляти тапідтримувати конвеєри ETL задопомогою Azure Data Factory, забезпachieving efficient data flow and transformation Use Databricks for data processing tasks using PySpark for advanced data manipulation and analysis Develop and optimize ETL processes within Azure Synapse Analytics with a focus on performance and scalability Apply knowledge of MSSQL Server to data modeling, implementation of stored procedures and analytical views to support business requirements Create visually appealing and meaningful reports with the help of Microsoft PowerBI, allowing interested parties to receive practical conclusions from the passed Requirements At least 5 years of professional experience in the field of data engineering In-depth experience in modeling corporate data warehouses Experience in implementing complex ETL processes Experience in data modeling and PowerBI reporting (DAX, Power Query, Dashboards Design) Experience in SQL development (both MSSQL and Oracle )Significant experience working with Azure Synapse/Data Factory Pipelines, Azure Notebooks/Databricks Knowledge of cloud stack technology (AWS, Airflow) Deep understanding of SAP BW/HANA modeling, SAP ECC/S4 Corporate Data Extraction Experience working with PySpark data processing Experience working with CI/CD Level of written and spoken English languages ​​not lower than Upper — Intermediate