Sr Data Engineer with Snowflake
Job Description
Robotics Technologies is hiring a Sr Data Engineer with Snowflake for an onsite role in Dallas, TX. This position focuses on building scalable data models and reliable DBT/Snowflake pipelines, partnering closely with business, product, and QA teams to deliver production-ready analytics and improve data quality.
The engagement is structured for 12 Months + Extension with additional 9 Months + Extension options, and the bill rate is $78/hour. Work authorization options include US-Citizen, H-1B, OPT-EAD, GC-EAD and other listed statuses. Job type is available as W-2, 1099, or C2C. Job ID: J53904. Domain exposure: Oil & Gas.
Responsibilities
- Design and implement scalable data models and pipelines aligned to business requirements.
- Develop complex DBT models using macros, packages, and custom materializations.
- Translate business needs 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 and testing strategies.
- Create reusable DBT packages and macros to support team-wide adoption.
- 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 maintain data lineage.
- Collaborate with business, product, QA, and technical teams to support successful delivery.
Requirements
- Strong SQL expertise, including CTEs, complex joins, analytic functions, and window functions.
- Hands-on experience with DBT, including advanced use of macros, packages, and custom materializations.
- Real-world experience with Snowflake and warehouse optimization.
- Python experience, preferably 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