Snowflake Database Architect; Local to MA or NJ
Job in
Boston, Suffolk County, Massachusetts, 02298, USA
Listed on 2026-06-06
Listing for:
Lorvenk Technologies
Full Time
position Listed on 2026-06-06
Job specializations:
-
IT/Tech
Data Engineer, Cloud Computing, Data Warehousing, Database Administrator
Job Description & How to Apply Below
Location:
Woodbridge, NJ or Boston, MA USA (Hybrid)
Duration:
Long Term
Exp: 13+ Yrs
Employment: W2
Interview:
Two Rounds (Virtual + F2F)
We are seeking a Snowflake Data Architect / Administrator to lead the design, implementation, and administration of a modern cloud data platform. This role will focus on Snowflake architecture, ETL modernization, and migration from legacy systems using DBT and Informatica.
Key Responsibilities- Architect and manage scalable, secure, and high-performance data solutions on Snowflake
- Lead end-to-end migration from on-premise data platforms to Snowflake, including assessment, planning, and execution
- Design and oversee ETL/ELT pipelines using DBT and Informatica Power Center
- Define data models, architecture standards, and best practices for data warehousing and data lakes
- Administer Snowflake environment, including performance tuning, resource optimization, and cost management
- Implement and manage Snowflake features such as Snowpipe, Streams, Tasks, UDFs, and external tables
- Design and enforce data security, governance, and access control policies
- Oversee ingestion of structured and semi-structured data (CSV, JSON, Parquet) from cloud storage
- Provide technical leadership, mentor developers, and guide architectural decisions
- Collaborate with cross-functional teams in an Agile environment
- Strong expertise in Snowflake architecture and administration
- Hands-on experience with DBT (Data Build Tool) and Informatica Power Center (8.x/9.x/10.x)
- Proven experience in data platform migration to Snowflake
- Advanced knowledge of SQL, PL/SQL, and data warehousing concepts
- Experience with Snowflake utilities (SnowSQL, Snowpipe, Streams, Tasks, UDFs)
- Familiarity with AWS and/or Azure cloud platforms
- Experience in performance tuning, query optimization, and cost control
- Working knowledge of Python, Control-M, Git Hub, and UNIX environments
- Experience working in Agile methodologies
- Experience converting legacy ETL workflows into DBT models
- Strong understanding of modern data architecture patterns (ELT, lakehouse, real-time pipelines)
- Prior experience in a lead or architect role
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×