Skip to main content

AI-ready data foundations

Decisions are only as fast as the data behind them. I help you define the metrics that matter and build the right data foundation for your scale, so your team finds answers they can trust.

About

I’m Julia Shem. Principal Analytics Engineer with 10+ years architecting data platforms, semantic layers, and metric frameworks that drive executive decisions, building AI-ready self-service analytics on a standardized, trustworthy data foundation.

Most of my work is rebuilding broken data foundations, usually a migration off legacy BI, sometimes a fresh build + AI-readiness. The destination is a modern, AI-ready stack, sized for your scale: dbt + Snowflake + Fivetran + Omni at the high end, leaner alternatives for earlier-stage brands. The before-state is usually fragmented data, dashboards stakeholders don’t trust. The after-state is a scalable, trustworthy foundation with models and metrics everyone can make decisions off plus a governed semantic layer that is the trusted source of truth, queried by teams and AI agents.

LinkedIn

A complete modern data stack

from raw data to trusted decisions.

Metric Definition & Stakeholder Alignment

Defining the metrics that matter — cohort retention, LTV, conversion, health outcomes — and getting them agreed-on across stakeholders. The hardest part of the job, and the one a clean stack is meant to deliver on.

Modern Data Architecture

Snowflake warehouses provisioned to scale with your growth — one platform for all your data, no silos to maintain.

Data Centralization with Fivetran

Centralized data from your operational tools — payments, e-commerce, CRM, marketing — into Snowflake using Fivetran. Everything in one place, ready to model.

Data Modeling with DBT

Fast, well-documented dbt models your team can extend. Or migration and cleanup of an existing dbt project that’s grown into spaghetti.

Modern BI implementation (dbt + semantic layer)

Legacy BI (Tableau, Looker, Mode) migrated to a modern, AI-ready stack — dbt + a semantic layer like Omni. Reports are fast, metrics stay consistent, and your data is ready for AI.

Ready to take the next step?