# Julian Rocci (@julianrocci.bsky.social)

Profile: https://sifa.id/p/julianrocci.bsky.social
Headline: Analytics Engineer / Data Engineer | SnowPro Core Certified ❄️ Snowflake & dbt | Data Governance & FinOps | Switzerland 🇨🇭

## About

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

## Experience

- **Analytics Engineer (Snowflake & dbt Focus) at Consulting & Independent Projects** (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 at Seoul National University** (2025 – 2025)
  Beginner+ / Intermediate Korean Language
- **Data Engineer (Luxury & Cosmetics Customer) at IBM** (2023 – 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) at IBM** (2018 – 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 at Cozy'Air** (2017 – 2017)

## Education

- **Seoul National University** (2025 – 2026)
- **Global Knowledge** (2018 – 2018)
- **Popschool Valenciennes** (2017 – 2017)

## Skills

- Data Modeling
- FinOps
- Data Governance
- DCM ( Database Change management)
- Data Build Tool (DBT)
- Data Engineering
- Incremental Data Processing
- CDC
- Query Optimization
- Pruning
- Role-Based Access Control (RBAC)
- Extract, Transform, Load (ETL)
- Korean
- Amazon Web Services (AWS)
- ESQL
- Snowflake
- GraphQL
- SQL
- Software Development
- PostgreSQL
- Elasticsearch
- IBM API Connect
- Openshift
- API REST
- API Postman
- IBM Tivoli
- App Connect Enterprise
- IBM Cloud
- Apache Kafka
- IBM MQ
- JavaScript
- Netcool
- Git
- Oracle SQL Developer

## Certifications

- SnowPro Core — Snowflake (https://achieve.snowflake.com/420e4442-b1ad-4c54-a09d-5ab46a189a78#acc.8X0OxglZ)

## Projects

- **Snowflake Governance-Hub**
  ●	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

- French (native)
- English (full_professional)
- Korean (limited_working)