

OrionTek Inc
Snowflake Architect
β - Featured Role | Apply direct with Data Freelance Hub
This role is for a Snowflake Architect in Boston, MA, offering a long-term contract. Requires 10+ years in cloud engineering, 5+ years in Snowflake, and expertise in financial services. Key skills include advanced SQL, ETL/ELT, and cloud integration.
π - Country
United States
π± - Currency
$ USD
-
π° - Day rate
Unknown
-
ποΈ - Date
August 12, 2026
π - Duration
Unknown
-
ποΈ - Location
On-site
-
π - Contract
Unknown
-
π - Security
Unknown
-
π - Location detailed
Boston, MA
-
π§ - Skills detailed
#Data Lakehouse #Databricks #dbt (data build tool) #SQL (Structured Query Language) #Airflow #AI (Artificial Intelligence) #ML (Machine Learning) #Apache Airflow #Data Lake #Data Modeling #Azure #Cloud #Batch #Snowflake #Automated Testing #DevOps #Azure cloud #AWS (Amazon Web Services) #"ETL (Extract #Transform #Load)"
Role description
We have an opening for Snowflake Architect at Boston, MA for Long-term Contract with one of our clients. Please review the job description below and let me know at your earliest convenience if youβre interested.
Job Title: Snowflake Architect
Location: Boston, MA
Duration: Long-term Contract
Key Responsibilities:
β’ Platform Architecture: Define and scale cloud-native architectures that interface Snowflake with AWS or Azure cloud platforms.
β’ Data Modeling & Pipelines: Design high-volume relational and complex data models capable of handling real-time streaming and batch ingestion.
β’ Governance & Performance: Implement advanced Snowflake features like RBAC (Role-Based Access Control), virtual warehouse sizing, micro-partitioning, query profiling, and zero-copy cloning.
β’ Financial Data Domains: Architect data flows specific to investment firms (e.g., trade lifecycles, Benchmarks, Cash, Transactions, and Performance).
β’ Cloud & DevOps Integration: Collaborate on CI/CD pipelines, automated testing, and data Lakehouse or streaming interoperability (e.g., using Databricks, DBT, Apache Airflow).
β’ AI & Advanced Analytics: Leverage built-in Snowflake machine learning capabilities (like Snowflake Cortex AI) to supplement and automate human-based data validation.
Typical Qualifications & Experience
β’ Experience: 10+ years in enterprise-scale cloud engineering, data platform engineering, or solution architecture, with 5+ years specifically focused on Snowflake development.
β’ Industry Knowledge: Deep expertise in financial services data domains. Prior experience with OMS platforms (like Charles River Development or Aladdin) is typically highly preferred.
β’ Technical Skills: Advanced SQL, hands-on experience with ETL/ELT pipelines, and cloud-native integration paradigms.
Thanks & Regards,
Anil Andraju
Email ID: anil.a@oriontekinc.com
We have an opening for Snowflake Architect at Boston, MA for Long-term Contract with one of our clients. Please review the job description below and let me know at your earliest convenience if youβre interested.
Job Title: Snowflake Architect
Location: Boston, MA
Duration: Long-term Contract
Key Responsibilities:
β’ Platform Architecture: Define and scale cloud-native architectures that interface Snowflake with AWS or Azure cloud platforms.
β’ Data Modeling & Pipelines: Design high-volume relational and complex data models capable of handling real-time streaming and batch ingestion.
β’ Governance & Performance: Implement advanced Snowflake features like RBAC (Role-Based Access Control), virtual warehouse sizing, micro-partitioning, query profiling, and zero-copy cloning.
β’ Financial Data Domains: Architect data flows specific to investment firms (e.g., trade lifecycles, Benchmarks, Cash, Transactions, and Performance).
β’ Cloud & DevOps Integration: Collaborate on CI/CD pipelines, automated testing, and data Lakehouse or streaming interoperability (e.g., using Databricks, DBT, Apache Airflow).
β’ AI & Advanced Analytics: Leverage built-in Snowflake machine learning capabilities (like Snowflake Cortex AI) to supplement and automate human-based data validation.
Typical Qualifications & Experience
β’ Experience: 10+ years in enterprise-scale cloud engineering, data platform engineering, or solution architecture, with 5+ years specifically focused on Snowflake development.
β’ Industry Knowledge: Deep expertise in financial services data domains. Prior experience with OMS platforms (like Charles River Development or Aladdin) is typically highly preferred.
β’ Technical Skills: Advanced SQL, hands-on experience with ETL/ELT pipelines, and cloud-native integration paradigms.
Thanks & Regards,
Anil Andraju
Email ID: anil.a@oriontekinc.com





