Snowflake Data Cloud Architect
TALENT Software Services
New York, United States of America
4 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
IntermediateJob location
New York, United States of America
Tech stack
Artificial Intelligence
Business Analytics Applications
Azure
Batch Processing
Cloud Computing
Data Architecture
Data Cleansing
Information Engineering
Data Governance
Data Masking
Data Systems
Interoperability
Python
Role-Based Access Control
Reference Data
Power BI
SQL Databases
Tableau
Data Ingestion
GitHub Copilot
Flask
Snowflake
FastAPI
PySpark
Information Technology
Kafka
Data Management
Streamlit Framework
Databricks
Web Api
Job description
As a Snowflake Data Cloud Architect , you will be responsible for designing and implementing scalable, secure, and high-performance data solutions on Snowflake to support our Investment Management business goals . You will lead the architecture for data platform integration , enabling seamless communication between upstream (custodians, market data providers) and downstream (risk, performance, reporting) systems using event-driven approaches . This role requires strategic thinking, technical leadership, and deep expertise in Snowflake and modern data engineering practices., * Architect and Implement Snowflake Solutions:
- Design and optimize Snowflake-based data architectures for portfolio, security master, transactions, benchmarks, and performance data.
- Implement advanced Snowflake features (Streams, Tasks, Snowpipe, Snowpark) for real-time and batch processing.
- Enable Event-Driven Integration:
- Build ingestion pipelines leveraging Kafka, Azure Event Hub, or similar technologies for market data and transactional feeds.
- Design workflows for upstream and downstream system interoperability.
- Data Governance and Compliance:
- Implement RBAC, data masking, and encryption aligned with enterprise data policy.
- Ensure lineage and observability for regulatory reporting and audit.
- Technical Leadership:
- Act as a trusted advisor for architectural decisions and future-state roadmaps.
- Prepare technical specifications and design documentation.
- Innovation and Best Practices:
- Advocate for data quality through automation, validation frameworks, and rigorous testing.
- Recommend new technologies to improve system performance and reliability.
Requirements
- Bachelor''s degree in Computer Science, MIS, Engineering, or related field.
- 10 years of experience in data architecture/engineering, with 3 years focused on Snowflake.
- Strong background in financial data domains (IBOR/ABOR, transactions, market data, reference data).
- Hands-on experience with:
- Snowflake architecture (warehouses, streams, tasks, Snowpark). SQL, Python; experience with DBT.
- Event-driven technologies (Kafka / Azure Event Hub).
- Web API development (Flask / FastAPI).
- Experience implementing data security measures and compliance frameworks.
- Experience building data solutions with AI tools like Github Copilot.
- Experience with Data Quality Tools such as dbt Test, Monte Carlo, SODA.
- Excellent communication skills with ability to collaborate across business and technology teams., * SnowPro Core / Advanced Architect certification.
- Experience with Aladdin Data Cloud, Bloomberg DL, or similar investment data platforms.
- Experience with Data Application development (Streamlit, Dash).
- Familiarity with BI tools (Power BI, Tableau).
- Knowledge of FinOps for cost optimization.
- Exposure to Databricks, PySpark, and advanced analytics workflows.