Skip to main content

Analytics Engineer / Data Engineer | SnowPro Core Certified ❄️ Snowflake & dbt | Data Governance & FinOps | Switzerland 🇨🇭

Analytics Engineer (Snowflake & dbt Focus) at Consulting & Independent Projects

Report

If you are scaling your Data Stack on Snowflake and dbt, I ensure your data platform is performant, cost-efficient, and secure.I specialize in warehouse optimization, efficient clustering, QAS/SOS, and enforcing data governance through masking policies. I manage end-to-end data quality, automated testing, comprehensive documentation, and proactive platform auditing. I transform raw layers into clean, production-ready dimensional models to deliver reliable data to downstream BI teams.Backed by a solid Data Engineering background in event-driven architectures (IBM ACE, IBM MQ, Kafka, APIConnect, APIs), I now fully specialize in the Snowflake & dbt stack as an Analytics Engineer.SnowPro Core Certified ❄️, focusing on building scalable, cost-efficient data architectures. I bring a strong focus on data quality, cost optimization (FinOps), and performance tuning. Oriented on Data Vault & Kimball modeling.Technical Focus -> Snowflake & dbt Expertise:• ELT Pipelines: Snowpipe, Streams & Tasks, Dynamic Tables, Serverless features.• Performance & Optimization: Query tuning, partition pruning, warehouse right-sizing.• Data Handling: Semi-structured data (JSON/VARIANT), Iceberg, AWS S3.• Analytics Engineering: Data modeling and transformation with dbt.• Data Governance: Testing, Documentation and automated lineage enforcement with dbt.• FinOps: Detailed monitoring of global costs and warehouse efficiency.• Methodology: DCM, IaC, and idempotent data processing patterns.I’m seeking a Analytics Engineer role with a heavy focus on Snowflake and dbt, ideally one that brings real challenges and pushes me beyond what I already know. No comfort zones, more learning and room for improvement !Eligible for Swiss Work Permit (EU Citizen)

  • Open to relocationSnowflake Data Cloud | Analytics Engineering | dbt Core | FinOps & Cost Optimization | Data Governance & Quality | Event-Driven Architecture | ELT/ETL Pipelines

Activity

Loading activity...

View full activity

Career: 5

Analytics Engineer (Snowflake & dbt Focus)

Consulting & Independent Projects

Jan 2026 - Present

• Data Vault & Kimball with dbt • ELT pipelines (Snowpipe, Streams + Tasks, DT, Serverless) • Query optimization (partition pruning, warehouse sizing) • Security + governance (RBAC with Streamlit, masking policies, row access policies, secure views) • Core platform features (Time Travel, Fail-safe, zero-copy cloning) • Incremental and idempotent data processing patterns • Semi-structured data handling (JSON, VARIANT) • Cloud data foundations (AWS S3, Iceberg basics) • Detailed monitoring of global cost • DCM & IaC

Language Student

Seoul National University

May 2025 - Dec 2025

Beginner+ / Intermediate Korean Language

Data Engineer (Luxury & Cosmetics Customer)

IBM

Jan 2023 - May 2025

• Built APIs, developed new workflows, and improved existing pipelines for CRM, Retail, Loyalty, E-commerce, and Zendesk systems in a customer facing environment. • Engaged in meetings, giving feedback and proposing enhancements to optimize overall system architecture / current pipelines • Designed dashboards and monitoring tools, enabling real‑time visibility and data-driven decisions. • Supported international partners and delivered POCs for onboarding and functional validation. • Acted as Lead Developer, providing guidance/mentoring team members, code reviews, and development process optimization to support and elevate the team / enhancing team efficiency and code quality

Software Developer (Banking & Finance Customer)

IBM

Jun 2018 - Dec 2022

• Re-develop from scratch the existing tool (Netcool suite). • Developed every step of the life of an alert ( Probe, Retention, Correlation, Ticketing, etc..). • Integrated new side tools such as ServiceNow, Apigee, Ansible tower ( for automatic ticket resolution). • Migrated every type of alerts to the new built tool / integrated new type of alerts. • Interacted with Business partners to handle their needs. • Created a strong documentation. Worked on every aspect of the system whether it was Ticketing or Correlation or probes. • Was also responsible for the WebGUI interface based on the needs of the supports teams. • Managed the git side of the project, document every aspects of the delivery part. • Later I took the lead of the implementation of our new ticketing system ServiceNow, from APIs calls to tracing every step of a life of a ticket. • Collaborated with the Ansible team to implement automatic ticket resolution on specific problems. Also lead the new implementation of Dynatrace alerting into our tool.

Intern Developer

Cozy'Air

Jun 2017 - Jul 2017

Education: 3

Seoul National University

Education

May 2025 - Jan 2026

Beginner+ / Intermediate Korean Language

Global Knowledge

Education

2018

.Net / C# Training

Popschool Valenciennes

Education

2017

Credentials: 1

SnowPro Core

Snowflake

May 2026

Projects: 1

Snowflake Governance-Hub

Jan 2026 - Present

● Building a comprehensive governance monitoring framework using Snowflake and dbt ● Big focus on dbt models covering Data Quality, Cost Optimization and Performance Tuning ● Developed automated infrastructure delivery via Snowflake DCM and GitHub Actions ● Built automated data quality checks and governance-ready metrics to ensure platform reliability ● Leveraging Account_usage and Query Profile for in-depth platform health monitoring ● Built a Streamlit application for centralized user management (RBAC) and security auditing

Languages: 3

French(Native or bilingual)
English(Full professional)
Korean(Limited working)

Skills: 34

Technical

Amazon Web Services (AWS)Apache KafkaData Build Tool (DBT)Data EngineeringData GovernanceElasticsearchExtract, Transform, Load (ETL)Git
GraphQLJavaScriptPostgreSQLSoftware DevelopmentSQL

Other

API PostmanAPI RESTApp Connect EnterpriseCDCData ModelingDCM ( Database Change management)ESQLFinOps
IBM API ConnectIBM CloudIBM MQIBM TivoliIncremental Data ProcessingKoreanNetcoolOpenshiftOracle SQL DeveloperPruningQuery OptimizationRole-Based Access Control (RBAC)Snowflake

Also find Julian Rocci on…