Senior Data Engineer – Snowflake

This is a fully remote position, open to applicants in Arizona, +3 more states.

📋 Description

• Oversee the Snowflake data platform across various accounts

• Create and execute scalable, efficient data architectures

• Spearhead the development of a data strategy that aligns with business goals

• Assess and incorporate new technologies to improve data capabilities

• Set and uphold data governance policies, best practices, and data quality assessments

• Implement Snowflake RBAC/ABAC, network policies/rules, masking and row access policies, tags, data classification, and least-privilege role hierarchies

• Construct efficient Snowflake objects, such as databases, tables, streams, tasks, materialized views, and warehouses

• Enhance clustering and micro-partitioning

• Evaluate and boost system performance for extensive data operations

• Diagnose complex data challenges and apply effective solutions

• Verify Snowflake data objects, roles, RBAC policies, configurations, integrations, and access

• Embrace release management processes and facilitate code deployment across various environments, including production and disaster recovery

• Offer production support activities

• Guide junior data engineers and provide technical mentorship

• Establish best practices and standards

• Collaborate with cross-functional teams and technical partners to foster data literacy and promote data-driven decision-making

⛳️ Requirements

• Bachelor’s Degree with 4 years of experience in data engineering, data technologies, cloud platforms OR a High School Diploma or GED/Equivalent with 8 years of experience in data engineering, data technologies, cloud platforms

• Profound understanding of Snowflake platform design, security, data warehouses, objects, and access management

• Experience with advanced data pipelines in an agile environment

• Proficiency in designing, building, and managing secure, cost-effective Snowflake data warehouses utilizing medallion architecture

• Familiarity with Snowflake data security and governance strategies, including Okta/SailPoint integration, RBAC, masking, data classification, tokenization, and lineage

• Competence in constructing and deploying metadata-driven, secured, governed Snowflake objects, Streamlit applications and dashboards, and data pipelines integrated with AWS, dbt, and observability tools through CI/CD automation

• Experience in building, configuring, and testing integrations between Snowflake and on-premises/cloud RDBMS and non-RDBMS data sources

• Proficiency with Python frameworks, dbt, Power BI, Tableau, and Astronomer Airflow

• Knowledge of FinOps for Snowflake, cost charge-back/show-back, and warehouse auto-tuning

• Experience in implementing logging, monitoring, and alerting with Snowflake ACCOUNT_USAGE/INFORMATION_SCHEMA and event tables, as well as integrating with Splunk and Dynatrace

• Familiarity with release management practices, deploying code to different environments, implementing disaster recovery strategies, and leading production activities

• Experience with Cortex AI, Iceberg/external tables, Kafka, or event-driven ingestion patterns

• Familiarity with Great Expectations, Monte Carlo, Anomalo, Atlan, Collibra, or BigID integration is a plus

• Experience in the financial banking domain and consumption model is advantageous

• Relevant cloud or data platform certifications are preferred

• Candidates must be located in North Carolina, Florida, Texas, or Arizona

🏝️ Benefits

• Competitive, thoughtfully designed benefits program

• Comprehensive benefits information is available at https://jobs.firstcitizens.com/benefits