Duration: Long Term Contract
Work Mode: Hybrid – 3 Days/Week Onsite
Work Mode: Hybrid – 3 Days/Week Onsite
Start Date: ASAP
GBaMS Req ID: 10761190/ 86899-1
Client Name: TCS/Confidential
Position Overview
We are seeking an experienced Snowflake & dbt Platform Engineer to design, implement, and manage an enterprise-scale Snowflake data platform while establishing modern data transformation frameworks using dbt Core/dbt Cloud. The ideal candidate will possess strong expertise in Snowflake architecture, governance, security, CI/CD automation, and cloud-native data engineering practices with hands-on experience integrating enterprise data platforms.
The engineer will play a key role in enabling scalable analytics, governed data sharing, platform optimization, and enterprise data management initiatives.
Key Responsibilities
- Design, implement, and administer enterprise Snowflake Data Platform environments including:
- Databases
- Schemas
- Warehouses
- Accounts
- Roles and permissions
- Access control mechanisms
- Configure and maintain Snowflake Horizon Governance Framework for:
- Data lineage
- Data classification
- Security governance
- Compliance management
- Develop enterprise data marketplace and secure data sharing capabilities using:
- Snowflake Secure Data Sharing
- Snowflake Marketplace
- Build and manage dbt (Core/Cloud) framework, including:
- Project structure
- Environment setup
- CI/CD pipeline integration
- Deployment standards
- Define and enforce data modeling best practices including:
- Staging layers
- Curated layers
- Semantic models
- dbt transformation standards
- Enable enterprise data governance, cataloging, and discoverability initiatives
- Design scalable and cost-efficient Snowflake architecture utilizing:
- Auto-scaling
- Clustering strategies
- Resource monitors
- Performance optimization techniques
- Integrate Snowflake and dbt with ingestion/orchestration tools such as:
- Airflow
- Azure Data Factory (ADF)
- Fivetran
- Implement enterprise data quality and observability frameworks using:
- dbt tests
- Monitoring tools
- Validation frameworks
- Build and maintain CI/CD pipelines and DevOps processes supporting Snowflake and dbt deployments
- Design and manage platform security models including:
- RBAC (Role-Based Access Control)
- Row-level security
- Data masking policies
- Support governed datasets and self-service analytics capabilities for business teams
- Perform platform optimization, troubleshooting, and production support activities
- Stay updated with emerging Snowflake capabilities including:
- Horizon
- Snowpark
- Marketplace features
Required Skills
Mandatory Skills:
- Snowflake Data Platform
- dbt (Data Build Tool – Core/Cloud)
- Python
- AWS Cloud
- SQL Development
- Data Modeling
- CI/CD Pipeline Development
- Data Governance
- RBAC & Security Frameworks
- DevOps Processes
- Performance Optimization
Preferred Skills
- Airflow
- Azure Data Factory (ADF)
- Fivetran
- Data Observability Tools
- Enterprise Data Catalog solutions
- Snowpark experience
Required Experience
- 6–8 years of Data Engineering / Platform Engineering experience
- Strong hands-on experience with Snowflake platform administration and optimization
- Experience building enterprise-scale data transformation frameworks using dbt
- Experience working with cloud-based data ecosystems and DevOps practices
Lucky Vegi
Senior Technical Recruiter
732-289-2689 | lucky@mediit.io
Kendall Park, New Jersey – 08824
