Data Architect (Snowflake)

Role Data Architect (Snowflake)Location Titusville, NJ (Onsite)Exp need 10+ yearsJob DescriptionArchitecture & DesignDesign and maintain end-to-end data architecture leveraging Snowflake as the cloud data warehouseDefine data modeling standards (dimensional, hybrid, Data Vault, semantic layers)Architect scalable, cost-efficient Snowflake environments (databases, schemas, warehouses)Establish strategies for data ingestion, transformation, and consumptionReview and approve technical designs and data pipelinesData ModellingDesign Pipelines using CoCoGenerate AI Insights using Cortex AIdbt Development & GovernanceLead implementation using DatacovesDesign and enforce dbt project structure, naming conventions, and folder standardsDevelop robust dbt models, macros, snapshots, and seedsImplement and maintain dbt tests (freshness, generic, custom)Enable auto-generated documentation and data lineage using dbt docsEstablish CI/CD practices for dbt deploymentsData Engineering & OptimizationOptimize Snowflake performance using:Clustering & micro-partitioningQuery optimizationWarehouse sizing and scalingMonitor and control Snowflake cost usageCollaborate with ingestion toolsImplement ELT best practicesSecurity, Compliance & ReliabilityImplement Snowflake security controls (RBAC, masking policies, row-level security)Ensure adherence to data governance, compliance, and privacy standardsDesign data quality frameworks and SLAsEnable auditability and observability across the data platformLeadership & CollaborationAct as a technical advisor to data engineers and analytics teamsMentor junior engineers and analystsTranslate business requirements into scalable technical solutionsPartner with stakeholders to define KPIs and semantic layersContribute to platform roadmaps and architecture decisionsRequired Qualifications8+ years of experience in data engineering or analytics engineering8+ years of hands-on Snowflake architecture experience6+ years of dbt (Core or Cloud) experience in production environmentsStrong SQL expertise (advanced transformations and performance tuning)Deep understanding of ELT architecturesExperience with cloud platforms (AWS, Azure, or GCP)Proficiency with Git-based version control and CI/CD pipelinesExperience with data modeling methodologiesDiverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.