23.06.2026 aktualisiert

**** ******** ****
Premiumkunde
100 % verfügbar

Senior Enterprise & Information Architect | BI, AI & Data Engineering

Berlin, Deutschland
Weltweit
MBA Business, Coleman University Israel (2008-2010)
Berlin, Deutschland
Weltweit
MBA Business, Coleman University Israel (2008-2010)

Profilanlagen

_Ran Oren 26ma.docx.pdf

Über mich

Senior Enterprise & Information Architect with over 9 years of experience specializing in BI, AI applications, and modern data warehousing, particularly within complex ERP and large-scale enterprise data environments. Azure Architect Synapse / Fabric, DataBricks, Spark modeling, SQL and Python.

Skills

Azure FunctionsdbtSql Data WarehouseBig DataGoogle BigQueryData IntegrationData TransformationData VaultData WarehousingAzure SQLAzure Data LakeAzure AutomationAzure Data FactoryMicrosoft Fabric (Analytics-Plattform)Azure Data AnalyticsAzure Synapse AnalyticsDaten-PipelineDatabricks
Cloud Data Platform Architecture (Azure, Snowflake, Google BigQuery)
Expertise in designing and implementing high-performance cloud data platforms using Azure DataBricks, Microsoft Fabric, Snowflake, and Google BigQuery. End-to-end architecture of Lakehouse environments including DirectLake and OneLake within the Microsoft Fabric ecosystem for scalable enterprise reporting and advanced analytics.

Data Engineering & ETL/ELT Pipeline Development
Extensive experience developing and deploying complex ETL/ELT data pipelines using tools such as DBT, Apache HIVE/Sqoop, Microsoft SSIS, Apache Airflow, and Spark/Python (ADF). Design and implementation of Data Vault 2.0 models for ERP and operational data sources ensuring flexible and traceable data foundations.

Generative AI & Machine Learning Applications
Hands-on experience with Azure AI Services, Azure AI Search, CosmosDB, and RAG Langchain for building AI-powered solutions. Implementation of generative AI workflows, embedding lifecycle automation, RAG-based assistants, and multi-agent systems integrating Computer Vision, NLP, and Predictive Analytics.

Business Intelligence & Data Analytics
Proficiency in MS Power BI (certified), Google Looker Studio, Adobe Analytics, and Spark & Jupyter Notebooks for building dashboards, reports, and analytical solutions across industrial, financial, and telecommunication sectors.

Programming Languages (SQL, Python, DBT-Jinja)
Strong command of SQL, Python with libraries such as Pandas, NumPy, Matplotlib, sciKit, and pySpark, as well as DBT-Jinja for data transformation and pipeline development.

Data Vault 2.0 & DWH Modelling
Certified Data Vault 2.0 Practitioner with experience designing and implementing data warehouse models for ERP and enterprise data sources, ensuring traceable and trusted data foundations.

Project & Version Control Tools
Practical use of Jira for agile project management and GitHub for version control and collaborative development in data engineering and BI projects.

API Development & Integration
Experience with PostMan for API development and testing, as well as building Python API connectors and OAuth integrations for source system data extraction.

Elastic Search & Search Optimization
Design and optimization of product search capabilities using Elastic Search, enabling high-performance full-text and semantic search solutions within enterprise data environments.

Erfahrung

Berufserfahrungmehr als 10 Jahre
Freelancer seit2023

Sprachen

DeutschverhandlungssicherEnglischMuttersprache

Projekthistorie

Freelance Data & AI Architect - Community Management Intelligence & Process Automation

Freelance
Built an automated ingestion pipeline to retrieve and index community data (Meta/Facebook API) into a vector database enabling a RAG-based assistant. Developed a data analysis engine processing unstructured community interactions to extract real-time sentiment scores and engagement trends. Integrated AI assistant with Slack/Teams to automate routine responses and moderate content, reducing manual community management workload by 40%.

Freelance Data & AI Architect - AI-Powered HR Workflow & Document Automation

