Sr Data Engineer with Snowflake
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