Hudson IT and Manpower

Data Architect / Principal Data Engineer III

Hudson IT and Manpower  •  $110k - $120k/yr  •  Farmington Hills, MI (Onsite)  •  3 hours ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

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

  1. 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.
  1. 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.
  1. 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.
  1. 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.
  1. 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.
  1. 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.
Hudson IT and Manpower

About Hudson IT and Manpower

The Hudson Group comprises of:

HudsonIT Consultancy Ltd – a dynamic Software Solutions and IT Staffing firm in United States and

Hudson Manpower Inc – specializing in offering comprehensive recruitment services for technical industries worldwide, ensuring quality hires for various sectors.

We began our journey in early 2019 and take pride in our ability to transform businesses through the seamless integration of cutting-edge digital solutions and outstanding staffing services. With a rich history of staffing experience, we have not only adapted but thrived in the ever-changing landscape of technological innovation.

Industry
Consulting & Advisory
Company Size
11-50 employees
Headquarters
Hoboken, New Jersey
Year Founded
2019
Social Media