Product Architect (Snowflake Cloud Data Warehouse Architect)

Company : Macpower Digital Assets Edge

Location : Dublin, OH

Posted Date : 10 October 2025

Job Type : Other

Category : Architecture

Occupation : Architect

Job Details

Job Description: We are seeking an experienced Snowflake Cloud Data Warehouse Architect to lead end-to-end implementations, data migrations, and architectural solutions. The ideal candidate should have deep expertise in Snowflake, ELT processes, and cloud data management.
Key Responsibilities:

Design and implement end-to-end Snowflake Cloud Data Warehouse solutions.
Develop and optimize data models, ELT processes, and complex stored procedures.
Migrate data from RDBMS to cloud data warehouse environments.
Implement advanced Snowflake features such as resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, zero-copy cloning, and time travel.
Ensure data security through data masking and Snowflake security best practices.
Handle structured and semi-structured data (JSON, XML) efficiently.
Work with AWS or Azure storage solutions, including S3 and ADLS.
Follow Agile development methodologies for project execution.
Collaborate with stakeholders, including customer teams, to plan and design solutions.
Develop processes supporting data transformation, metadata management, and workload optimization.
Troubleshoot and resolve data pipeline-related challenges proactively.
Represent architectural solutions in customer forums and coordinate with offshore teams.

Must-Have Qualifications:

Minimum 10+ years of experience in data engineering and cloud data solutions.
At least two full-cycle implementations of Snowflake Cloud Data Warehouse.
Expertise in Snowflake ELT, Data Modeling, DWH, and ETL concepts .
Strong experience in data migration from traditional RDBMS to cloud data warehouse.
In-depth knowledge of Snowflake advanced features , including query performance tuning and access controls.
Experience in data masking and security implementation in Snowflake.
Familiarity with handling structured and semi-structured data (JSON, XML).
Hands-on experience with AWS or Azure data storage technologies like S3 and ADLS.
Strong proficiency in Agile development methodologies .
Excellent written and verbal communication skills .
Healthcare domain experience is a plus.