Hiring: Snowflake Engineer (W2 only) Company: InvestM Technology LLC Location: Boston, MA Job Posted Time: 2026-09-11 10:23:17 Employment Type: Hybrid Target Skills & Keywords : Agile, Azure, CI/CD, Data Pipeline, Data Warehouse, Git, Jira, Kafka, RBAC, SQL, Snowflake, dbt About the job Experience: •10+ years of data engineering experience, with a proven track record of hands on development and end to end solution delivery. Required Skills: •Design and implement scalable cloud data warehouse architectures, defining layer structures, schema design patterns, and partitioning/clustering strategies. •Architect physical and logical data models that balance query performance, storage efficiency, and business domain clarity, applying dimensional modeling and data techniques where appropriate. •Adopt cloud data frameworks to build modular, reusable SQL models across staging, intermediate, and mart layers with full documentation and lineage. •Build and maintain data pipelines that ingest data from diverse sources, snowflake shares, databases, APIs, event streams, and flat files into the cloud data warehouse reliably and at scale. •Implement batch and near-real-time ingestion patterns using cloud-native tools, managing incremental loads, CDC (change data capture), and idempotent pipeline design. •Optimize query performance through materialization strategies, clustering keys, and warehouse-specific query tuning techniques. •Implement and maintain role-based access control (RBAC), column-level security, dynamic data masking, and row-level access policies to enforce least-privilege and data privacy requirements. •Establish and maintain CI/CD pipelines for warehouse deployments automating testing, and promotion of transformation code across dev, UAT, and production environments. Qualifications: •Proven ability to design scalable cloud data warehouse architectures, defining layered structures, schema design patterns and physical data models that balance query performance, storage efficiency, and business domain clarity. •Deep expertise in Snowflake, including data modeling, performance tuning, and cost efficient design, along with experience managing vendor data shares for secure and governed access. •Advanced SQL skills with a strong foundation in data warehousing concepts, including dimensional modeling, incremental processing, slowly changing dimensions, and semantic layers. •Hands-on experience designing and operating cloud data solutions on Azure including ADF, ADLS Storage, with a strong grasp of cloud-native ingestion patterns and pipeline orchestration. •Proficiency in modern data transformation frameworks (dbt) including modular model design across layered warehouse architecture. •Operational familiarity with streaming and near-real-time ingestion patterns (e.g., Azure Event Hubs, Kafka) including incremental load design, CDC, and latency-aware pipeline considerations. •In-depth knowledge of platform reliability engineering for data warehouse covering orchestration, backfill and reprocessing strategies, and warehouse performance optimization. •Strong written and verbal communication skills with the ability to produce clear data model documentation, pipeline runbooks, and data dictionaries. •Bachelor's degree in computer science, information systems, or a related field. Interested candidates, please apply directly through the job posting on company's career page or try via AI auto apply on this platform. Don't miss this opportunity to join a forward-thinking team!