Data engineering and analytics

Pipelines that bring your data together, a warehouse your team can trust, and dashboards that agree with each other. It’s where our founder comes from: seven years of data engineering in banking, fintech, retail and healthcare.

Services in data and analytics

4 services. Open any of them for what’s included, when it makes sense and what you get.

Data engineering

Pipelines that move your data reliably, every day.

  • Batch and streaming pipelines
  • ETL and ELT
  • Sources of every kind
  • Data quality checks

Warehouses and lakehouses

One clean, trusted home for all your data.

  • Platform choice and setup
  • Data modelling
  • Lakehouse design
  • Cost and performance tuning

Data migration

Moving off old systems without losing a row.

  • Legacy databases to modern platforms
  • On-premise to cloud
  • Spreadsheets into databases
  • Reconciliation

Analytics, BI and dashboards

Numbers your team trusts, without the manual work.

  • Dashboards
  • Metric definitions
  • Scheduled reports
  • Self-serve analytics

Projects we take on

The kinds of work clients bring to this practice.

One place for data from all your tools

Pipelines from your apps, databases, spreadsheets and SaaS tools into one warehouse, refreshed on a schedule.

Dashboards your team actually uses

Power BI, Tableau, Looker or Metabase, built on one agreed definition per metric.

Retiring manual Excel reporting

The reports someone assembles by hand every week, rebuilt to run on their own.

Moving off an old system

Legacy databases or on-premise servers to a modern platform, reconciled before the switch.

A data platform that can grow

Snowflake, Databricks, BigQuery or PostgreSQL, modelled so numbers stay consistent as you grow.

How we approach it

One definition per metric

Revenue, margin and every other number is defined once and written down, so every report agrees.

Alerts when something breaks

If a pipeline fails or data arrives late, someone knows straight away, before a report looks wrong.

Checks on the data itself

Row counts, totals and duplicates are checked on every run, so bad data stops before it reaches a dashboard.

Reconciled before any switch

When we migrate, the old and new systems are compared until the numbers match.

Who works on it

Karandeep Singh Talwar

Forward deployed AI engineer and analytics architect

SQL Server back ends, ASP.NET APIs, Power BI reporting and assistants built on Amazon Bedrock.

Harsh Sahu

Machine learning, IIT Kharagpur

Speech models, retrieval systems and reproducible data science, with tests and checks built in.

If your project needs a specialist we don’t have in-house, you hear it on the first call, and they’re named in your proposal before any work starts.

Related work

Built by our engineers before Orandic. None of these clients hired Orandic.

$ python -m pytest$ ruff check src scripts tests dashboard

Data science

Falcon 9 landing prediction

An end-to-end data-science project done properly: reproducible data with checksums, leakage-safe model selection, a stricter time-based test, automated tests on every push and an interactive dashboard.

Harsh Sahu’s data-science project.

Machine learning

Native language from spoken English

Hears five seconds of English and predicts the speaker’s first language: Hindi, Kannada, Malayalam, Tamil or Telugu.

Harsh Sahu’s machine-learning project. The code and the experiment log are public.

Questions about data and analytics

Which warehouse should we use?

It depends on how much data you have, who will use it and what you already pay for. For many growing companies PostgreSQL or BigQuery is enough; Snowflake and Databricks suit bigger volumes and teams. We recommend one after looking at what you have.

Can you work with Tally, Excel and our other tools?

Yes. Spreadsheets, exports from tools like Tally, databases and APIs can all be brought in. Where a tool has no API, we automate the export or set up a simple upload.

Who owns the data?

You do. Everything runs in your own cloud account, and we only get the access the work needs.

Other practices

Tell us what you need built.

A free 30-minute call with an engineer. You get the scope, timeline and price in writing before you commit, and a reply within one working day.