Likeremote

Subscribe to the latest remote jobs:

  • Likeremote jobs on https://LinkedIn.com/
  • Likeremote jobs on https://telegram.org/
  • Likeremote jobs on Reddit.com
MD

Product Architect (Snowflake Cloud Data Warehouse Architect)

Macpower Digital Assets Edge Private Limited
🇮🇪 Ireland | 🇺🇸 United States
On-site
Staff / Principal
5 days ago
$60 / hour
  • Snowflake
  • ELT
  • RBAC
  • JSON
  • XML
  • AWS
  • Azure
  • Agile
  • Data Modeling
  • ETL
5 days ago
Auto apply with Likeremote
Not scoredNo CV on file. Upload one and this job gets a score out of 100.Upload CV
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.

Product Architect (Snowflake Cloud Data Warehouse Architect) · Macpower Digital Assets Edge Private Limited

Auto apply with Likeremote