Snowflake Platform Engineer, Officer

Job description

**Role Overview** We are seeking a highly skilled **Snowflake Platform Engineer** to join our Cloud Platform Engineering (CPE) team. This role is responsible for the design, implementation, automation, and governance of enterprise-scale Snowflake data platforms within **regulated financial environments**. The ideal candidate will have strong expertise in **Snowflake, Microsoft Azure,** **Infrastructure-as-Code** **(Terraform), CI/CD (Azure DevOps), Git-based development workflows**, and **ITSM processes (ServiceNow)**, with a focus on **platform reliability, security, compliance, and automation**. **Key Responsibilities** **Snowflake Platform Engineering** - Design, build, and operate **Snowflake environments** (multi-account, multi-region, replication & failover). - Implement **secure RBAC models**, access provisioning, and governance frameworks aligned with enterprise standards. - Develop and maintain **automated onboarding pipelines** (accounts, databases, warehouses, roles). - Optimize **warehouse performance and cost (FinOps)**, including query tuning and utilization tracking. - Implement **data protection, encryption, masking policies**, and regulatory compliance controls. **Cloud & Infrastructure (Azure)** - Architect and manage Snowflake integrations with **Azure services** (Azure Key Vault, Private Endpoints, Managed Identity). - Configure **secure network connectivity** (Private Link, VNet integration, firewall policies). - Troubleshoot **TLS/SSL, connectivity, and authentication issues** across Azure and Snowflake. **Automation & DevOps** - Build and maintain **Infrastructure-as-Code** **(IaC)** using Terraform for Snowflake and Azure resources. - Develop CI/CD pipelines using **Azure DevOps (ADO)** for: - Integration configurations - Grants and RBAC automation - Enforce **Git-based version control** practices for platform artifacts (SQL, scripts, Terraform modules). - Implement **automated testing, validation, and rollback mechanisms** for deployments. **ITSM, Change & Release Management** - Integrate platform workflows with **ServiceNow** for: - Change requests - Incident management - Service catalog automation - Drive **controlled release processes** ensuring compliance with enterprise change policies. - Support **audit-ready deployments** with traceability across environments (Dev, QA, Prod). **Governance & Regulatory Compliance** - Ensure platform adherence to **regulated environment standards** (e.g., SOC2, ISO, financial compliance frameworks). - Maintain **audit logs, activity tracking, and access reviews** across Snowflake and Azure. - Implement controls for **Data** **retention, and security policies**. - Partner with Security and Risk teams for **periodic audits and remediation**. **Operational Excellence** - Develop **runbooks, SOPs, and architecture documentation** aligned with CRD standards. - Provide L3 support and lead **production incident resolution (Sev1/Sev2)**. - Implement **monitoring, alerting, and observability frameworks**. - Continuously improve platform reliability, scalability, and automation maturity. **Required Qualifications** - Bachelor’s or Master’s degree in Computer Science, Engineering, or related field. - **8+ years** of experience in data platform engineering or cloud infrastructure roles. - Strong hands-on experience with: - **Snowflake (core platform, security, replication, performance tuning)** - **Microsoft Azure (Storage, Networking, Identity, Key Vault)** - **Terraform (IaC for cloud and Snowflake resources)** - **Azure DevOps (CI/CD pipelines, release management)** - **Git version control (branching strategies, code reviews)** - **Experience in supporting third party applications such as Talend,Qlik,Looker.** - Experience with **ServiceNow ITSM workflows**. - Proven experience working in **regulated or financial services environments**. **Preferred Qualifications** - Experience with: - Snowflake **account replication and DR strategies** - **Multi-cloud data architectures** (AWS/Azure hybrid) - Automated **data access provisioning workflows (AI-driven preferred)** - Knowledge of: - **Data governance and catalog tools** - **Security frameworks and compliance standards** - **Microsoft Copilot, GitHub Co-pilot** - Snowflake and/or Azure certifications are a plus. **Key Competencies** - Strong **platform engineering mindset** (automation-first, scalable design) - Deep understanding of **data security and governance** - Excellent problem-solving and **production troubleshooting skills** - Ability to work across **cross-functional teams (CPE, Security, ACO, DevOps)** - Strong documentation and **executive communication skills** **Success Metrics (KPIs)** - Reduction in **manual onboarding effort (%)** - Improvement in **warehouse utilization efficiency / cost savings** - Increase in **automated deployment coverage (%)** - Reduction in **Sev1/Sev2 incidents** - Audit compliance with **zero critical findings** **Why Join Us** - Opportunity to build and scale **enterprise-grade cloud data platforms** - Work in a **highly regulated, mission-critical financial environment** - Drive **automation, AI integration, and platform innovation** - Collaborate with **global engineering and security teams** **About Charles River Development:** Charles River Investment management System in a platform that provides many Front-Office functions including Portfolio Management, Order Management and Execution, Compliance, Performance & Attribution, Modelling, Scenario Analysis, and Wealth Management. We are part of the State Street Bank. State Street is one of the largest custodian banks, asset managers, and asset intelligence companies in the world. From technology to product innovation, we’re making our mark in the financial services industry. For more than two centuries, we’ve been helping our clients safeguard and steward the investments of millions of people. We provide investment servicing,