Julian Rocci
Analytics Engineer / Data Engineer | SnowPro Core Certified ❄️ Snowflake & dbt | Data Governance & FinOps | Switzerland 🇨🇭
Analytics Engineer (Snowflake & dbt Focus) at Consulting & Independent Projects
Activity
Loading activity...
Career: 5
Analytics Engineer (Snowflake & dbt Focus)
Consulting & Independent Projects
Jan 2026 - Present
Analytics Engineer (Snowflake & dbt Focus)
Consulting & Independent Projects
• 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
Language Student
Seoul National University
Beginner+ / Intermediate Korean Language
Data Engineer (Luxury & Cosmetics Customer)
IBM
Jan 2023 - May 2025
Data Engineer (Luxury & Cosmetics Customer)
IBM
• 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
Software Developer (Banking & Finance Customer)
IBM
• 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
Intern Developer
Cozy'Air
Education: 3
Seoul National University
Education
May 2025 - Jan 2026
Seoul National University
Education
Beginner+ / Intermediate Korean Language
Global Knowledge
Education
2018
Global Knowledge
Education
.Net / C# Training
Popschool Valenciennes
Education
2017
Popschool Valenciennes
Education
Credentials: 1
Snowflake
Projects: 1
Snowflake Governance-Hub
Jan 2026 - Present
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