Data Engineer

Robotics Technologies; San Jose (CA); On-site; USD 120,000 - 180,000; Full time

Job summary

Robotics Technologies is hiring a Data Engineer for an onsite role in San Jose, CA. You will design and deliver scalable data pipelines and processing solutions across sources and cloud platforms to support analytics and BI needs.

You will collaborate with data analysts, scientists, and stakeholders, building reliable, secure data systems. The work spans ETL/ELT, large-scale processing, warehouse modeling, and production support within Agile/Scrum.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or a related field required.
• Experience building data pipelines and ETL/ELT solutions.
• Strong programming in Python, SQL, and PySpark.
• Experience with cloud data platforms and data warehousing technologies.
• Understanding of data modeling and data integration concepts.
• Excellent analytical, problem-solving, and communication skills.

Responsibilities

• Designed, developed, and maintained scalable data pipelines from multiple sources.
• Built ETL/ELT workflows using Python, SQL, PySpark, and Azure Data Factory.
• Created and optimized data processing solutions with Apache Spark and Databricks.
• Working with structured and unstructured data from relational databases, REST APIs, flat files, and cloud storage.
• Implemented data integration aligned to BI and analytics requirements.
• Developed complex SQL queries, stored procedures, views, and functions.
• Implemented data validation, cleansing, transformation, and data quality checks.
• Built and maintained data warehouses, data marts, and dimensional data models.
• Integrated data from enterprise systems using REST APIs and connectors.
• Monitored pipelines, diagnosed failures, and resolved performance issues.
• Applied incremental loading, partitioning, and optimization techniques.

Skills

Python

SQL

PySpark

Azure Data Factory

Snowflake

Databricks

REST APIs

Git

Azure DevOps

Power BI

Education

Bachelor’s degree in Computer Science, Information Technology, or a related field

Tools

Azure Data Factory

Informatica

SSIS

Snowflake

Databricks

Job description

Robotics Technologies is hiring a Data Engineer for an onsite role in San Jose, CA. In this position, you will design and deliver scalable data pipelines and data processing solutions that work across multiple sources and cloud platforms, supporting analytics and business intelligence needs.

You will collaborate with data analysts, data scientists, and business stakeholders while building reliable, secure data systems. The work spans ETL/ELT development, large-scale processing, warehouse and dimensional modeling, pipeline monitoring, and production support within Agile/Scrum processes.

Responsibilities

• Designed, developed, and maintained scalable data pipelines to extract, transform, and load data from multiple sources.
• Built ETL/ELT workflows using Python, SQL, PySpark, and Azure Data Factory.
• Created and optimized data processing solutions with Apache Spark and Databricks.
• Worked with structured and unstructured data from relational databases, REST APIs, flat files, and cloud storage.
• Implemented data integration solutions aligned to business intelligence and analytics requirements.
• Developed complex SQL queries, stored procedures, views, and functions to transform and process large datasets.
• Implemented data validation, cleansing, transformation, and data quality checks to maintain accurate datasets.
• Built and maintained data warehouses, data marts, and dimensional data models.
• Integrated data from enterprise systems using REST APIs and database connectors.
• Monitored data pipelines, diagnosed failures, and resolved performance and data processing issues.
• Implemented incremental loading, partitioning, and optimization techniques to improve pipeline performance.
• Used Snowflake for data loading, transformation, query optimization, and warehouse management.
• Implemented data security, access controls, and governance practices for sensitive business information.
• Used Git and Azure DevOps for source control, CI/CD, and deployment management.
• Participated in Agile/Scrum ceremonies, technical discussions, code reviews, and production support.

Requirements

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Experience in data engineering, ETL development, and implementing data pipelines.
• Strong programming knowledge in Python, SQL, and PySpark.
• Experience working with cloud platforms and data warehousing technologies.
• Understanding of data modeling, database concepts, and data integration.
• Strong analytical, problem-solving, debugging, and communication skills.

Technologies

• Python, SQL, PySpark
• Apache Spark, Hadoop, Databricks
• Azure Data Factory, Informatica, SSIS
• Microsoft Azure, AWS
• Azure Data Lake, Azure Data Lake Storage, Amazon S3
• Snowflake, Azure Synapse Analytics, SQL Server
• PostgreSQL, MySQL, Oracle
• Star Schema, Snowflake Schema, Dimensional Modeling
• Git, Azure DevOps, CI/CD, Jenkins
• Power BI
• Agile, Scrum, SDLC
• REST APIs

For this onsite role in San Jose, CA, you will use a mix of cloud data platforms, ETL/ELT tooling, and warehouse technologies to deliver dependable data pipelines and analytics-ready data.