Skip to main content
RS
Looking for a job

Roni Sheffi

@ronisheffi

Analytics Engineer at vcita building Snowflake ELT pipelines and consolidated payments models.

Spain
Message

At vcita, I own end-to-end data processes, from ingestion and transformation through data modeling and analytics. I build production ELT pipelines in Rivery, with incremental SQL transformations in Snowflake.

I designed consolidated payments models across invoices, POS, services, meetings, and events, defining consistent business logic and dimensional structures. I also develop the Git-versioned LookML semantic layer and Looker dashboards for product usage and business performance analysis.

At Medatech, I wrote complex T-SQL queries and reports and customized Priority ERP processes and reporting for clients. I progressed from a student position to leading client projects and coordinating development tasks across a team of five.

For my Payments Analytics Engineering project, I built a layered dbt project on BigQuery with staging, intermediate, and analytical mart models. I defined payment-request and entity grain, then added schema tests and custom SQL assertions to check business rules.

Experience

Work history, roles, and key accomplishments

ME

SQL Developer & System Analyst

Medatech

Aug 2017 - Jan 2023 (5 years 5 months)

Progressed from a student position to leading client projects, coordinating development tasks across a team of five. Wrote complex T-SQL queries and customized Priority ERP business processes.

Education

Degrees, certifications, and relevant coursework

Technion – Israel Institute of Technology logoTT

Technion – Israel Institute of Technology

Certified Big Data Analyst, Data Analytics

2022 - 2022

Certified Big Data Analyst Course covering data warehousing and ETL/ELT.

Technion – Israel Institute of Technology logoTT

Technion – Israel Institute of Technology

B.Sc., Industrial Engineering

2014 - 2018

B.Sc. in Industrial Engineering with a specialization in Information Systems.

Interested in hiring Roni?

You can contact Roni and 600K+ other talented remote workers on Himalayas.

Message Roni

People also viewed

View all talent

Get matched with your dream remote job

Sign up now and join over 1,000,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!

Sign up
Himalayas profile for an example user named Frankie Sullivan