Snowflake Data Architect

Merrill Corporation•Minneapolis, MN

42d•Remote

About The Position

At Datasite, we empower dealmakers around the world with cutting-edge technology that simplifies complex transactions. Our Data & Analytics team is central to this mission - building scalable, secure, and intelligent data platforms that drive insight, innovation, and data-driven decision-making across the business. We are seeking a hands-on Snowflake Data Architect with deep expertise in designing, building, and maintaining scalable data architecture solutions. This role blends technical leadership with solution delivery, supporting business intelligence, advanced analytics, and enterprise data strategy. You'll work in a fast-paced, product-driven environment, architecting modern data ecosystems and helping shape Datasite's cloud-native data platform. Experience with Microsoft Fabric or equivalent Lakehouse architectures, and a deep interest in emerging data platforms is a strong plus.

Requirements

5+ years of proven expertise in Snowflake architecture, development, and administration.
Strong proficiency in data warehouse architecture and lifecycle management.
Extensive experience in data modeling and designing scalable data warehouses.
Strong interpersonal and communication skills with the ability to work cross functionally with various groups.

Nice To Haves

Experience in Microsoft Fabric or equivalent and Lakehouse architecture in unified analytics.
Hands-on experience with ELT/ETL tools and workflow automation (e.g., dbt, Matillion, Airflow).
Experience with CI/CD processes and DevOps practices in data environments.
Experience integrating data from platforms like Salesforce and Workday.
Exposure to non-relational databases and modern data structures (e.g., MongoDB, NoSQL).

Responsibilities

Architect and implement scalable, secure, and high-performance data solutions using Snowflake.
Design and maintain robust data models, ELT/ETL pipelines, and data integration frameworks.
Collaborate cross-functionally with data engineers, analysts, and business stakeholders to translate business needs into technical designs.
Optimize Snowflake usage for performance, cost efficiency, and scalability.
Lead data migration initiatives from legacy systems to Snowflake.
Coordinate with the Data Governance team to ensure data quality, lineage, documentation, and compliance.
Monitor, troubleshoot, and resolve data issues to ensure availability, reliability, and accuracy across platforms.