What are the responsibilities and job description for the Product Architect (Snowflake Cloud Data Warehouse Architect) position at Macpower Digital Assets Edge formerly MDA Edge?
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
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.
- 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.
Salary : $60