À propos
Location: Titusville, NJ (Onsite)
Job Type: Contract
Job Description:
Architecture & Design
Design and maintain end-to-end data architecture leveraging Snowflake as the cloud data warehouse Define 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 consumption Review and approve technical designs and data pipelines Data Modelling Design Pipelines using CoCo Generate AI Insights using Cortex AI
DBT Development & Governance
Lead implementation using Datacoves
Design and enforce dbt project structure, naming conventions, and folder standards Develop robust dbt models, macros, snapshots, and seeds Implement and maintain dbt tests (freshness, generic, custom) Enable auto-generated documentation and data lineage using dbt docs Establish CI/CD practices for dbt deployments
Data Engineering & Optimization
Optimize Snowflake performance using:
Clustering & micro-partitioning
Query optimization
Warehouse sizing and scaling
Monitor and control Snowflake cost usage Collaborate with ingestion tools Implement ELT best practices
Security, Compliance & Reliability
Implement Snowflake security controls (RBAC, masking policies, row-level security) Ensure adherence to data governance, compliance, and privacy standards Design data quality frameworks and SLAs Enable auditability and observability across the data platform Leadership & Collaboration
Act as a technical advisor to data engineers and analytics teams Mentor junior engineers and analysts Translate business requirements into scalable technical solutions Partner with stakeholders to define KPIs and semantic layers Contribute to platform roadmaps and architecture decisions Required Qualifications
8+ years of experience in data engineering or analytics engineering
8+ years of hands-on Snowflake architecture experience
6+ years of dbt (Core or Cloud) experience in production environments
Strong SQL expertise (advanced transformations and performance tuning) Deep understanding of ELT architectures Experience with cloud platforms (AWS, Azure, or GCP) Proficiency with Git-based version control and CI/CD pipelines Experience with data modeling methodologies
Diverse 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.
Compétences linguistiques
- English
Avis aux utilisateurs
Cette offre provient d’une plateforme partenaire de TieTalent. Cliquez sur « Postuler maintenant » pour soumettre votre candidature directement sur leur site.