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: Define and own the end-to-end Snowflake data architecture, including data modelling, storage, and compute strategies
* Design scalable ELT/ETL frameworks for ingesting data from internal systems, third-party providers, and client sources
* Establish best practices for performance optimization, cost control, and security
* Implementation & Delivery: Lead hands‑on development of Snowflake solutions, including schemas, pipelines, and data transformation
* Build and optimize data ingestion pipelines (batch and real-time where applicable)
* Integrate Snowflake with upstream and downstream systems (APIs, data lakes, reporting tools, etc.)
* Data Integration & Financial Data Expertise: Design robust ingestion and normalization of financial datasets (positions, transactions, market data, pricing, reference data)
* Ensure data consistency and lineage across portfolio management workflows
* Governance & Security: Implement data governance frameworks including access control, auditing, and data quality monitoring
* Ensure compliance with financial data regulations and client data security requirements
* Leadership & Collaboration: Act as technical lead across the project lifecycle, mentoring engineers and guiding best practices
* Collaborate with product managers, architects, and client teams to translate business requirements into technical solutions
* Influence tooling and technology decisions across the data platform
Skills
Must have
* Snowflake Expertise: Deep, hands‑on experience with Snowflake architecture, performance tuning, and cost optimization
* Strong understanding of Snowflake features (e.g., Snowpipe, Streams & Tasks, data sharing, zero‑copy cloning)
* Data Engineering: Proven experience designing and building enterprise‑scale data warehouses
* Strong SQL skills and experience with modern ELT tools (e.g., dbt, Airflow, or similar)
* Experience with cloud platforms (AWS, Azure, or GCP)
* Integration & Pipelines: Experience building robust data pipelines and integrating with APIs, message queues, and file‑based ingestion
* Familiarity with semi‑structured data (JSON, Parquet, Avro)
* Software Engineering Mindset: Strong understanding of CI/CD, testing, version control, and infrastructure‑as‑code
* Ability to balance architectural thinking with hands‑on delivery
Nice to have
* Financial Services Domain (Highly Preferred)
* Experience with asset management data models (portfolios, holdings, trades, valuations)
* Understanding of market data vendors and financial data workflows
* 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
J-18808-Ljbffr