Job Details

Data Architect / Principal Data Engineer III

FARMINGTON HILLS-48331, MI, US


Company

Hudson Manpower

Job Description

We are seeking an experienced Data Architect / Principal Data Engineer III to design, develop, and support modern, scalable data solutions for enterprise applications.

Location: Farmington Hills, MI
Work Arrangement: Onsite – 4 days per week
Experience: 8+ Years
Employment Type: Full-Time (W2)
Industry: Financial Services – Wealth & Asset Management

Position Overview

The Data Architect / Principal Data Engineer III will play a key role in designing, developing, and supporting secure, scalable, and high-performance data platforms and integration solutions within an AWS environment.

The ideal candidate will have strong hands-on expertise in Python, SQL, PostgreSQL, Amazon RDS, DynamoDB, Amazon S3, and ETL/ELT engineering, along with the architectural capabilities required to deliver enterprise-grade data solutions.

This role involves working with structured, semi-structured, and unstructured data, developing reusable ingestion and transformation frameworks, implementing data governance controls, and enabling vector-based information retrieval using PostgreSQL and pgvector.

Key Responsibilities

•

Data Architecture & Engineering

•

Design and implement scalable, secure, and reliable data architectures.

•

Develop and maintain high-performance data ingestion, transformation, and ETL/ELT workflows.

•

Build reusable Python and SQL components for enterprise data processing and integration.

•

Design solutions supporting structured, semi-structured, and unstructured data.

•

Evaluate architectural approaches and recommend appropriate data technologies.

2. AWS Data Platform Development

•

Design, develop, and support solutions using Amazon RDS, PostgreSQL, DynamoDB, and Amazon S3.

•

Develop and optimize relational and NoSQL data models.

•

Build integrations with internal and external applications through REST APIs.

•

Implement efficient JSON and Parquet processing workflows.

•

Optimize database queries, storage strategies, and data pipelines.

3. AI-Enabled Data Solutions

•

Support data ingestion, transformation, and preparation for AI-enabled applications.

•

Implement document-processing workflows involving structured and unstructured information.

•

Support document ingestion and text extraction using Amazon Textract.

•

Develop PostgreSQL/pgvector integrations for embedding storage, similarity search, and vector retrieval.

•

Collaborate with AI and application engineering teams to support intelligent search and retrieval applications.

4. Data Quality, Security & Governance

•

Implement data quality controls, validation, completeness checks, duplicate detection, and reconciliation.

•

Establish data lineage, metadata management, retention, and governance practices.

•

Protect sensitive financial and customer information.

•

Implement secure data access, encryption, and access-control mechanisms.

•

Support enterprise auditability, traceability, and data integrity requirements.

5. Production Engineering & Operational Excellence

•

Monitor data pipelines, databases, and integration processes.

•

Diagnose and resolve complex production and database performance issues.

•

Improve processing efficiency, scalability, and operational resilience.

•

Establish logging, monitoring, error handling, and recovery mechanisms.

•

Participate in engineering standards, design reviews, and documentation.

6. Collaboration & Technical Leadership

•

Collaborate with application developers, AI engineers, DevOps teams, enterprise architects, cybersecurity professionals, and business stakeholders.

•

Translate business and technical requirements into scalable data solutions.

•

Provide technical guidance on data architecture and engineering practices.

•

Participate in architectural reviews and technology selection.

•

Communicate technical decisions and trade-offs effectively.

Preferred Qualifications

The following experience will be an advantage:

•

Financial services, banking, Wealth Management, or Asset Management experience.

•

Amazon Textract and document extraction workflows.

•

Retrieval-Augmented Generation (RAG) architectures and AI-powered enterprise search.

•

AWS IAM, KMS, CloudWatch, and secure cloud infrastructure.

•

Data pipeline orchestration, event-driven architectures, and workflow automation.

•

CI/CD and Infrastructure as Code (IaC) for AWS data platforms.

•

High-volume financial transaction processing or regulatory data management.

•

Experience mentoring engineers or leading enterprise data engineering initiatives.

What Success Looks Like

The successful candidate will be able to:

•

Independently design and deliver production-ready AWS data engineering solutions.

•

Demonstrate advanced hands-on expertise in Python, SQL, PostgreSQL, and AWS database services.

•

Develop scalable ETL/ELT pipelines with strong data-quality and recovery capabilities.

•

Make sound architectural decisions involving relational databases, NoSQL, object storage, and vector retrieval.

•

Support AI-enabled data processing while maintaining enterprise security and governance.

•

Take ownership of complex technical challenges from architecture through implementation and production support.

•

Collaborate effectively with business and technology stakeholders.

Work Location & Requirements

•

Location: Farmington Hills, Michigan.

•

Work Arrangement: Onsite 4 days per week.

•

Local candidates are strongly preferred.

•

Candidates outside the area must be willing and able to meet the onsite requirement.

Requirements

Required Skills & Qualifications

•

8+ years of professional experience in Data Engineering, Data Architecture, Data Integration, or related disciplines.

•

Strong hands-on proficiency in Python for production-grade data processing, automation, and transformation.

•

Advanced SQL development skills, including complex queries, joins, window functions, query optimization, and performance tuning.

•

Extensive experience with PostgreSQL, including schema design, indexing, database optimization, and production support.

•

Hands-on experience with Amazon RDS and AWS-managed relational databases.

•

Experience with Amazon DynamoDB, including NoSQL data modeling, partition/sort key design, indexing, and query optimization.

•

Experience building cloud-based data ingestion, storage, and processing solutions using Amazon S3.

•

Strong ETL/ELT engineering experience, including designing, developing, and maintaining scalable data pipelines.

•

Solid understanding of relational and NoSQL data modeling, normalization, and data architecture principles.

•

Experience integrating REST APIs and processing JSON and Parquet data.

•

Experience with PostgreSQL pgvector, vector embeddings, similarity search, and vector-based retrieval.

•

Strong understanding of data validation, reconciliation, metadata, lineage, governance, and data quality.

•

Experience designing secure data-processing solutions involving sensitive or regulated information.

•

Knowledge of encryption, access controls, database security, and operational monitoring.

•

Experience supporting document-processing and AI-enabled data applications.

•

Strong analytical, troubleshooting, communication, and collaboration skills.