Data Architect

Jobtailor; Massachusetts; On-site; USD 140,000 - 190,000; Full time

Job summary

Jobtailor in Massachusetts seeks a Senior Data Architect to lead canonical data modeling and semantic modeling efforts across the enterprise.

You will design data architecture patterns for real-time streaming with Kafka, collaborate with cross-functional teams, and ensure governance, metadata, and lineage standards.

The role emphasizes hands-on work with AWS services and Snowflake, plus contributing reusable templates and architectural artifacts.

Qualifications

• Significant enterprise-wide canonical data modeling experience.
• Strong semantic modeling and data mesh design expertise.
• Hands-on Kafka and real-time pipeline architecture skills.
• Proficient in SQL and at least one language (Python preferred).
• Experience with governance, metadata and lineage frameworks.
• Excellent cross-team communication abilities.

Responsibilities

• Develop and enhance canonical data models for cross-enterprise interoperability.
• Produce domain-driven models aligned to modernization and data mesh goals.
• Design patterns to support real-time streaming with Kafka.
• Collaborate with product owners and data teams to translate needs into scalable models.
• Ensure governance, metadata, and lineage standards across domains.
• Architect and optimize data pipelines using AWS and Snowflake.
• Contribute modeling standards and reusable templates.
• Support real-time data integration and AI/ML enablement through solid data foundations.

Skills

Canonical data modeling

Semantic modeling

Data mesh design

SQL

Python

Excellent communication

Collaboration

Tools

Kafka

AWS Data Services

Snowflake

Job description

Responsibilities

• Develop and enhance canonical data models, semantic models, and domain‑driven data contracts to enable cross‑enterprise 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 real‑time streaming solutions using Kafka.
• Partner with product owners, domain architects, and data engineering teams to translate business needs into scalable, well‑governed 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 real‑time data integration, semantic mesh, and AI/ML enablement through strong data architecture foundations.

Requirements

• Significant experience with canonical data modeling and enterprise‑wide conceptual/logical/physical modeling.
• Strong background in semantic modeling and data mesh design principles.
• Hands‑on experience with Kafka, including event modeling, schema strategy, and real‑time 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.
• Hands‑on experience with enterprise data catalog and metadata systems.
• AWS certification (Solutions Architect, Data Analytics Specialty, etc.).

Hard Skills

• canonical data modeling
• conceptual modeling
• logical modeling
• physical modeling
• semantic modeling
• data mesh design
• real‑time pipeline architecture
• ETL
• ELT
• SQL

Soft Skills

• communication
• collaboration

Certifications & Qualifications

• AWS Solutions Architect
• AWS Data Analytics Specialty