Senior Data Architect for Enterprise Data & AI Pipelines

Strategic Data Systems, Inc.

Farmington Hills (MI)

On-site

USD 120,000 - 160,000

Full time

24 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Competitive base salary
Medical, dental, and vision insurance
Life and disability insurance
401(k) with company match
Paid vacation time
Paid Bench time
Training allowance
Referral bonuses

Job summary

Strategic Data Systems, Inc. is seeking a Data Architect / Principal Data Engineer III to design, build, and support scalable data solutions for enterprise Wealth & Asset Management applications.

The role emphasizes ingestion, transformation, storage, governance, and secure data processing across structured and unstructured data sources. Responsibilities include building ETL/ELT pipelines, data modeling with PostgreSQL, Amazon RDS, DynamoDB, and S3, plus enabling AI-enabled data use cases and

Qualifications

  • 8+ years of experience in data engineering or related roles.
  • Strong hands-on experience with Python, SQL, PostgreSQL, Amazon RDS, DynamoDB, and S3.
  • Experience developing and supporting ETL/ELT pipelines and data-processing workflows.
  • Experience with data modeling, APIs, JSON, Parquet, and pgvector.
  • Knowledge of data quality, metadata, governance, security, and monitoring.
  • Experience in large enterprise or regulated environments.
  • Experience supporting document-processing and AI-enabled data solutions.

Responsibilities

  • Design and develop scalable data ingestion and ETL/ELT pipelines.
  • Build solutions for structured, semi-structured, and unstructured data.
  • Develop reusable data-processing and transformation components using Python and SQL.
  • Design and support data models using PostgreSQL, Amazon RDS, DynamoDB, and Amazon S3.
  • Support document ingestion and extraction using Amazon Textract, where applicable.
  • Prepare and transform data for application, search, analytics, and AI-enabled use cases.
  • Support vector-based retrieval using PostgreSQL/pgvector, where required.
  • Implement data quality, validation, reconciliation, metadata, lineage, retention, and governance controls.
  • Implement secure data access and encryption for sensitive information.
  • Optimize data pipelines and databases for performance, reliability, scalability, and cost.
  • Implement monitoring and troubleshoot data-processing and integration issues.
  • Collaborate with application, AI, DevOps, architecture, cybersecurity, and business teams.

Skills

Amazon RDS
DynamoDB
ETL/ELT pipelines
data modeling
APIs
JSON
Parquet
pgvector
PostgreSQL
Python
S3
SQL

Tools

Textract

Job description

Strategic Data Systems, Inc. is seeking a Data Architect / Principal Data Engineer III to design, build, and support scalable data solutions for enterprise Wealth & Asset Management applications.

The role emphasizes ingestion, transformation, storage, governance, and secure data processing across structured and unstructured data sources. Responsibilities include building ETL/ELT pipelines, data modeling with PostgreSQL, Amazon RDS, DynamoDB, and S3, plus enabling AI-enabled data use cases and

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer: Scalable Pipelines & AI-Ready Data
Senior Data Engineer: Scalable Pipelines & AI-Ready Data

Valiant Technologies LLC • Sunnyvale (CA)

On-site
USD 150,000 - 190,000
Senior Data Engineer - Scalable Data Pipelines
Senior Data Engineer - Scalable Data Pipelines

Amazon Inc. • Bellevue (WA)

On-site
USD 155,000 - 209,000
Health insurance
401(k) matching
Parental leave
Senior Data Architect — Enterprise Data & Pipelines
Senior Data Architect — Enterprise Data & Pipelines

SiloSmashers, Inc. • Washington

On-site
USD 150,000 - 190,000
Senior Data Engineer: Scalable Data Pipelines & Analytics
Senior Data Engineer: Scalable Data Pipelines & Analytics

ProArch • United States

Remote
USD 140,000 - 190,000
Senior Data Engineer — Scalable Pipelines & Data Governance
Senior Data Engineer — Scalable Pipelines & Data Governance

CBTS • Farmington Hills (MI)

On-site
USD 96,000 - 110,000
Senior Data Architect: AWS Cloud, Pipelines & Governance
Senior Data Architect: AWS Cloud, Pipelines & Governance

Mphasis • Georgia

On-site
USD 90,000 - 174,000
Senior Data Engineer & Analytics Architect
Senior Data Engineer & Analytics Architect

ProArch • Atlanta (GA)

On-site
USD 120,000 - 180,000
Senior Data Engineer: Scalable Pipelines & AI-Ready Data
Senior Data Engineer: Scalable Pipelines & AI-Ready Data

Ethereum Technologies • Sunnyvale (CA)

On-site
USD 160,000 - 210,000
Senior Data Engineer: Scalable Pipelines for AI-Ready Data
Senior Data Engineer: Scalable Pipelines for AI-Ready Data

Eliassen Group • Farmington Hills (MI)

On-site
USD 83,000 - 107,000
Medical, Dental, Vision benefits
401k with company matching
Life insurance
Senior Data Engineer (Information Systems Analyst III Opt. S)
Senior Data Engineer (Information Systems Analyst III Opt. S)

Illinois LLC • Illinois

On-site
USD 110,000 - 165,000