Senior Snowflake Data Engineer

Location :Plano TX 75024- LOCAL ONLY

Duration : Fulltime/ Permanent JOB

Salary : $140 K to $170 K Per Annum Benefits Bonus

Top Skills: Snowflake Snow pipe RBAC SQL DBT Python Fivetran ETL Tool AI

Must have strong DBT

Key Responsibilities
Data Engineering & Pipeline Development

• Design build and maintain scalable data pipelines and ELT workflows using Snowflake DBT and Python.
• Develop SQL transformations from scratch to support analytics reporting and downstream data consumers.
• Implement automated ingestion pipelines using Snowpipe for near real-time data loading.
• Integrate data from multiple enterprise sources (APIs databases flat files cloud platforms) into Snowflake.

Data Modeling & Transformation

• Develop modular reusable DBT models to transform raw data into clean analytics-ready datasets.
• Design data warehouse models supporting enterprise analytics and BI tools.
• Optimize DBT model materializations build performance and compute usage.

Snowflake Architecture & Optimization

• Architect scalable Snowflake data warehouse environments.
• Implement performance optimization techniques including clustering partitioning query tuning and warehouse management.
• Monitor and optimize compute costs and query performance.

Data Governance & Security

• Design and implement enterprise RBAC security models in Snowflake.
• Ensure secure handling of sensitive and regulated data.
• Implement governance frameworks supporting data lineage auditing and compliance.

Analytics Enablement

• Create clean well-documented datasets optimized for analytics and reporting.
• Deliver trusted data models used by Tableau and other BI platforms.
• Collaborate with analysts BI developers and stakeholders to ensure data accuracy and usability.

Operational Excellence

• Lead improvements to DBT project architecture and operational efficiency.
• Implement testing documentation and CI/CD best practices for data pipelines.
• Develop reusable data assets and frameworks to support scalability across the data platform.

Required Skills & Qualifications
Technical Skills

• Ideal candidates will come from a Mid-size shop or Start-up
• Strong SQL coding experience (writing complex SQL from scratch).
• Hands-on experience with Snowflake Data Cloud.
• Experience implementing Snowpipe for automated data ingestion.
• Proficiency with DBT (Data Build Tool) for transformation and modeling.
• Strong Python scripting skills for automation and data processing.
• Experience designing enterprise RBAC security models in Snowflake.
• Knowledge of data warehousing dimensional modeling and ELT frameworks.
• Experience optimizing query performance and compute usage.

Data Platform & Integration

• Experience integrating multiple enterprise data sources.
• Strong understanding of data pipeline orchestration and workflow design.
• Experience building analytics-ready datasets for BI tools such as Tableau.

Preferred Qualifications

• Experience with modern data stack architectures.
• Familiarity with CI/CD pipelines for data engineering workflows.
• Experience with data governance compliance and secure data handling.
• Experience working with large-scale enterprise data environments.

Key Traits

• Strong problem-solving and analytical skills
• Ability to design scalable production-grade data pipelines
• Passion for data quality governance and performance optimization
• Strong collaboration and communication skills

Must have 4 year degree

Must join with no sponsorship

Must have strong communication skills