Data Architect / Principal Data Engineer III

Hudson Manpower•Farmington Hills, MI
•$55 - $60•Onsite

About The Position

The Data Architect / Principal Data Engineer III designs, develops, and supports secure, scalable, high-performance data platforms and integration solutions for enterprise applications in an AWS environment. The role works with structured, semi-structured, and unstructured data and develops reusable ingestion and transformation frameworks, data governance controls, and vector-based information retrieval capabilities using PostgreSQL and pgvector. The position combines hands-on data engineering with enterprise data architecture. It involves building and optimizing ETL/ELT pipelines, Python and SQL components, AWS data services, relational and NoSQL models, REST API integrations, and document-processing workflows. The role also supports AI-enabled applications, including embedding storage, similarity search, and retrieval, while maintaining data quality, security, auditability, and operational resilience. The successful candidate takes ownership of complex technical challenges from architecture through implementation and production support, provides technical guidance, and collaborates with application, AI, DevOps, cybersecurity, architecture, and business teams. This is a full-time W2 role based in Farmington Hills, Michigan, with an onsite requirement of four days per week. Local candidates are strongly preferred; candidates outside the area must be able to meet the onsite requirement.

Requirements

  • At least 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 PostgreSQL experience, 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 and 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.
  • Ability and willingness to work onsite four days per week in Farmington Hills, Michigan.

Nice To Haves

  • Experience in financial services, banking, wealth management, or asset management.
  • Experience with Amazon Textract and document extraction workflows.
  • Experience with Retrieval-Augmented Generation (RAG) architectures and AI-powered enterprise search.
  • Experience with AWS IAM, KMS, CloudWatch, and secure cloud infrastructure.
  • Experience with data pipeline orchestration, event-driven architectures, and workflow automation.
  • Experience with CI/CD and Infrastructure as Code (IaC) for AWS data platforms.
  • Experience with high-volume financial transaction processing or regulatory data management.
  • Experience mentoring engineers or leading enterprise data engineering initiatives.
  • Local candidates are strongly preferred.

Responsibilities

  • 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 for structured, semi-structured, and unstructured data.
  • Evaluate architectural approaches and recommend appropriate data technologies.
  • 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.
  • 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 on intelligent search and retrieval applications.
  • Implement data quality controls, including validation, completeness checks, duplicate detection, and reconciliation.
  • Establish data lineage, metadata management, retention, and governance practices.
  • Protect sensitive financial and customer information through secure data access, encryption, and access controls.
  • Support enterprise auditability, traceability, and data integrity requirements.
  • 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.
  • 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.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service