Summary
Written in English from the original postingThis full-time, onsite role in Farmington Hills, Michigan focuses on designing, developing, and supporting scalable AWS-based data platforms and ETL/ELT pipelines. The position requires hands-on engineering with Python, SQL, PostgreSQL, Amazon RDS, DynamoDB, and S3, plus data quality, governance, and production support responsibilities. It also supports AI-enabled data solutions such as document processing, embeddings, and vector retrieval.
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.
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.
The weekly Digest
The week's most transparent data engineering jobs in your inbox once a week.
Once a week, a few new jobs that state their salary, location and stack, plus links to the rest. No open tracking; clicks are counted per issue, not per person. Unsubscribe with one click.

