Role Descriptions: Key Responsibilities – Snowflake & dbt Platform Engineer

Location: Titusville, NJ - Onsite

Mandatory Skills: Python, Amazon Web Service(AWS) Cloud Computing, Snowflake Data Build Tool

Experience Required: 10+ Years

• ·  Design, set up, and manage end-to-end Snowflake data platform, including accounts, databases, schemas, warehouses, roles, and access controls
• ·  Implement and administer Snowflake Horizon (governance framework) for data security, lineage, classification, and compliance
• ·  Build and maintain enterprise data marketplace/data sharing capabilities using Snowflake Secure Data Sharing and Marketplace features
• ·  Establish and manage dbt framework (Core/Cloud), including project structure, environments, CI/CD pipelines, and deployment standards
• ·  Develop and enforce data modeling standards (staging, curated, semantic layers) using dbt best practices
• ·  Enable data governance, cataloging, and discoverability across the platform
• ·  Design scalable, cost-optimized architecture in Snowflake (auto-scaling, clustering, resource monitors)
• ·  Integrate Snowflake and dbt with data ingestion and orchestration tools (e.g., Airflow, ADF, Fivetran)
• ·  Implement data quality, testing, and observability frameworks using dbt tests and monitoring tools
• ·  Build and maintain CI/CD pipelines and DevOps processes for platform components (Snowflake + dbt)
• ·  Define and manage security models (RBAC, masking policies, row-level security)
• ·  Support self-service analytics enablement for business teams via governed datasets
• ·  Provide platform-level support, optimization, and troubleshooting
• ·  Stay current with Snowflake ecosystem features (Horizon, Snowpark, Marketplace) and drive adoption