Overview
On Site
$DOE
Accepts corp to corp applications
Contract - W2
Contract - 6 month(s)
Skills
SQL
Python
Snowflake
DBT
Job Details
HMG America LLC is the best Business Solutions focused Information Technology Company with IT consulting and services, software and web development, staff augmentation and other professional services. One of our direct clients is looking for Snowflake Architect in Branchburg, New Jersey. Below is the detailed job description.
Title: Snowflake Architect
Location: Branchburg, New Jersey Need local ot NY, NJ (Day-1 onsite)
Duration: 6+ Months Contract to Hire
Primary Skills: Snowflake Architect with SQL, Python, DBT
Job Description:
- 12+ years of experience in data architecture, data engineering, or solution architecture roles on AWS and Snowflake
- Design and optimize data architectures based on Lakehouse principles, guiding customers on best practices for data ingestion, transformation, and analytics.
- Lead technical discussions and deliver compelling presentations, demonstrations, and proofs-of-concept (POCs) showcasing value propositions
- Experience and detailed knowledge with Master Data Management, ETL, Data Quality, metadata management, data profiling, micro-batches, streaming data loads
- Extensive experience with CI/CD platforms such as GitLab CI, GitHub Actions, AWS CodeBuild, and Jenkins
- Develop observability frameworks for pipeline performance
- Experience in leading and mentoring teams
- Implement metadata synchronization, maintaining technical lineage and schema evolution tracking
- Enforce data governance through AWS IAM roles, Snowflake RBAC for centralized access control
- Define and enforce data governance, access control (RBAC), and security best practices across AWS and Snowflake environments
- Provide technical leadership, mentorship, and best practices for Snowflake and AWS data integration
- Hands on experience on ITIL Process
Preferred Certifications:
1. SnowPro Advanced Architect
2. AWS Certified Data Analytics
3. AWS Certified Solutions Architect
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.