jobapplier

Data Architect / Principal Data Engineer III

Hudson Manpower

Skills

Required

  • integration
  • AWS
  • Python
  • SQL
  • PostgreSQL
  • Amazon RDS
  • DynamoDB
  • Amazon S3
  • ETL/ELT engineering
  • pgvector
  • relational databases
  • NoSQL
  • Data Engineering
  • Parquet
  • Amazon DynamoDB

Preferred

  • encryption
  • workflows
  • Retrieval-Augmented Generation (RAG) architectures
  • AI-powered
  • enterprise search
  • IAM
  • KMS
  • CloudWatch
  • secure cloud infrastructure

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

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.
  • & 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.
  • Take ownership of complex technical challenges from architecture through implementation and production support.
  • Collaborate effectively with business and technology stakeholders.

Requirements

  • 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.
  • 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.
  • Candidates outside the area must be willing and able to meet the onsite requirement.
  • 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.
  • 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 supporting document-processing and AI-enabled data applications.
  • Strong analytical, troubleshooting, communication, and collaboration skills.

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.
  • Experience designing secure data-processing solutions involving sensitive or regulated information.
  • Knowledge of encryption, access controls, database security, and operational monitoring.

Location

Farmington Hills, MI Work Arrangement: Onsite – 4 days per week

Work Location & Requirements Location

Farmington Hills, Michigan.

Work Arrangement

Onsite 4 days per week. Local candidates are strongly preferred.

Easy Apply