Data Architect / Principal Data Engineer III

Strategic Data Systems, Inc.

Farmington Hills (MI)

On-site

USD 120,000 - 160,000

Full time

27 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

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

Careers at SDS
Data Architect / Principal Data Engineer III

For more than three decades, Strategic Data Systems (SDS) has been a software consultancy firm specializing in strategy, technology, and business transformation for Fortune 100 companies, mid-sized firms, and startups. At SDS, we empower our development teams to address our clients' critical business challenges by leveraging cutting edge technologies. If you seek a workplace where your contributions are truly appreciated, then SDS is the company for you. Join us today to work alongside fellow development specialists and become a crucial part of our dynamic and cohesive community.

About This Role

Job Title: Data Architect / Principal Data Engineer III

Location: Farmington Hills, MI (onsite 4x/wk - local candidates strongly preferred)

Years of Experience: 8+

Top Skills
  • Amazon RDS
  • DynamoDB
  • ETL/ELT pipelines and data-processing workflows
  • Experience with data modeling, APIs, JSON, Parquet, and pgvector
  • PostgreSQL
  • Python
  • S3
  • SQL
What You'll Do

Position Summary

The Senior Data Engineer is responsible for designing, building, and supporting scalable and secure data solutions for enterprise Wealth & Asset Management applications. The role focuses on data ingestion, transformation, storage, integration, quality, governance, and processing across structured and unstructured data sources.

Key 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.
Required Qualifications
  • 8+ years of experience in data engineering, data integration, 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.
  • Strong understanding of data quality, metadata, governance, security, and operational monitoring.
  • Experience working within large enterprise or regulated environments.
  • Experience supporting document-processing and AI-enabled data solutions.
What You'll Get

SDS, Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state, and local laws.

  • Competitive base salary
  • Medical, dental, and vision insurance coverage
  • Optional life and disability insurance provided
  • 401(k) with a company match and optional profit sharing
  • Paid vacation time
  • Paid Bench time
  • Training allowance offering
  • You'll be eligible to earn referral bonuses!
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer III
Data Engineer III

Strategic Data Systems, Inc. • Cincinnati (OH)

Hybrid
USD 120,000 - 150,000
Competitive base salary
Medical, dental, vision insurance
401(k) with company match
+4
AWS Cloud & Platform Engineer III
AWS Cloud & Platform Engineer III

Strategic Data Systems, Inc. • Farmington Hills (MI)

On-site
USD 120,000 - 180,000
Medical, dental, vision coverage
401(k) with company match
Paid vacation time
+3
Platform Engineer III
Platform Engineer III

Strategic Data Systems, Inc. • Cincinnati (OH)

Hybrid
USD 110,000 - 160,000
Competitive base salary
Medical, dental, and vision insurance
Life and disability insurance
+5
Software Engineer - Java/Full Stack III
Software Engineer - Java/Full Stack III

Strategic Data Systems, Inc. • Farmington Hills (MI)

On-site
USD 96,000 - 165,000
Competitive base salary
Medical, dental, and vision insurance
401(k) with company match
+2
Security Software Data Engineer I
Security Software Data Engineer I

Strategic Data Systems, Inc. • Cincinnati (OH)

Hybrid
USD 90,000 - 150,000
Competitive salary
Medical, dental, vision insurance
401(k) with match
+4
Data Engineer II
Data Engineer II

Strategic Data Systems, Inc. • Cincinnati (OH)

Hybrid
USD 85,000 - 120,000
Competitive base salary
Medical, dental, and vision insurance
401(k) with company match
+4
Data Engineer - DataStage ETL I
Data Engineer - DataStage ETL I

Strategic Data Systems, Inc. • Cincinnati (OH)

Hybrid
USD 80,000 - 110,000
Competitive base salary
Medical, dental, and vision insurance
Optional life and disability insurance
+5
Platform Engineer IV
Platform Engineer IV

Strategic Data Systems, Inc. • Cincinnati (OH)

On-site
USD 83,000 - 138,000
Competitive salary
Healthcare coverage (medical, dental,
401(k) with company match
+3
Senior Databrick Data Engineering Consultant
Senior Databrick Data Engineering Consultant

SDG Group • Chicago (IL)

Hybrid
USD 140,000 - 190,000
Data Architect / Principal Data Engineer III
Data Architect / Principal Data Engineer III

Apex Systems • Farmington Hills (MI)

On-site
USD 120,000 - 160,000
Medical, dental, vision, and life/disb
ESPP
401K with company match
+5