A large data centre hall with long rows of server racks lit by blue and green status lights
    Big data consulting

    Big data consulting: platform assessment and roadmap

    Teams are often told they need a big data platform before anyone has checked whether their data needs one. Agnotic Technologies sizes your workload, reviews what you already run, and gives you a platform decision and an implementation plan that starts with one use case.

    Platform sizingCluster and lake reviewDecision recordPhased roadmap

    Trusted by global innovators

    Benchmark
    Chibasco
    Fundency
    Lantimer
    Lauren
    Lera
    One Minute
    Pento Pix
    TAP
    Xtrium
    Healthevolve
    Benchmark
    Chibasco
    Fundency
    Lantimer
    Lauren
    Lera
    One Minute
    Pento Pix
    TAP
    Xtrium
    Healthevolve
    Benchmark
    Chibasco
    Fundency
    Lantimer
    Lauren
    Lera
    One Minute
    Pento Pix
    TAP
    Xtrium
    Healthevolve
    Benchmark
    Chibasco
    Fundency
    Lantimer
    Lauren
    Lera
    One Minute
    Pento Pix
    TAP
    Xtrium
    Healthevolve

    Big data consulting

    What is big data consulting?

    Big data consulting is deciding whether your data needs a distributed platform and, if it does, which one to build and in what order. Agnotic Technologies sizes your volume, arrival rate, formats and query patterns, reviews any cluster or lake you already run, then writes the platform decision and a phased roadmap.

    Many teams that ask for a big data platform need a well-tuned database or a cloud warehouse instead. We say so when that is the answer, because a smaller platform costs less to run and is easier to staff.

    When a distributed platform is the answer, the engine detail lives on its own pages: Apache Spark for batch processing, Apache Kafka for event streams and Apache Cassandra for high-write operational data. This page covers the decision and the plan.

    Platform sizing table

    Does your data need a distributed platform?

    Start with the smallest platform that meets each trait, and move up only when the signal in the last column appears. The answer is per workload, not per company.

    Workload traitSmallest platform that usually meets itSignal that the next tier is needed
    Data volumeOne relational database, such as PostgreSQL, with partitioned tables and the right indexesReports still slow the application after partitioning and indexing, or backups no longer finish in their window
    Arrival rateScheduled batch loads into a cloud warehouseLoads overrun their schedule, or the business needs data within minutes instead of the next morning
    Variety of formatsA cloud warehouse with semi-structured column types for JSONImages, documents, logs or sensor files must be kept raw and processed with code, not SQL alone
    Query concurrencyA cloud warehouse with separate compute for dashboardsMany teams and tools query the same data and each needs its own compute over one shared copy
    Freshness needHourly or daily batchDecisions or product features depend on events seconds old, which calls for a streaming platform
    Processing shapeSQL transformations inside the warehouseJobs need custom code, model features or joins too large for one machine, which points to a lakehouse with a distributed engine

    When a row lands on streaming, the design continues on our real-time data warehouse page. The storage choice between warehouse, lake and lakehouse is set out on our comparison page.

    Platform assessment

    What do we check in an existing cluster or data lake?

    For teams that already run Hadoop, Spark, a data lake or a warehouse that grew without a plan. Each check ends in a keep, fix or retire decision.

    01

    What is used

    Example: Hundreds of tables and jobs, and nobody sure which still feed a report

    Approach: We read query and job history to list the tables, jobs and dashboards that actually ran in recent months, and mark the rest for archive or removal.

    02

    What it costs

    Example: A bill that keeps growing while usage looks flat

    Approach: We split spend by cluster, job, storage tier and team, and find idle clusters, oversized nodes and data kept long after anyone read it.

    03

    What breaks

    Example: Nightly jobs that fail and are rerun by hand

    Approach: We list failures and reruns from the scheduler and trace the worst offenders to skew, small files, schema drift or missing tests.

    04

    Who can run it

    Example: One engineer who understands how the cluster works

    Approach: We map the skills each platform needs against the team you have, because a platform nobody can operate is a risk whatever its features.

    05

    Who can see what

    Example: Broad read access to raw data that holds personal information

    Approach: We review roles, service accounts, encryption and audit logs, and list the data sets that need tighter access before anything moves.

    Decision record

    What goes into the target platform decision?

    We write one decision per platform layer, with the options considered, the choice and the reason, so the next engineer knows why the platform looks the way it does.

    01

    Storage

    • Warehouse, lake or lakehouse per workload
    • Open table format such as Apache Iceberg or Delta Lake
    • Object storage layout and partitioning
    02

    Compute

    • Warehouse SQL for most transformations
    • A distributed engine only where code or scale needs it
    • Separate compute for loading, transforming and serving
    03

    Ingestion

    • Batch loads from files and databases
    • Event streams only where freshness demands them
    • One owner and one contract per source
    04

    Serving

    • Dashboards and reports
    • Tables and APIs for applications
    • Exports to partners
    05

    Operations

    • Infrastructure as code for every environment
    • Orchestration, alerting and on-call
    • Cost limits and tagging

    Governance

    Which governance controls should exist before data grows?

    Adding these to a platform that is already full is slow, so we set them up with the first use case.

    • A data catalog that lists every data set with an owner, a description and a sensitivity label
    • Lineage from source table to dashboard, so a wrong number can be traced to the job and source behind it
    • Access by role, with column or row rules where data is personal, and service accounts scoped to the jobs that use them
    • Retention rules per data set, applied by scheduled jobs instead of manual clean-up
    • Schema change rules agreed with source system owners, so an upstream change cannot break downstream jobs silently
    • Audit logs of who read or changed sensitive data, kept as long as your policies require
    Implementation roadmap

    How does a phased big data implementation run?

    Big data implementation goes better one use case at a time. Each phase ends with something a team uses, not a platform waiting for users.

    1.

    Pick the first use case

    One report, product feature or model with a named owner, a clear source list and an agreed definition of done. It decides what the platform must support first.

    Phase 1
    2.

    Build the thin platform

    Storage, one ingestion path, one compute engine, the catalog and access roles, all defined as code and sized for the first use case only.

    Phase 2
    3.

    Deliver and reconcile

    The first use case goes live with its results reconciled against the current source of truth, and the owning team signs off before more is added.

    Phase 3
    4.

    Add use cases, retire old paths

    Each new use case reuses the platform and adds only what it needs. Old jobs, copies and clusters are switched off as their consumers move.

    Phase 4

    How do platform results reach an application or API?

    End to end big data applications do not stop at a dashboard. When results feed a product, the serving layer needs its own design.

    Serving tables

    Results written to a fast store such as PostgreSQL or Redis, shaped for the queries the application runs, so the app never queries the lake directly.

    Data APIs

    REST or GraphQL endpoints over the serving tables, with caching, pagination and rate limits, versioned so the platform can change behind them.

    Loads back into business systems

    Scores, segments and flags pushed into CRM, billing or support tools on a schedule, with each run logged and replayable.

    Features for models

    Model features computed once on the platform and served with the same definitions used in training, so predictions match what was tested.

    Freshness and fallback

    Each served data set carries its last update time, and the application shows a safe fallback when a load is late.

    Tenant and user scoping

    Row filters applied in the serving layer, so one customer's results never reach another customer's screen.

    Infrastructure

    How should big data infrastructure be laid out?

    Big data infrastructure services cover the platform layer under the use cases. We define all of it as code, so environments match and can be rebuilt.

    Environments

    • Separate development, test and production accounts or projects
    • Masked or synthetic test data
    • Jobs and schemas promoted by a pipeline, not by hand

    Infrastructure as code

    • Terraform or the cloud provider's own templates
    • Storage, compute, networking and roles in one reviewed repository
    • Drift checks against what is deployed

    Cluster and compute sizing

    • Sized for the first use case, then measured
    • Autoscaling limits so one bad job cannot grow without bound
    • Serverless or on-demand compute where load is irregular

    Network and security

    • Private endpoints between compute and storage
    • Encryption with keys you control
    • Central logging of access and changes

    Scope and cost

    What drives the cost of big data consulting and implementation?

    We do not publish prices or rate cards. Big data implementation cost depends on your sources and use cases, so these are the factors we size on the scoping call.

    Number and type of sources

    Databases, files, event streams and third-party APIs each need their own ingestion path and tests.

    State of the current platform

    Reviewing an existing cluster or lake adds discovery work, and moving off it adds a migration.

    History to load

    How much past data must be loaded and reconciled before the first use case can go live.

    Freshness

    Daily batch is the simplest. Minutes or seconds add streaming infrastructure and on-call.

    Governance and sensitive data

    Catalog, lineage, masking and audit needs, which grow when data includes personal or regulated information.

    Serving to applications

    APIs and serving stores for product features add application work on top of the platform.

    Who brings us big data consulting?

    Startups with growing product data

    Founders who need to know whether their database will hold up or a warehouse should come next. Big data consulting for startups often ends with a smaller platform than expected.

    Enterprises with an aging cluster

    Teams running Hadoop or a self-managed Spark cluster that costs more each year and has few people who can operate it.

    Data lakes that became storage bills

    Lakes full of raw files with no catalog, where nobody can say which data sets are current.

    Product teams adding data features

    Recommendations, usage analytics or customer reporting that must be served inside the application.

    Companies combining systems

    Several warehouses and lakes after a merger or reorganization that need one target platform and an order for moving.

    References

    References behind our platform designs

    NIST SP 1500-1r2NIST SP 1500-6r2Apache IcebergAzure Architecture CenterAWS, Google Cloud, Microsoft Azure
    Facts and sources

    Facts behind the platform decision

    Definitions and guidance from NIST and the platform owners that shape how we size a big data platform.

    Frequently Asked Questions

    The assessment and platform decision come first, and their length depends on how many sources and existing systems we must review. We agree that scope on the scoping call, then plan the roadmap one phase at a time.