Freelance
Designed an HR Co-Pilot using Azure OpenAI and Azure AI Search for policy-backed personalized answers from unstructured documents. Implemented generative AI workflows to automate creation of job descriptions, offer letters, and performance review drafts, reducing HR administrative time by 50%. Built a multi-step automation using Azure Logic Apps and AI agents to orchestrate end-to-end onboarding processes including document verification, system access provisioning, and training schedule generation.

Freelance Data & AI Architect - Multi-Modal AI Shopping Assistant & Cost Optimizer

Freelance
Designed a multi-agent system integrating Computer Vision, NLP, and Predictive Analytics to optimize household grocery spending. Developed an invoice recognition pipeline using OCR/Vision Transformer to digitize historical purchase data. Built a semantic search engine using vector embeddings to map shopping list items to standardized product catalogs with >90% accuracy. Deployed a RAG-based LLM agent for conversational shopping assistance. Tech stack: Python, LangChain, Vector Databases (Pinecone/Milvus), Computer Vision (OpenCV/YOLO), LLMs (OpenAI/Llama).

Azure Data Architect, Data Engineering

Cosmo Consult GmbH
Architected and owned the end-to-end strategy for a high-performance Azure DataBricks data platform. Leveraged Azure AI Studio and Databricks to automate the lifecycle of embeddings and model retraining. Led the architectural design and implementation of Lakehouse architectures (DirectLake, OneLake) within the Microsoft Fabric ecosystem. Developed and deployed complex Microsoft Fabric implementations and scalable ETL/ELT data pipelines (ADF, Spark/Python) for high-volume data ingestion and transformation of ERP and operational data sources.

Data Engineering, Snowflake DWH Architect

Nextview Consulting GmbH
Backend architecture of Microsoft Fabric based data warehouse including staging from Salesforce to Azure datalake, internal staging logic via Python oAuth API, and credit/bandwidth cost management with Cortex models. Python and Jinja development of pipeline tools, source extraction API connector development, and data node development in Coalesce.IO. Deployed and developed Airflow data warehouse orchestration in Python. Designed Data Vault data models for ERP data sources.

Senior Management Information Delivery Consultant

Scalefree International GmbH
Championed and deployed metadata-driven architectures to automate and standardize data pipelines, semantic model generation, and enterprise governance workflows. Architected a revenue and contribution margin dashboard on a Google BigQuery DWH using Data Vault modeling and dbt. Ensured secure, governed, and high-performing data solutions through seamless integration with Microsoft Purview for comprehensive data lineage and classification across marketing (IFS ERP, Salesforce) and web/mobile web events data. Designed and connected marketing information to build a user journey model for Churn, high-value clients, and retention lists.

Data Science Product Manager

EKOR Tech GmbH
Managed data research developing machine learning models for similarity purposes and supervised modeling using Python Spark processing. Optimized and designed product search capabilities with Elastic Search. Agile designed robust data pipelines with BigQuery mapping and metadata conversion. Documented data lineage traceability using wiki data dictionary. Modeled rich data APIs enabling real-time reporting with pySpark streaming in Azure. Deployed a real-time data model with Python and cache tables of real-time random forests pre-calculated model.

Risk Management Data Analysis

RSA Security LTD.
Established a new analytical service for UK financial institutes delivering AML/KYC fraud analysis results and policy management. Data mining large datasets and defining new KPIs with Azure DB, increasing fraud prevention and report automation using Tableau on Oracle DWH. Agile Product management developing data-driven product self-servicing client analytics and policy generation using Azure Data Factory, pySpark ETL tools, and PowerBI dashboarding. Modeled IP Geolocation visual graph (Neo4J) based solution for clients visualization.

DWH & BI Developer in Banking Industry, E-Commerce, Telco

Eternity IT LTD.
Developed data mart models projects based with DB2 plSQL. Designed documents architecture, data flow, use case and user journey diagrams. SSIS ETL developer for DWH Modeling, ETL development, defining data pipelines, and Data QA. BI, Reporting & Dashboards with SSRS as developer and project management.

Kontaktanfrage

Einloggen & anfragen.

Das Kontaktformular ist nur für eingeloggte Nutzer verfügbar.

RegistrierenAnmelden