Senior Data Engineer

Robotics Technologies LLC; Atlanta (GA); On-site; USD 140,000 - 190,000; Full time

Job summary

Robotics Technologies LLC in Atlanta, GA is seeking a Senior Data Engineer to design production-grade PySpark pipelines reading from S3 Parquet/Delta and to build Snowflake warehouses and lakehouse components. You will implement SnowSQL, Snowpipe, Streams and Tasks, and create integrated data models for scalable analytics.

The role emphasizes Spark tuning for speed, reliability, and cost, plus Snowflake optimization, Cortex AI features, and Snowpark Python for advanced processing.

Qualifications

• 6+ years of enterprise data engineering experience.
• Hands-on PySpark, Spark SQL, Python and advanced SQL.
• Production experience with large S3 Parquet/Delta datasets.
• Deep Snowflake experience: data modeling, SnowSQL, Snowpipe, Streams, Tasks, RBAC and Iceberg Tables.
• Exposure to Snowflake Cortex AI, Snowpark Python and semantic analytics.
• Hands-on AWS data services (S3, Glue, EMR, Lambda, Redshift) and orchestration (Airflow).
• Strong communication and stakeholder collaboration.

Responsibilities

• Design production-grade PySpark batch/streaming pipelines reading S3 Parquet/Delta data.
• Tune Spark performance via partitioning, caching, and join optimization.
• Engineer Snowflake warehouses, schemas, models, and Snowflake features.
• Create Iceberg tables for lakehouse interoperability and CDC patterns.
• Optimize Snowflake with profiling, clustering and micro-partition pruning.
• Build Snowpark Python transformations and UDFs; evaluate Cortex integration.
• Integrate Cortex Agents, Cortex AI Functions and prompt-driven workflows.
• Develop AWS-native solutions with S3, Glue, EMR, Lambda and Step Functions.
• Modernize DataStage/Informatica ETL; ensure data quality, lineage and security.
• Collaborate with architects, analysts, TPMs and business teams on data products.

Skills

PySpark

Spark SQL

Python

Advanced SQL

Parquet/Delta

Snowflake

Snowflake Cortex AI

Snowpark Python

AWS

Airflow

ETL/ELT

Data warehousing

Lakehouse patterns

Tools

SnowSQL

Snowpipe

Iceberg Tables

Dynamic Tables

Materialized Views

RBAC

Job description

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Job Title: Senior Data Engineer

Location: Atlanta, GA

Duration: 8 Months

Bill Rate: $73/hour (C2C)

Job Type: W-2, 1099, C2C

Client: To Be Discussed Later

Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Job Description

• Design production-grade PySpark batch/streaming pipelines; read S3 Parquet/Delta datasets, implement complex transformations and high-volume deduplication.
• Tune Spark using partitioning, caching, broadcast joins, shuffle/skew optimization and execution-plan analysis; balance speed, reliability and cloud cost.
• Engineer Snowflake warehouses, schemas and models; implement SnowSQL, Snowpipe, Snowpipe Streaming, Streams, Tasks, Dynamic Tables and Materialized Views.
• Create Snowflake-managed or externally managed Apache Iceberg tables for interoperable lakehouse solutions; implement incremental ingestion and CDC patterns.
• Optimize Snowflake with query profiling, clustering, micro-partition pruning, warehouse sizing, caching and materialization strategies.
• Build Snowpark Python DataFrame transformations, UDFs and stored procedures; evaluate Snowpark Container Services for advanced processing.
• Enable Snowflake Cortex Analyst (semantic models/views, natural-language-to-SQL), Cortex Search (semantic retrieval/RAG) and Cortex AI Functions (summarization, classification, extraction).
• Explore Cortex Agents, Snowflake Intelligence and Snowflake Copilot; integrate LLM workflows, embeddings, APIs, prompt evaluation and governed AI access as appropriate.
• Build AWS-native solutions using S3, Glue, EMR, Lambda, Step Functions and Redshift; manage IAM, CloudWatch, orchestration and operational monitoring.
• Modernize DataStage/Informatica ETL; ensure data quality, validation, reconciliation, lineage, security, audit readiness and complete technical/runbook documentation.
• Collaborate with architects, analysts, TPMs and business teams to deliver maintainable, secure and cost-effective data products.

Required Qualifications

• 6+ years of enterprise data engineering; strong hands-on PySpark, Spark SQL, Python and advanced SQL (CTEs, window functions, joins, subqueries, tuning).
• Production experience reading large S3 Parquet/Delta datasets, implementing deduplication, and optimizing high-volume PySpark processing.
• Deep Snowflake experience: data modeling, SnowSQL, Snowpipe, Streams, Tasks, RBAC, Iceberg Tables, Dynamic Tables, Materialized Views and performance/cost tuning.
• Working exposure to Snowflake Cortex AI (Cortex Analyst, Search or AI Functions), semantic analytics and Snowpark Python; understanding of GenAI, LLMs, embeddings and RAG.
• Hands-on AWS S3, Glue, EMR, Lambda, IAM, Step Functions, CloudWatch and Redshift; Airflow, Step Functions or comparable orchestration.
• Knowledge of data warehousing, ETL/ELT, data lakes and lakehouse patterns; strong communication, problem-solving and stakeholder collaboration.

Preferred Qualifications

• Hands-on Cortex Analyst semantic models/views, Cortex Search/RAG, Cortex Agents, Snowflake Intelligence, Copilot, Snowpark Container Services, Streamlit in Snowflake or Native Apps.
• IBM DataStage/Informatica modernization; Git, Jenkins, GitHub Actions, Terraform and CI/CD; Great Expectations/dbt tests; Kafka/Kinesis; Databricks; Control-M and shell scripting.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.