Home › Database Architect jobs in Michigan › Hudson Manpower

Data Architect / Principal Data Engineer III

Hudson Manpower · Farmington Hills, Michigan · Posted November 20, 2026 (today)

Apply on Hudson Manpower’s siteFill the application with AutoFillSee your fit for this role

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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

Posting 2835814 on recruitee. Source: the employer’s listing. Valid through January 4, 2027 unless closed earlier.