Data Engineer

Robotic Process Automation LLC

Raleigh (NC)

On-site

USD 120,000 - 180,000

Full time

4 days ago
Be an early applicant

Get a reply from this recruiter

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Robotic Technologies Automation seeks a senior data engineer to design and implement secure, scalable data pipelines in the cloud. You will work with Snowflake, dbt Cloud, Airflow, and Terraform to ingest, transform, and govern data across sources including SQL Server, Oracle, and mainframe-DB2.

Strong Python/SQL skills and FinOps awareness are essential. You will partner with business and IT to deliver reliable analytics capabilities.

Qualifications

  • Strong hands-on experience building metadata-driven data pipelines on Snowflake and data governance.
  • Experience building secure, audited, cost-efficient pipelines across sources (SQL Server, Oracle, mainframe-DB2, files).
  • Proficient with dbt Cloud, Airflow, Terraform for CI/CD and IaaC.
  • Knowledge of data classification, masking, RBAC, and data access controls.

Skills

Snowflake
dbt Cloud
Airflow
Python
PySpark
SQL
Terraform
Data governance
Cost optimization
RBAC & masking
Cloud security
ETL pipelines
Data lineage

Education

Certifications in relevant tech fields

Tools

Snowflake
Astronomer Airflow
dbt Cloud
Terraform
S3
Lambda
Glue
RDS
Kafka

Job description

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

Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other
Technical/Business Skills :
  • Strong hands-on experience in building robust metadata-driven, automated, secured, governed data pipeline solutions leveraging modern cloud data technologies, tools for large data platforms.
  • Strong experience designing, building, and operating secure, audited, and cost-efficient data pipelines using medallion architecture on Snowflake—from raw ingestion to Data Vault 2.0 models and onward to business-friendly consumption layers (mart/semantic).
  • Strong hands-on experience building, managing, packaging, deploying DBT Cloud data pipelines with advanced macros, SQL; automating testing strategies; and maintaining lineage.
  • Strong experience in Snowflake architecture, data classification, tagging & masking automation, Universal Search, performance tuning, security and cost optimization.
  • Strong hands-on experience building snowflake objects (tables, streams, tasks, materialized views) and optimize clustering/micro-partitioning.
  • Strong experience using Astronomer Airflow for orchestrating, scheduling data pipelines; and Terraform (with HashiCorp practices) for IaaC automation of pipelines.
  • Strong hands-on experience building data pipelines, data integrity solutions across multiple data sources and targets like SQL Server, Oracle, Mainframe-DB2, files, Snowflake.
  • Experience using S3, Lambda, SQS, SNS, Glue, RDS AWS services.
  • Excellent proficiency in Python, Pyspark, advanced SQL for ingestion frameworks and automation.
  • Experience in implementing logging, monitoring, alerting with Snowflake using ACCOUNT_USAGE/INFORMATION_SCHEMA, event tables, and integrating with Splunk, Datadog.
  • Strong experience designing, implementing tokenization, RBAC, masking policies, dynamic & conditional masking, data access controls across Snowflake and supporting systems.
  • Strong experience in adopting release management guidelines, code deployment to various environments, implementing disaster recovery strategies, leading production activities.
  • Internal dbt packages, reusable Terraform modules, project templates experience is a plus.
  • Experience with Iceberg/external tables; Kafka or event-driven ingestion patterns is a plus.
  • Experience FinOps for Snowflake, cost charge-back/show-back, warehouse auto-tuning is a plus.
  • Power BI/Looker metric-layer design; semantic modeling concepts experience is a plus.
  • Great Expectations, Monte Carlo/Anomalo/Atlan/Collibra/BigID integrations experience is a plus.
  • DBT mesh, custom materializations, Slim CI, state comparison experience is a plus.
  • Financial banking experience is a plus.
  • Must have one or more certifications in the relevant technology fields.
Functional Skills :
  • Team Player: Support peers, team, and department management.
  • Communication: Excellent verbal, written, and interpersonal communication skills.
  • Problem Solving: Excellent problem-solving skills, incident management, root cause analysis, and proactive solutions to improve quality.
  • Partnership and Collaboration: Develop and maintain partnership with business and IT stakeholders
  • Attention to Detail: Ensure accuracy and thoroughness in all tasks.

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer
Data Engineer

Robotics Technologies LLC • Raleigh (NC)

On-site
USD 120,000 - 180,000
Data Engineer
Data Engineer

Ethereum Technologies LLC • Plano (TX)

On-site
USD 120,000 - 190,000
Data Engineer with Snowflake
Data Engineer with Snowflake

Valiant Technologies LLC • Austin (TX)

On-site
USD 120,000 - 170,000
Data Engineer with Snowflake
Data Engineer with Snowflake

Quantum Technologies LLC • Austin (TX)

On-site
USD 120,000 - 160,000
Data Engineer with Snowflake
Data Engineer with Snowflake

Ethereum Technologies LLC • Austin (TX)

On-site
USD 120,000 - 180,000
Senior Data Engineer
Senior Data Engineer

Ethereum Technologies LLC • Chicago (IL)

On-site
USD 120,000 - 160,000
Senior Data Engineer
Senior Data Engineer

Valiant Technologies LLC • Chicago (IL)

On-site
USD 130,000 - 190,000
Senior Data Engineer
Senior Data Engineer

Robotic Process Automation LLC • Chicago (IL)

On-site
USD 120,000 - 180,000
Senior Data Engineer
Senior Data Engineer

Quantum Technologies LLC • Chicago (IL)

On-site
USD 130,000 - 200,000
Senior Data Engineer
Senior Data Engineer

Robotics Technologies LLC • Chicago (IL)

On-site
USD 120,000 - 180,000