Data & Analytics Consultancy · Guatemala

One definition of every metric. Everywhere.

Somnium builds the layer between your warehouse and your business — governed semantic models, tested dbt pipelines, and data foundations that AI applications can actually be trusted to query.

Services

Four problems we solve

Most analytics problems are not dashboard problems. They are definition problems, and they get solved upstream.

Semantic layer & metric governance

One versioned definition per metric, with lineage back to the models, served through a single API to BI tools, notebooks and AI agents. Built in Cube.dev, dbt Semantic Layer or LookML.

Analytics platform on dbt

Layered bronze / silver / gold architecture on Snowflake, Redshift or BigQuery, with automated data quality testing, freshness monitoring and CI/CD so nothing reaches production untested.

BI consolidation & migration

Fragmented reporting stacks turned into standardized, reusable data products. Superset, Preset, Looker, Power BI and Tableau — including moving metric logic out of dashboards and into the model.

AI-ready data foundations

Retrieval over embedded stores, MCP servers giving models governed warehouse access, and the semantic contract underneath — so an LLM answers a business question correctly, not just plausibly.

Track record

A recent platform, in numbers

Built and owned end to end for a US client over two years. Figures are aggregate; client details stay confidential.

68dbt models across bronze, silver and gold
~1,090automated data quality tests on every deploy
584Mrows across 1,365 source tables
−90%cross-domain reporting inconsistencies
How we work

Straightforward to engage

Foreign B2B provider

Registered consultancy operating in Guatemala since 2015, with electronic invoicing and W-8BEN. No entity to set up, no payroll to run, no EOR in the middle.

A time zone that never moves

Guatemala is GMT-6 year-round with no daylight saving. Full-day overlap with US hours that stays the same in January and in July.

Delivery, not headcount

Scoped engagements with defined milestones, or ongoing capacity for consultancies that win more implementation work than they want to staff internally.

Stack

What we build with

dbtCube.devSnowflake RedshiftBigQuerySQL PythonAirbyteGitHub Actions Superset / PresetLooker & LookML Power BITableauAWS GCPAzureMCP servers LLM integration
Contact

Tell us what is not adding up

If three teams report three different numbers for the same thing, that is a conversation worth having. No sales process — just a conversation.

Based in
Guatemala City · GMT-6
WhatsApp
Working with
Clients across the Americas and Europe