Senior Data Engineer

Robotics Technologies; Sunnyvale (CA); On-site; USD 91,000 - 129,000; Full time

Job summary

Robotics Technologies is seeking a Senior Data Engineer for an onsite contract in Sunnyvale, CA. The role focuses on designing, building, and supporting scalable data solutions for enterprise Wealth & Asset Management applications, spanning ingestion, transformation, storage, integration, quality, governance, and processing across structured and unstructured sources.

Responsibilities include building ETL/ELT pipelines, data modeling with PostgreSQL/AWS services, and enabling AI-enabled data

Qualifications

• 8+ years of experience in data engineering or related roles.
• Hands-on with Python, SQL, PostgreSQL, Amazon RDS, DynamoDB and S3.
• Experience developing ETL/ELT pipelines and data-processing workflows.
• Experience with data modeling and formats/APIs including APIs, JSON, Parquet, and pgvector.
• Understanding of data quality, metadata, governance, security, and operational monitoring.
• Experience in large enterprise or regulated environments.
• Experience supporting document-processing and AI-enabled data solutions.

Responsibilities

• Design and develop scalable data ingestion and ETL/ELT pipelines.
• Build solutions for structured, semi-structured, and unstructured data.
• Create reusable data-processing components using Python and SQL.
• Design and support data models using PostgreSQL, Amazon RDS, DynamoDB, and S3.
• Support document ingestion and extraction using Amazon Textract where applicable.
• Prepare and transform data for application delivery, search, analytics, and AI use cases.
• Support vector-based retrieval using PostgreSQL/pgvector when required.
• Implement data quality, governance, and security controls.
• Optimize pipelines and databases for performance, reliability, and cost.
• Implement monitoring and troubleshoot data-processing issues.
• Collaborate with application, AI, DevOps, architecture, cybersecurity, and business teams.

Skills

8+ years data eng

Python

SQL

PostgreSQL

Amazon RDS

DynamoDB

S3

ETL/ELT pipelines

Data modeling

APIs/JSON

Tools

Apache Spark

Trino (Presto)

Apache Airflow

AWS

SQL

Job description

Robotics Technologies is hiring a Senior Data Engineer for an onsite contract role in Sunnyvale, CA. The position focuses on designing, building, and supporting scalable and secure data solutions for enterprise Wealth & Asset Management applications, spanning ingestion, transformation, storage, integration, quality, governance, and processing across structured and unstructured sources.

Responsibilities

• Design and develop scalable data ingestion and ETL/ELT pipelines.
• Build solutions to handle structured, semi-structured, and unstructured data.
• Create reusable data-processing and transformation components using Python and SQL.
• Design and support data models using PostgreSQL, Amazon RDS, DynamoDB, and Amazon S3.
• Support document ingestion and extraction using Amazon Textract, where applicable.
• Prepare and transform data for application delivery, search, analytics, and AI-enabled use cases.
• Support vector-based retrieval using PostgreSQL/pgvector, when required.
• Implement data quality, validation, reconciliation, metadata, lineage, retention, and governance controls.
• Implement secure data access and encryption for sensitive information.
• Optimize data pipelines and databases for performance, reliability, scalability, and cost.
• Implement monitoring and troubleshoot data-processing and integration issues.
• Collaborate with application, AI, DevOps, architecture, cybersecurity, and business teams.

Required Skills & Qualifications

• 8+ years of experience in data engineering, data integration, or related roles.
• Hands-on experience with Python, SQL, PostgreSQL, Amazon RDS, DynamoDB, and S3.
• Experience developing and supporting ETL/ELT pipelines and data-processing workflows.
• Experience with data modeling and formats/APIs including APIs, JSON, Parquet, and pgvector.
• Understanding of data quality, metadata, governance, security, and operational monitoring.
• Experience working within large enterprise or regulated environments.
• Experience supporting document-processing and AI-enabled data solutions.

Technical Requirements

• Must Have: Apache Spark
• Must Have: Trino (Presto)
• Must Have: Apache Airflow
• Must Have: AWS
• Must Have: SQL
• Must Have: Large-scale Data Engineering
• Must Have: Distributed Computing
• AWS knowledge is required, but does not need to be expert-level.
• Should understand: S3
• Should understand: IAM Roles
• Should understand: IAM Policies
• Should understand: RBAC / Permission

Tools & Technologies

Python, SQL, PostgreSQL, Amazon RDS, DynamoDB, Amazon S3, Amazon Textract, PostgreSQL/pgvector, pgvector, Apache Spark, Trino (Presto), Apache Airflow, AWS, IAM Roles, IAM Policies, RBAC / Permission

Role Details

• Location: Sunnyvale, CA (onsite)
• Employment type: Contract
• Compensation: USD 80 - 80 per hourly