Data Architect (Jersey City)

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 :

Regards,

Sumaiya Iqbal