Sign upLog in
See more jobs

Product Architect (Snowflake Cloud Data Warehouse Architect)

Macpower Digital Assets Edge Private Limited

  • Dublin, OH
  • 19 days ago
  • $60 Per Hour

Highlights

Job Description: We are seeking an experienced Snowflake Cloud Data Warehouse Architect to lead end-to-end implementations, data migrations, and architectural solutions. Implement advanced Snowflake features such as resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, zero-copy cloning, and time travel.

Numbers & Facts

LocationDublin, OH
Salary$60 Per Hour

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.

Similar Jobs

See more jobs