Cloud Data Platform Architect - Snowflake & DBT Modernization Job at Diverse Lynx, Jersey City, NJ

T1lFSmYxN3EySDNvV0s0dFJVYkdDWGxDZ0E9PQ==
  • Diverse Lynx
  • Jersey City, NJ

Job Description

Job Title: Cloud Data Platform Architect - Snowflake & DBT Modernization Location: 1 Pershing Plaza, Jersey City, NJdays onsite Key Responsibilities: • Architecture Review & Optimization

  • Assess the current Snowflake-based data platform architecture.
  • Identify bottlenecks and inefficiencies in data transformation and processing.
  • Recommend architectural improvements for scalability, performance, and cost-efficiency.
• Code & SQL Review
  • Conduct detailed reviews of DBT models, SnowSQL scripts, and transformation logic.
  • Validate adherence to best practices in modularity, reusability, and performance tuning.
  • Suggest improvements for query optimization and resource utilization.
• Performance Tuning
  • Analyze slow-running queries and transformation pipelines.
  • Implement strategies for warehouse sizing, clustering, caching, and materialization.
  • Guide the team on Snowflake-specific performance features (e.g., result caching, automatic clustering).
• Best Practices & Governance
  • Establish coding standards and naming conventions for DBT and SnowSQL.
  • Define data governance, lineage, and documentation practices.
  • Recommend monitoring and alerting mechanisms for data pipeline health.
• Collaboration & Mentorship
  • Work closely with data engineers, analysts, and platform teams.
  • Mentor junior developers on Snowflake and DBT development.
  • Participate in sprint planning, code reviews, and architectural discussions.
Required Skills & Experience:
  • Proven experience as a Cloud Data Architect or Senior Data Engineer in Snowflake and other Cloud DB environments.
  • Strong hands-on expertise in DBT , SnowSQL , and SQL performance tuning .
  • Familiarity with Oracle Exadata and PL/SQL is a plus for comparative analysis.
  • 10+ years experience in data modeling ( logical and physical ) , ETL/ELT design , and designing and implementing data warehouse , performance tuning and optimization .
  • Understanding of CI/CD pipelines , version control , and deployment automation .
  • Excellent communication skills and ability to translate technical findings into actionable recommendations.
Preferred Qualifications:
  • Snowflake Architect Certification , DBT Certification.
  • Experience in banking or financial services data platforms.
  • Exposure to cloud platforms like AWS, Azure, or GCP.
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.

Job Tags

Similar Jobs

Polaris Law Group, LLC

Senior Associate Attorney - Estate Planning & Elder Law Job at Polaris Law Group, LLC

At Polaris Estate Planning & Elder Law , we dont just draft documentswe guide families through lifes most difficult and meaningful transitions. Our work protects what matters most, restores peace of mind, and helps families move forward with confidence. Were looking... 

Blue Trucking

Class A OTR Driver - Rent a Truck Job at Blue Trucking

 ...offering an exclusive Rental Lease Program designed for professional drivers who want the earning potential of a lease purchase but without...  ...cargo insurance & trailer rent) Requirements: Valid Class A CDL Current medical card Ability to pass a DOT drug test... 

Gpac

Oral Surgeon Job at Gpac

This is an amazing opportunity for an Oral Surgeon who is looking to join a reputable and successful practice that values professionalism, innovation and high-quality dental care. As an Oral Surgeon , you will play a crucial role in diagnosing and treating various dental... 

Lucid Staffing Solutions

Travel Outpatient RDN - Registered Dietitian Nutritionist Job at Lucid Staffing Solutions

 ..., New Hampshire. Job Description & Requirements ~ Specialty: RDN - Registered Dietitian Nutritionist ~ Discipline: Allied Health Professional ~ Start Date: 02/02/2026~ Duration: 13 weeks ~40 hours per week ~ Shift: 8 hours, days ~ Employment Type: Travel... 

MasTec

Aerial Lineman Job at MasTec

 ...MasTec - JobID: 55592 [Maintenance Technician / Electrical Technician] As an Aerial Lineman at MasTec, you'll: Install, repair, and maintain overhead telecommunications lines; Climb poles and towers to perform necessary tasks; String cables and wires to ensure proper connectivity...