Data Architect
$106,400–$155,000 year
On-site · Piscataway, New Jersey, United States
Job Summary
Lead definition, design, and governance of data assets within the Supply Chain IT domain; build data models (conceptual, logical, and physical), define the dbt project structure and modeling standards, implement data quality and privacy controls (PII masking, row-level security, dynamic masking), and manage metadata/lineage. Optimize data pipelines to reduce Snowflake credit consumption and improve report performance while ensuring long-term scalability and cost-efficiency. Collaborate with data engineers, data scientists, enterprise architects, and delivery leads to evaluate new features and tools. Education and experience require a Bachelor's or Master's degree in Computer Science or related field with 6+ years in data architecture, modeling, and data management. Proficiency in dimensional data modeling, Snowflake or cloud data warehouses, dbt/Coalesce, data warehousing/lakes (Databricks, BigQuery, Hadoop), orchestration (Airflow), and BI tools; strong governance and privacy knowledge (GDPR/CCPA). Preferred qualifications include domain experience in Supply Chain or Retail/CPG and relevant certifications.
Required Qualifications
- Bachelor's or Master's degree in Computer Science or a related field
- 6+ years of experience in data architecture, modeling, and data management
- Experience with Snowflake or cloud data warehouses
- Experience with dbt or Coalesce
- Strong data governance and security experience (PII masking, Row-Level Security, Dynamic Masking)
- Experience with data modeling (dimensional modeling, star/snowflake schemas)
- Knowledge of ETL/ELT patterns and data integration
- Familiarity with data fabrics/lakes (Databricks, BigQuery, Hadoop)
- Experience with orchestration tools (Airflow)
- Understanding of BI tools and data visualization
- Strong communication and collaboration skills
- Knowledge of privacy regulations (GDPR, CCPA)
- Relevant certifications (CDMP, Snowpro Advanced Architect, DBT Architect)
- Experience in Retail or/and Supply Chain domains
Apply with one swipe on Sorce. We auto-fill applications and apply on your behalf — no cover letters, no 40-minute forms.
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.