Lead Snowflake SME
Project description
We are seeking a highly experienced Lead Snowflake Expert to design and deliver a next-generation cloud data warehouse and integration platform. This role will be central to building a scalable, secure, and high-performance data ecosystem that supports our portfolio management software used by asset managers globally. You will lead the architecture and implementation of our Snowflake-based data platform, working closely with engineering, product, and client teams to ensure robust data pipelines, seamless integrations, and best-in-class data governance.
Responsibilities
- Architecture & Design o Define and own the end-to-end Snowflake data architecture, including data modelling, storage, and compute strategies o Design scalable ELT/ETL frameworks for ingesting data from internal systems, third-party providers, and client sources o Establish best practices for performance optimization, cost control, and security
- Implementation & Delivery o Lead hands-on development of Snowflake solutions, including schemas, pipelines, and data transformations o Build and optimize data ingestion pipelines (batch and real-time where applicable) o Integrate Snowflake with upstream and downstream systems (APIs, data lakes, reporting tools, etc.)
- Data Integration & Financial Data Expertise o Design robust ingestion and normalization of financial datasets (positions, transactions, market data, pricing, reference data) o Ensure data consistency and lineage across portfolio management workflows
- Governance & Security o Implement data governance frameworks including access control, auditing, and data quality monitoring o Ensure compliance with financial data regulations and client data security requirements
- Leadership & Collaboration o Act as technical lead across the project lifecycle, mentoring engineers and guiding best practices o Collaborate with product managers, architects, and client teams to translate business requirements into technical solutions o Influence tooling and technology decisions across the data platform
SKILLS
Must have
- Snowflake Expertise o Deep, hands-on experience with Snowflake architecture, performance tuning, and cost optimization o Strong understanding of Snowflake features (e.g., Snowpipe, Streams & Tasks, data sharing, zero-copy cloning)
- Data Engineering o Proven experience designing and building enterprise-scale data warehouses o Strong SQL skills and experience with modern ELT tools (e.g., dbt, Airflow, or similar) o Experience with cloud platforms (AWS, Azure, or GCP)
- Integration & Pipelines o Experience building robust data pipelines and integrating with APIs, message queues, and file-based ingestion o Familiarity with semi-structured data (JSON, Parquet, Avro)
- Software Engineering Mindset o Strong understanding of CI/CD, testing, version control, and infrastructure-as-code o Ability to balance architectural thinking with hands-on delivery
Nice to have
• Financial Services Domain (Highly Preferred) o Experience with asset management data models (portfolios, holdings, trades, valuations) o Understanding of market data vendors and financial data workflows Nice to Have • Experience with data cataloging and governance tools • Familiarity with real-time streaming technologies (e.g., Kafka) • Exposure to regulatory reporting or risk analytics platforms • Experience working in a SaaS or product-led environment
