Haystack
← Back to Jobs
Technology

Business Data Architect/Data Management Specialist

CA-One Tech Cloud Inc.Westwood, MA🇺🇸United StatesPosted 29 Jul 2026

Quick Overview

Work Type
On Site
Level
Mid Senior

Job Description

Contract Role: Business Data Architect/Data Management Specialist

Location: Westwood, MA or Johnston, RI Onsite

The Business Data Architect (Contract) will support enterprise data initiatives by designing and delivering scalable, modern data architecture solutions with a primary focus on canonical data modeling, semantic data mesh, and realtime streaming architectures using Kafka. This role drives alignment across business domains and enables highquality, governed, and interoperable data for analytics and operational use cases.

Key Responsibilities

  • Develop and enhance canonical data models, semantic models, and domaindriven data contracts to enable crossenterprise data interoperability.
  • Produce conceptual, logical, and physical data models aligned to business capabilities, modernization goals, and data mesh principles.
  • Design and implement data architecture patterns to support realtime streaming solutions using Kafka.
  • Partner with product owners, domain architects, and data engineering teams to translate business needs into scalable, wellgoverned data models.
  • Ensure consistent application of data governance, metadata management, and lineage standards across data domains.
  • Architect and optimize data pipelines and storage solutions using AWS (S3, Redshift, Glue, EMR, Lambda) and Snowflake.
  • Contribute architectural artifacts, modeling standards, and reusable templates for enterprise data modeling.
  • Support enterprise initiatives around realtime data integration, semantic mesh, and AI/ML enablement through strong data architecture foundations.

Required Skills & Experience

  • Significant experience with canonical data modeling and enterprisewide conceptual/logical/physical modeling.
  • Strong background in semantic modeling and data mesh design principles.
  • Handson experience with Kafka, including event modeling, schema strategy, and realtime pipeline architecture.
  • Proficiency in AWS data services (S3, Redshift, Glue, EMR, Lambda, EC2) and Snowflake.
  • Strong understanding of ETL/ELT design, data integration patterns, and distributed data systems.
  • Familiarity with data governance, data quality, metadata, and lineage frameworks.
  • Strong SQL skills and proficiency in at least one programming language (Python preferred).
  • Excellent communication skills with the ability to work across technical and business teams.

Preferred Qualifications

  • Experience with big data technologies (Spark, EMR, Delta, or similar).
  • Handson experience with enterprise data catalog and metadata systems.
  • AWS certification (Solutions Architect, Data Analytics Specialty, etc.).
  • Bachelor s degree in Computer Science, Information Systems, or related field (Master s preferred).

Engagement Details

  • Contract Role Duration and extensions based on project requirements.
  • Location: Westwood, MA or Johnston, RI (Hybrid or onsite as required).
  • Work aligned to standard business hours, Monday Friday.

Thanks & Regards,

Pankaj Singh - Team Lead

Phone #

Skills

SQL
AWS
ETL
Snowflake
Kafka
Python
Redshift

Similar jobs