Technology
Data Architect / Principal Data Engineer III
Hudson Manpower
Recruitee
- Location
- Farmington Hills, United States, United States
- Type
- contract
- Salary
- Salary not specified
- Posted
- 20 Nov 2026
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 ar
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. 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.