Data Architect / Principal Data Engineer III Job ID 2486

Required Skills & Experience

8+ years of experience in data engineering, data integration, or related roles. 5+ years of hands-on experience with Python 3+ years of hands on experience working in PostgreSQL, Amazon RDS, DynamoDB, and S3. Experience developing and supporting ETL/ELT pipelines and data-processing workflows. Experience with data modeling using Parquet, and pgvector. Strong experience with Data indexing, embeddings, or vectorization experience

Nice to Have Skills & Experience

Snowflake Generative AI / RAG data pipelines Vector databases AWS Fargate Experience processing complex documents or forms Experience supporting document-processing and AI-enabled data solutions.

Job Description

A large financial organization is seeking a Senior Data Engineer that will sit onsite 4 days a week in Farmington Hills Michigan for a contract role. The Senior Data Engineer is responsible for designing, building, and supporting scalable and secure data solutions for enterprise Wealth & Asset Management applications. The role focuses on data ingestion, transformation, storage, integration, quality, governance, and processing across structured and unstructured data sources.

Key Responsibilities

Design and develop custom ETL pipelines Write ETL scripts to process and transform incoming data Run data-processing workloads in AWS Fargate Convert unstructured and semi-structured data into structured datasets Process complex source data, including information originating from forms Design and support data workflows using PostgreSQL Implement vectorization and embeddings using pgvector Develop and maintain integrations with DynamoDB Work with data stored in Amazon S3 Manage relational and NoSQL data used by the application Partner with AI engineers to prepare and structure information for AI/LLM consumption Help establish scalable data-processing patterns for future phases of the platform