Data Architect Job at Avance Consulting, Jersey City, NJ

bUkzQTJaKy8vNDN0eDhhdU1uOXl3MEk5VGc9PQ==
  • Avance Consulting
  • Jersey City, NJ

Job Description

Hi Professionals,

We are hiring for a Data Architect - Snowflake & DBT Modernization Experience role, a permanent position with client Mphasis. If you are interested, then kindly drop your resume to sumaiya.iqbal@avanceservices.us/ 209 713 5294

Here are a few quick details about the role:

Job Title: Data Architect - Snowflake & DBT Modernization Experience

Experience: 12+ years

Location: Jersey City, New Jersey

Job Type: Permanent

Job Description

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

Regards,

Sumaiya Iqbal

Job Tags

Permanent employment,

Similar Jobs

Altea Healthcare

Physician Assistant Certified***PRN*** Job at Altea Healthcare

 ...Physician Assistant (PA-C) Post-Acute Care Location: St. Louis, Missouri Compensation: $420 - $520 per day + Uncapped Bonus Potential...  ...eligibility to obtain) Passion for geriatrics, internal medicine, or primary care Strong team player with excellent... 

Guardian Proservices

Airline Baggage Handler - RDU Airport Job at Guardian Proservices

 ...provide safe and courteous baggage handling services to various airline passengers. Making Every Moment Matter for a World on the GO....  ...Must be at least 18 years of age Authorized to work in the United States Must be able to pass background clearance verification... 

SteelFab, Inc.

Project Engineer Intern Job at SteelFab, Inc.

 ...sites or manufacturing environments.* Internship Locations: Charlotte, NC Raleigh,...  ..., PA Job Summary: As a Project Engineer Intern at SteelFab, youll work closely...  ...Shop Week : Gain hands-on experience with SteelFabs fabrication flow and production... 

BASF Corporation

2026 Summer Internship - Data Science/Computer Engineering - Geismar, LA Job at BASF Corporation

 ...and benefits to key stake holders and internal clients. Also, communicating the ideas...  ...you will participate in a 10 to 12week summer internship program at one of our Geismar...  ...and graduate students majoring inData Science/Computer Engineering College Sophomores and Juniors... 

RH

Sous Chef Job at RH

 ...integrated experience that engages our guests and immerses them in the RH lifestyle. RH is seeking an experienced and dynamic Sous Chef to play a key leadership role in our culinary team. In this role, you will help create world-class guest experiences while driving...