Data Architect
Dynatron Software, Inc.
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇺🇸 United States
Visit company websiteSalary
💰 $140,000 - $180,000 per year
Job Level
SeniorLead
Tech Stack
Amazon RedshiftAWSAzureBigQueryCloudDistributed SystemsGoogle Cloud PlatformKafkaPulsarPythonScalaSQLVault
About the role
- Design scalable conceptual, logical, and physical data models supporting OLTP, OLAP, real-time analytics, and ML workloads
- Architect modular, domain-driven data structures for multi-domain analytics
- Apply modern modeling techniques, including 3NF, Dimensional Modeling, Data Vault, Medallion Architecture, and Data Mesh principles
- Define canonical models, conformed dimensions, and enterprise reference datasets
- Architect real-time ingestion and event-driven pipelines using Kafka, Kinesis, Pulsar, or Azure Event Hub
- Design low-latency, high-throughput streaming architectures for operational and analytical use cases
- Design ML-ready datasets, feature stores, and reproducible data pipelines
- Architect for drift detection, data quality monitoring, lineage visibility, retraining workflows, and model governance
- Design scalable architectures using Snowflake, Databricks, or other cloud-native platforms
Requirements
- 7-10+ years of experience as a Data Architect or Senior Data Engineer in enterprise-scale environments
- Deep hands-on experience with Snowflake, Databricks, Azure Data Factory, AWS Glue, Bedrock, Redshift, BigQuery, or Teradata
- Strong SQL and Python/Scala skills, with expertise in schema design and metadata management
- Experience building streaming architectures with Kafka, Kinesis, or Event Hub
- Knowledge of ML/AI pipelines, feature stores, vector databases, and modern AI platform tooling
- Expertise in encryption, masking, tokenization, IAM, and RBAC
- Understanding of PII/PHI requirements and regulatory standards
- Experience implementing secure patterns across cloud platforms
- Experience designing distributed systems across AWS, Azure, or GCP
Benefits
- Comprehensive health, vision, and dental insurance
- Employer-paid short- and long-term disability and life insurance
- 401(k) with competitive company match
- Flexible vacation policy and 11 paid holidays
- Remote-first culture
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
data modelingOLTPOLAPreal-time analyticsML workloads3NFDimensional ModelingData VaultMedallion ArchitectureData Mesh