Senior Cloud Data Engineer — Financial Services

Mainz Brady Group

San Francisco (CA)

On-site

USD 150,000 - 230,000

Full time

14 days+

Application generator

Stand out for this role — generate a tailored resume and cover letter in about a minute.

Get past ATS filters

Job summary

Mainz Brady Group is seeking a Senior Cloud Data Engineer in San Francisco to design and implement scalable cloud data warehouse architectures. The role emphasizes hands-on data modeling, modern data pipelines, and secure data access across Snowflake and Azure platforms.

You will work on end-to-end data solutions for investment operations, leveraging dbt, SQL, and streaming technologies. Strong collaboration in an Agile environment and a focus on data quality are essential.

Qualifications

10+ years of data engineering experience with hands-on development and end-to-end delivery.

Responsibilities

Design and implement scalable cloud data warehouse architectures, including layered structures and partitioning/clustering strategies.
Architect physical and logical data models balancing query performance and storage; apply dimensional modeling.
Build modular, reusable SQL models across staging, intermediate, and mart layers with documentation and lineage.
Develop scalable data pipelines ingesting from Snowflake shares, databases, APIs, event streams, and flat files.
Implement batch and near-real-time ingestion patterns using cloud-native tech, including CDC and idempotent design.
Optimize Snowflake performance with materialization, clustering, and cost-efficient practices.
Establish and maintain RBAC, column-level security, dynamic data masking, and row-level access policies.
Set up CI/CD pipelines for data warehouse deployments including testing and promotion across environments.
Operate in Agile with Jira, delivering high-quality solutions on a regular cadence.
Utilize AI-assisted tooling to accelerate transformation development, data quality automation, and documentation.