Snowflake Engineer (HYBRID _LOCAL CANDIDATES ONLY - DALLAS,TX)

SUM THEORY INC.
Dallas, TX, United States
3 days ago
Apply on www.careerbuilder.com
Prepare application

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Working hours
Regular working hours

Tech stack

Query Performance Java (Programming Language) JavaScript (Programming Language) Airflow Amazon Web Services ARM Architecture Cloud Database Cyber Security Data Architecture Information Engineering Data Governance Data Integration
+33 more
Extract Transform Load (ETL) Data Masking Data Migration Data Sharing Data Vault Modeling Data Warehousing Graph Database IT Management Python (Programming Language) PostgreSQL Microsoft SQL Server OpenFlow Performance Tuning Role-Based Access Control Power BI Scala (Programming Language) SQL Databases Systems Integration Tableau (Software) Cloud Platform System Snowflake IT Architecture Data Lineage Data Analytics Star Schema AWS Data Analytics Apache Kafka Data Management Stream Analytics Data Pipelines Databricks Golang Microservices

Job description

Role: Snowflake EngineerExperience: 10 years + Experience in Snowflake, DBT, Airflow, Snowflake Cortex, SQL, Fivetran, Apache Airflow, OpenFlow, AWS Data Tools (Sage maker, Glue, Kinesis, Kafka, Microservices, Event Bridge) and Cloud Data Engineering.Job Description:As a Snowflake Data Engineer, you will be the hands-on Snowflake Engineer for all Data engineering efforts. Your role is to design, implement, and optimize a high-performance data warehouse environment (Snowflake, Databricks, Astronomer, AWS) that serves as the “single source of truth.” You won’t just be moving data around; you’ll be architecting a scalable foundation that enables real-time analytics, data sharing, and AI-driven insights across the enterprise. Your mission is to ensure that our technology data stack is scalable, secure, andmost importantlyaligned with where the company wants to be in five years.Key ResponsibilitiesArchitecture Design: Design end-to-end data architectures within Snowflake, utilizing Virtual Warehouses, multi-cluster environments, and specialized storage optimization.Data Modeling: Create and maintain complex data models (Star Schema, Snowflake Schema, Data Vault 2.0) tailored for cloud-native performance. Strong Collaboration with various IT and Business stakeholders to curate, document and implement Data lineage, knowledge graphs, Data tracing and Compliance KPIs.Pipeline Engineering: Architect robust ETL/ELT pipelines using Snowpipe, Tasks, and Streams, integrating with tools like airbyte, dbt, Fivetran, or AWS.Governance & Security: Implement Role-Based Access Control (RBAC), data masking, and row-level security to ensure compliance with global standards (GDPR, HIPAA, etc.).Performance Tuning: Monitor and optimize query performance and credit consumptionensuring the system is as cost-effective as it is fast. Expert-level SQL and deep knowledge of Snowflake-specific features (Time Travel, Zero-copy Cloning, Data Sharing etc.Snowflake Reference Designs: Implement reference designs for ETL/ELT pipeline engineering including integration efforts with AWS platforms.Data Governance: Setup architecture and governance standards from Data engineering and Platform perspective and enforce Data Lineage, Data Stewardship across all business units.Required Skills & QualificationsCategory RequirementsExperience 10+ years in IT, with 4-6 years in a formal progressive hands-on Development experience using Data Engineering in Snowflake and AWS, Semantic Engineering, Data Modelling, Data Governance role.TechnicalBreadth Mastery of cloud ecosystems (AWS), microservices, Snowflake, Snowflake OpenFlow, Snowflake Cortex, Data standards, IT Governance, Security Architecture, Architecture Guidance, Security and data integration patterns. 7+ years in Data Engineering, with 3+ years focused specifically on Snowflake implementations.Frameworks Proficiency in Data Platforms Snowflake, Microsoft SQL, Postgres, Databricks, Microsoft Power BI, Tableau Reporting, AWS Data (Sage maker, Glue, Kinesis, RDS), Python, JavaScript, Scala, Go and Java programming.Soft Skills High-level “influencing without authority” and the ability to explain complex data engineering tech to non-techies.Certifications Snowflake Core Pro and Snowflake Advanced Architect Certifications(mandatory), AWS Data Engineering Certifications (nice to have), AWS Solution Architect Pro (nice to have)Education Bachelors or Masters in CS, MIS, Data Science, MBA or a related field (or equivalent battle-hardened experience).Duration: 3-5 Months (extensible based on performance)

Requirements

Experience: 10 years + Experience in Snowflake, DBT, Airflow, Snowflake Cortex, SQL, Fivetran, Apache Airflow, OpenFlow, AWS Data Tools (Sage maker, Glue, Kinesis, Kafka, Microservices, Event Bridge) and Cloud Data Engineering., Experience 10+ years in IT, with 4-6 years in a formal progressive hands-on Development experience using Data Engineering in Snowflake and AWS, Semantic Engineering, Data Modelling, Data Governance role.

Technical

Breadth Mastery of cloud ecosystems (AWS), microservices, Snowflake, Snowflake OpenFlow, Snowflake Cortex, Data standards, IT Governance, Security Architecture, Architecture Guidance, Security and data integration patterns. 7+ years in Data Engineering, with 3+ years focused specifically on Snowflake implementations.

Frameworks Proficiency in Data Platforms Snowflake, Microsoft SQL, Postgres, Databricks, Microsoft Power BI, Tableau Reporting, AWS Data (Sage maker, Glue, Kinesis, RDS), Python, JavaScript, Scala, Go and Java programming.

Soft Skills High-level “influencing without authority” and the ability to explain complex data engineering tech to non-techies.

Certifications Snowflake Core Pro and Snowflake Advanced Architect Certifications(mandatory), AWS Data Engineering Certifications (nice to have), AWS Solution Architect Pro (nice to have)

Education Bachelors or Masters in CS, MIS, Data Science, MBA or a related field (or equivalent battle-hardened experience).

Duration: 3-5 Months (extensible based on performance)

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerbuilder.com
Prepare application

Good distractions

Loading talks and stories from around this role…