Senior Data Engineer - Snowflake

First Citizens Bank•Tallahassee, FL

1d•Remote

About The Position

This is a remote role that may only be hired in the following location(s): North Carolina, Florida, Texas, Arizona. This position is responsible for managing Snowflake data platform with multiple accounts. The role requires a deep knowledge of snowflake platform design, security, data warehouses, objects & access management, and features required for development of sophisticated data pipelines in an agile environment and collaboration with technical partners, stakeholders to drive data-driven decision-making.

Requirements

Bachelor's Degree and 4 years' experience OR High School Diploma or GED/Equivalent and 8 years' experience in data engineering, data technologies, cloud platforms

Nice To Haves

Designing, building, operating secure, cost-efficient data warehouses using medallion architecture on Snowflake.
Snowflake data security and governance strategies – Okta/SailPoint integration, RBAC, masking, data classification, tokenization, lineage.
Building, deploying metadata-driven, secured, governed snowflake objects, streamlit applications and dashboards, data pipelines integrated with AWS, DBT, observability tools through CICD automation.
Building, configuring, testing integrations between Snowflake and on-premise/cloud RDBMS and non-RDBMS data sources, Python frameworks, DBT, and reporting tools like PowerBI, Tableau etc.
Orchestrating, scheduling data pipelines using Astronomer Airflow.
FinOps for Snowflake, cost charge-back/show-back, warehouse auto-tuning.
Implementing logging, monitoring, alerting with Snowflake using ACCOUNT_USAGE/INFORMATION_SCHEMA, event tables, and integrating with Splunk, Dynatrace.
Adopting release management guidelines, code deployment to various environments, implementing disaster recovery strategies, leading production activities.
Experience with Cortex AI, Iceberg/external tables; Kafka or event-driven ingestion patterns.
Great Expectations, Monte Carlo/Anomalo/Atlan/Collibra/BigID integrations experience is a plus.
Financial banking, domain, consumption model experience is a plus.
Relevant cloud or data platform certifications

Responsibilities

Design and implement scalable, efficient data architectures.
Lead the development of data strategy aligned with business objectives.
Evaluate and integrate new technologies to enhance data capabilities.
Establish and enforce data governance policies, best practices and implement data quality checks, standardization.
Enforce Snowflake RBAC/ABAC, network policies/rules, masking/row access policies, tags, data classification, and least-privilege role hierarchies.
Build performant Snowflake objects (databases, tables, streams, tasks, materialized views, warehouses) and optimize clustering/micro-partitioning.
Analyze and optimize system performance for large-scale data operations.
Troubleshoot complex data issues and implement robust solutions.
Validate snowflake data objects, roles, RBAC policies, configurations, integrations, access.
Adopt release management processes to promote code deployment to various environments including production, disaster recovery, and support activities.
Mentor junior data engineers and provide technical guidance.
Contribute to the development of best practices and standards.
Collaborate with cross-functional teams to drive data literacy.