Product Architect (Snowflake Cloud Data Warehouse Architect) NEW

Dublin, Ohio
Macpower Digital Assets Edge Private Limited
Job Description Job Description 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.