Data Architect / Principal Data Engineer III Job ID 2486

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

Skills and Requirements

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
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.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [email protected].