Apply on Employer Site

PanAgora Asset Management · 20 hours ago

Senior Data Architect - Snowflake

United States

Full-time

Remote

Mid, Senior Level

$125K/yr - $182K/yr

5+ years exp

PanAgora Asset Management is committed to transforming financial lives through a flexible work environment and an inclusive culture. As a Senior Data Architect at Empower, you will be a strategic leader and technical expert responsible for shaping the enterprise data analytics platform and defining solution architectures while mentoring teams and establishing best practices.

FinanceFinancial Services

No H1B

Responsibilities

Own end to end solution architecture for connecting source systems to the enterprise analytics platform and delivering governed, performant, reusable data products for analytics and machine learning use cases

Define reference architectures and implementation patterns for Snowflake based solutions, including storage integration and stages, networking connectivity, key management, secure sharing, replication and disaster recovery approaches, and workload and warehouse strategy

Establish security on the platform including role-based access models, masking approaches, row level controls, and auditable access and usage practices, partnering with the data governance team for classification and policy inputs

Define ingestion and integration blueprints for batch, change data capture, and event driven pipelines, including guidance for when to use streaming patterns for low latency data movement

Set standards for contract first data products including semantics, versioning rules, reliability expectations, and clear consumption patterns for BI, analytics, and ML use cases, partnering with governance teams on catalog and stewardship processes

Build performance and reliability playbooks including workload isolation, concurrency patterns, sizing strategies, cost guardrails, and operational runbooks teams can execute

Establish and promote architectural standards, best practices, and review mechanisms while mentoring and coaching technology team members to ensure consistent adoption

Collaborate with business and engineering teams to design end to end solutions that meet strategic, technical, and operational objectives and can be delivered incrementally

Evaluate enabling tools and approaches for pipelines, quality, observability, and automation, and build business cases that influence direction

Guide engineering teams through solution design and implementation, improving long term scalability, performance, data quality, and cost efficiency

Qualification

Snowflake experienceData platform architectureSQL capabilityPython proficiencyData ingestion pipelinesCloud infrastructure automationCertifications SnowProCertifications AWSMentoring skillsCollaboration skillsProblem-solving mindset

Required

Strong, hands-on Snowflake experience, with the ability to define practical platform patterns and guide teams through implementation and operations

Working knowledge of Snowflake capabilities such as warehouses and workload management, cost controls, secure sharing, Tasks and Streams, and platform security controls

Deep experience delivering enterprise analytics and data platform solutions, typically gained through about 5 to 12 years in a data specialty such as engineering, platforms, or analytics, with 2+ years leading end to end solution design for complex initiatives

Strong understanding of modern data platform architecture including ingestion, transformation, modeling, consumption patterns, and operational readiness for analytics and ML workloads

Strong SQL capability including performance tuning fundamentals, plus proficiency in Python or a comparable language used for data engineering and automation

Practical experience addressing cross-cutting concerns including security, privacy, resiliency, scalability, observability, and cost optimization in cloud data platforms

Proven ability to drive alignment through influence by facilitating architecture reviews, documenting decisions and tradeoffs, and mentoring engineers and architects

Ownership mindset and strong work ethic with the ability to take ambiguous problems, create structure, and deliver outcomes with minimal oversight

Bachelor's degree in Computer Science, Information Systems, Engineering, or related discipline, or equivalent practical experience

Preferred

Snowflake performance specialist experience with concurrency patterns, warehouse sizing strategy, micro partition optimization, and repeatable playbooks for meeting BI and analytics latency expectations

Snowflake security specialist experience designing role models and applying masking and row level controls at scale, plus auditability using platform usage and access telemetry

Data ingestion and pipeline specialist experience with CDC and batch ELT approaches, orchestration tooling, and strong patterns for data quality and observability aligned to SLAs or SLOs

Streaming and event driven data specialist experience building and operating Kafka or Kinesis based architectures including ordering, replay, schema evolution, and real time observability

API and integration specialist experience designing API first data access patterns, API lifecycle governance, versioning, security, and developer enablement, plus event driven integration patterns to reduce point to point complexity

Cloud infrastructure and automation specialist experience with infrastructure as code, Git based CI/CD, and provisioning automation for Snowflake and surrounding platform components

Cost and performance specialist experience applying FinOps practices, workload right sizing, storage optimization, and performance engineering across Snowflake and adjacent cloud services

Applied AI and GenAI specialist experience designing safe enterprise patterns for retrieval, evaluation, monitoring, and responsible AI adoption

Certifications such as SnowPro or AWS Certified Solutions Architect, Associate or Professional

Benefits

Medical, dental, vision and life insurance

Retirement savings – 401(k) plan with generous company matching contributions (up to 6%), financial advisory services, potential company discretionary contribution, and a broad investment lineup

Tuition reimbursement up to $5,250/year

Business-casual environment that includes the option to wear jeans

Generous paid time off upon hire – including a paid time off program plus ten paid company holidays and three floating holidays each calendar year

Paid volunteer time — 16 hours per calendar year

Leave of absence programs – including paid parental leave, paid short- and long-term disability, and Family and Medical Leave (FMLA)

Business Resource Groups (BRGs) – BRGs facilitate inclusion and collaboration across our business internally and throughout the communities where we live, work and play. BRGs are open to all.

Company

PanAgora Asset Management

PanAgora Asset Management is a quantitative investment manager whose proprietary approach is designed to capitalize on inefficiencies across market cycles and to deliver relative and absolute returns through distinct and innovative equity, multi-asset and risk premia strategies.

Founded in 1989

Boston, Massachusetts, USA

51-200 employees