Architect / Senior Developer (Remote)

US East Coast ( Hybrid) | [Full-time Contract] Salary: $75 – $100 per hour Our client is a leading professional services organization headquartered in New York City. They’re looking for a Senior Snowflake Developer / Architect to lead the design and delivery of their enterprise data platform. You can be based anywhere on the US East Coast, working Eastern Time hours, with occasional travel to the New York office and Tampa Florida You’ll own Snowflake solutions from architecture through to production. You’ll work with Finance, Operations and business leaders to turn data from across the firm into trusted, well-governed insight on client engagements, utilization, billing and firm performance. Lead the architecture of the Snowflake platform, covering account and environment design, warehouses, databases and layered data models (raw, staging, curated, presentation) Build and maintain transformation pipelines in dbt, including models, tests, snapshots, macros and incremental strategies Design, schedule and monitor data workflows in Apache Airflow (or Astronomer / MWAA), including DAG design, dependency management, alerting and recovery Integrate data from core business systems such as ERP, time and billing, CRM, HR and finance platforms into Snowflake using Snowpipe, Streams, Tasks and ingestion tools RBAC, masking and row access policies, data classification and secure data sharing for sensitive client and employee data Optimize performance and cost through warehouse sizing, clustering, query tuning and resource monitors Act as the technical lead with stakeholders, translating business requirements into scalable data solutions At least 2 full end-to-end Snowflake implementations, from design through to production go-live, where you held a lead technical or architecture role ~6+ years in data engineering or data warehousing, with 3+ years hands-on in Snowflake ~ Strong production experience with dbt, including project structure, testing, documentation and deployment ~ Expert SQL and strong Python ~ Snowpipe, Streams, Tasks, Dynamic Tables, Time Travel, zero-copy cloning and semi-structured data ~ Experience on at least one major cloud platform (AWS, Azure or GCP) ~ Solid data modeling skills (dimensional, Data Vault or similar) ~ A proven ability to work effectively in a remote or distributed team ~ SnowPro Advanced (Architect or Data Engineer) highly valued Experience in professional services, consulting, legal, accounting or similar firms, especially with engagement, utilization, time and billing, or practice management data Experience integrating data from ERP and business platforms such as SAP S/4HANA, Workday, Salesforce dbt Cloud, Astronomer or Cosmos (dbt-in-Airflow) experience Exposure to Snowflake Cortex AI or Snowpark BI tools such as Power BI, Tableau or Sigma