Skip to content
Smart Data
Services
Modern data platforms
Data strategy consultingData engineeringData governance and qualityPower BI and analytics on Fabric

Platforms we build on

Microsoft FabricDatabricksSnowflake
AI
AI-assisted modernizationAI on your dataAI developmentAI readiness workshop

Start here

AI Enablement GuideReadiness self-check
Applications
Application developmentLegacy modernizationERP and enterprise integrationAPIs and API security

ERP integration

SAP S/4HANA and ECC, NetSuite, Dynamics, Oracle, Epicor and others
How we work
Managed servicesScoped projectsStaff augmentationDirect placement

Where the work happens

Dayton, OhioSmart Data Global Center
All services
Work
National distributor620+ known vulnerabilities eliminated across the customer portalsManaged servicesNuvei: Managed services for payments-to-ERP integrationsGoogleGoogle: A custom LMS for the internal sales teamAll case studies
Industries
HealthcareFinancial servicesInsuranceManufacturing and industrialRetail and distributionAll industries
Insights
BlogEventsSD Labs(opens in a new tab)Tools, open source and talks from our engineersAI Enablement GuideData readiness assessment
Company
AboutCareersSmart Data Global CenterPartners
Talk to us about scope
info@smartdata.net(937) 886-9166

Unified data pipeline from three charging platforms to a Snowflake dashboard

Smart Data partnered with an EV charging provider to unify data platforms using Snowflake and AWS serverless architecture, enabling real-time insights and scalable internal workflows.

Built onSnowflakeAWSReact

Industry
EV charging infrastructure
Engagement
Data Platform
Timeline
5 Months
A row of electric vehicle chargers with glowing green rings

An EV charging start-up needed its charger and fleet data in one place, a dashboard for its customers and support workflows for its own team. With limited internal resources and competing priorities, they turned to Smart Data to deliver data integration, warehousing, reporting and customer-facing tools that could evolve with their business. Smart Data stepped in to deliver serverless data pipelines, a Snowflake data warehouse, a secure customer dashboard and Jira support workflows.

The challenge

The client needed to:

  • Unify data across multiple platforms (Synop, Geotab, Ampcontrol)
  • Build a performant, fault-tolerant cloud data architecture
  • Provide customers with a secure, self-service dashboard
  • Establish internal workflows in Jira Service Management
  • Recruit and onboard a full-time Data Warehouse Architect

They needed a partner who could guide technical strategy, provide hands-on execution and adapt to evolving priorities.

An electric vehicle plugged in at a charging station

The solution

Smart Data supported the client across architecture, development and staffing. Our delivery included:

  • Serverless Data Pipelines: Built on AWS using Lambda, EventBridge, Step Functions, S3, SQS and API Gateway
  • Snowflake Data Warehouse: Implemented a Snowflake data warehouse modeled with Data Vault principles
  • Customer dashboard: the first version, built with React and Next.js and secured with Auth0, later rebuilt as a multi-tenant app, backed by Snowflake for live data
  • JIRA Setup: Worked side-by-side with internal teams to configure JSM workflows and reporting
  • Recruiting Support: Helped hire and integrate an in-house data warehouse architect

The results

  • Synop, Geotab and Ampcontrol data unified through serverless pipelines on AWS

  • One Snowflake warehouse, modeled with Data Vault, behind the client’s business reporting

  • Secure customer dashboard with self-config tools and rich data visualization

  • Integrated support system in Jira Service Management

Client

Industry

Technology

Platform and technology

  • React
  • TypeScript
  • AWS
  • Snowflake
  • Auth0
  • Python
  • Next.js
  • Data Modeling
  • ETL & Data Pipelines

Related services

Snowflake consultingData engineering

Working on something like this?

Talk to us about scope

How it fits together

Three charging platforms, one warehouse, one customer dashboard

Data from Synop, Geotab and Ampcontrol flows through serverless pipelines on AWS (Lambda, EventBridge, Step Functions, S3, SQS and API Gateway) into one Snowflake warehouse modeled with Data Vault. The warehouse feeds a customer dashboard built with React and Next.js and secured with Auth0, and the client’s business reporting. Around the pipeline, Smart Data set up Jira Service Management workflows with the client’s teams and recruited and onboarded an in-house data warehouse architect.

  • Synop
  • Geotab
  • Ampcontrol

Serverless pipelines

Lambda, EventBridge, Step Functions, S3, SQS, API Gateway

One Snowflake warehouse

Modeled with Data Vault

  • Customer dashboard

    React and Next.js, secured with Auth0, self-service for customers

  • Business reporting

    Business reporting

Around the pipeline

  • Jira Service Management workflows set up with the client’s teams
  • An in-house data warehouse architect recruited and onboarded

Related case studies

All case studies

Working on something similar?

Tell us what you are building and what it has to connect to. Here is what happens after you reach out.

  1. A short call about the work

    What runs today, what needs to change and the date you are working toward.

  2. An engineer looks at what’s running

    Scope comes from your systems as they are, before anything is priced.

  3. You get a written proposal

    Covering scope, team, approach and price.

info@smartdata.net(937) 886-9166

Tell us what you are working on

We use your details only to reply.

Your privacy choices

Choose what this browser shares with us. The site works the same either way. Privacy policy