Snowflake Architect â Snowflake & DBT Modernization
Snowflake Architect â Snowflake & DBT Modernization
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Job Title: Snowflake Architect Snowflake & DBT Modernization
Location: Jersey City NJ 3-4 Days onsite
Long Term Project Contract W2
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.
About Next Gen Software Solutions LLC:
Next Gen Software Solutions is a trusted provider of IT Staffing and consulting services dedicated to empowering businesses with cutting-edge technology solutions and exceptional talent. We specialize in delivering tailored IT consulting services innovative software solutions and connecting businesses with highly skilled IT professionals. Founded and led by a dedicated U.S. Army solider Next Gen Software Solutions is deeply rooted in the core values of integrity discipline commitment and experience-principles that guide every aspect of our operations.
Equal Employment Opportunity Statement:
Next Gen Software Solutions LLC is an Equal Opportunity Employer. We are committed to fostering an inclusive and diverse workplace where all employees and applicants are treated respect and dignity. We do not discriminate based on race colour religion sex (including pregnancy sexual orientation or gender identity) national origin age genetic information veteran status or any other legally protected characteristic under applicable federal state or local laws.
Employment Type
Full-time
