DataJobs.io
← Back to all jobs

Job Description

Robotics Technologies is seeking a senior data engineering contributor focused on Snowflake and DBT to support scalable analytics delivery in a fast-paced, cross-functional environment. This onsite role in Dallas, TX centers on building reliable data models and pipelines, improving Snowflake performance, and strengthening data quality and deployment workflows.

Job details: This position (Job ID: J53904) is offered on a 12 Months + Extension or 9 Months + Extension basis, with a $78/hour bill rate. Work will be onsite in Dallas, TX. Job type options include W-2, 1099, and C2C. Client information is to be discussed later, and domain exposure includes Oil & Gas.

Responsibilities

  • Design and implement scalable data models and pipelines aligned with business requirements.
  • Develop complex DBT models using macros, packages, and custom materializations.
  • Translate business requirements into effective technical data solutions.
  • Identify and resolve performance bottlenecks in Snowflake queries and DBT models.
  • Optimize Snowflake warehouse configurations and query performance.
  • Design and implement data quality frameworks, including testing strategies.
  • Create reusable DBT packages and macros to support team-wide use.
  • Manage CI/CD pipelines for DBT deployments.
  • Review and approve pull requests from junior developers.
  • Troubleshoot production issues and implement long-term solutions.
  • Document architectural decisions and data lineage.
  • Collaborate with business, product, QA, and technical teams to ensure successful delivery.

Requirements

  • Strong SQL skills, including CTEs, complex joins, analytic functions, and window functions.
  • Hands-on DBT experience, including advanced features such as macros, packages, and custom materializations.
  • Real-world experience with Snowflake and warehouse optimization.
  • Python experience, preferably at an intermediate level or higher.
  • Strong data profiling skills, including identifying primary and unique keys, cardinality, data types, precision, scale, and data skew.
  • Experience with data quality testing and validation.
  • Understanding of CI/CD pipelines and DBT deployment processes.
  • Strong communication, problem-solving, and analytical skills.
  • Ability to take ownership, work independently, and proactively achieve project goals.

Technologies

  • Snowflake, DBT, SQL, Python
  • CI/CD, macros, packages, custom materializations

Work Authorization

  • US-Citizen, H-1B, OPT-EAD, GC-EAD
  • US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, L2-EAD, GC-EAD

Similar Jobs