Principal Data Architect

Role Overview

• Define end to end Snowflake data architecture (conceptual → logical → physical), covering data domains, canonical models, event schemas, and integration patterns.
• Establish enterprise standards for: Data modeling (Dimensional + Data Vault where appropriate) Medallion architecture (Bronze/Silver/Gold), incremental loads, CDC Data quality SLAs and observability patterns (lineage, SLOs, anomaly detection)
• Develop authoritative Reference Architectures and Playbooks for integration, orchestration, CI/CD, data product lifecycle, agent safety patterns.
• Design multi-zone Snowflake topology (raw/stage/core/mart), data sharing, reader accounts, governance, row/column-level security, masking, tags.
• Optimize cost/performance (warehouse sizing, multi-cluster, caching, clustering keys, micro-partitions).
• Lead dbt standards (naming conventions, testing, documentation, docs-as-code), and orchestration (e.g., Airflow/Prefect/Control-M).
• Implement CDC pipelines (e.g., Fivetran/Hevo/Talend/Kafka Connect) from Salesforce, ERP, and operational systems.
• Define integration patterns (real-time, batch, event-driven, API-led, ETL) and select the appropriate approach per use case.
• Architect Salesforce data extraction (Bulk API 2.0, CDC, Platform Events) with resilient retry and backfill strategies.
• Normalize Salesforce objects (Leads, Accounts, Contacts, Opportunities, Cases, Activities, Campaigns) into canonical data models in Snowflake.
• Define event taxonomy (business-events, technical-events, derived-signals).
• Implement event routing (Kafka/Confluent, Pub/Sub, EventBridge..) with DLQs, replay, and exactly once semantics where feasible.
• Experience architecting and deploying data and AI solutions with Snowflake Cortex AI, including model orchestration, prompt-driven automation.
• Design and implement AI Agents: Tool-augmented (Salesforce APIs, email/slack, task systems, case routing) Explainability and decision logs for audits and compliance.
• Build closed-loop automation: signal → assessment → action → outcome → retraining feedback.
• Ensure data governance (catalog, lineage, stewardship, glossary, certifications).
• Stay current with Snowflake advancements and data platform trends.
• Find opportunities for platform innovation and efficiency gains.
• Work closely with fellow architects, engineers, security experts and team members across data domains to ensure successful implementation of platform initiatives.
• Work closely with cross-functional teams to align data solutions with business objectives.
• Provide technical leadership, mentorship, and architectural guidance to junior team members.

Requirements

• Bachelor’s degree in the field of Information Technology, Data Science, Computer Science, MIS, or another STEM-related field required.
• Significant experience in a similar role or industry will be considered as a replacement.
• 10+ years of experience in data architecture and engineering.
• 5+ years of hands-on Snowflake experience at enterprise scale.
• 5+ years working with Salesforce data, API’s, and integration patterns.
• 2+ years of experience supporting Finance or financial data domains.
• Deep Salesforce data expertise: schema knowledge, CDC, Bulk/REST APIs, Platform Events, Apex limits awareness.
• Proven delivery of event-driven architectures (Kafka/Confluent), CDC, dbt, orchestration (Airflow/Prefect).
• Experience designing Agents (rule engines, Python services, LLM tool-use), with strong auditability, and risk controls.
• Strong knowledge of semantic models, dimensional + Data Vault modeling, SCD patterns, PII governance, and access controls.
• Proficiency with CI/CD (GitHub Actions/Azure DevOps/Bitbucket Pipelines), IaC (Terraform for Snowflake), and automated testing for data pipelines.
• Snowflake SnowPro Advanced (Architect) certification.
• Salesforce certifications (Data Architect, Integration Architect).
• Experience with dbt metrics, semantic layers (Looker/Power BI), and feature stores (Feast/Tecton).
• Exposure to privacy-preserving techniques (tokenization, differential privacy, k-anonymity).

Tech Stack

• Airflow
• Azure
• ERP
• ETL
• Kafka
• Python
• Terraform
• Vault

Benefits

• Medical, dental, and vision insurance
• Health Savings Account with employer contribution
• 401(k) Retirement plan with employer match
• Paid Maternity Leave/Parental Bonding Leave
• Pet insurance
• Adoption Assistance
• Tuition reimbursement
• Employee Loan Program
• The Newrez Employee Emergency and Disaster Fund is a new program to support our team members
• Newrez NOW: Our Corporate Social Responsibility program, Newrez NOW, empowers employees to become leaders in their communities through a robust program that includes volunteering, philanthropy, nonprofit grants, and more
• 1 Volunteer Time Off (VTO) day, company-paid volunteer day where all eligible employees may participate in a volunteer event with a nonprofit of their choice
• Employee Matching Gifts Program: We will match monetary employee donations to eligible non-profit organizations, dollar-for-dollar, up to $1,000 per employee
• Newrez Grants Program: Newrez hosts a giving portal where we provide employees an abundance of resources to search for an opportunity to donate their time or monetary contributions