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.
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.
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.
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