Sr Data Engineer with Snowflake

Robotics Technologies; Dallas (TX); On-site; USD 89,000 - 126,000; Part time

Job summary

Robotics Technologies seeks a senior data engineering contributor focused on Snowflake and DBT to deliver scalable analytics 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.

The position offers a 12 Months + Extension or 9 Months + Extension contract with a $78/hour bill rate.

Qualifications

• Strong SQL skills with complex joins and analytic functions.
• Hands-on DBT experience with macros, packages, and custom materializations.
• Experience optimizing Snowflake warehouses and queries.
• Python programming for data engineering tasks.
• Experience with data quality testing and validation.
• Familiar with CI/CD pipelines for DBT deployments.

Responsibilities

• Design and implement scalable data models and pipelines.
• Develop complex DBT models using macros, packages, and custom materializations.
• Translate business requirements into 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 and testing strategies.
• Create reusable DBT packages and macros for team use.
• Manage CI/CD pipelines for DBT deployments.
• Review pull requests and mentor junior developers.
• Document data lineage and architectural decisions.
• Collaborate with business, product, QA and tech teams to ensure delivery.

Skills

SQL

DBT

Python

Data profiling

Data quality testing

CI/CD

Communication

Problem-solving

Tools

Snowflake

DBT macros

DBT packages

DBT materializations

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