Product Architect (Snowflake Cloud Data Warehouse Architect)

Macpower Digital Assets Edge Private Limited

Dublin, OH

$60 Per Hour
Instant Apply

30+ days ago

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.

Numbers & Facts

Location	Dublin, OH
Salary	$60 Per Hour

Skills

Access Controlunmatched
Agile Programming Methodologiesunmatched
Amazon Simple Storage Service (S3)unmatched
Amazon Web Services (AWS)unmatched
Architectural Servicesunmatched
Best Practicesunmatched
Cloningunmatched
Cloud Architectureunmatched
Cloud Computingunmatched
Communication Skillsunmatched
Data Managementunmatched
Data Migrationunmatched
Data Modelingunmatched
Data Processingunmatched
Data Storageunmatched
Data Warehousingunmatched
Database Extract Transform and Load (ETL)unmatched
Healthcareunmatched
Identify Issuesunmatched
Information/Data Security (InfoSec)unmatched
JSONunmatched
Metadataunmatched
Microsoft Windows Azureunmatched
Offshoringunmatched
Performance Tuning/Optimizationunmatched
Presentation/Verbal Skillsunmatched
Process Developmentunmatched
Process Modelingunmatched
Project Developmentunmatched
Project Executionunmatched
Relational Databases (RDBMS)unmatched
Snowflake Schemaunmatched
Software Engineeringunmatched
Stored Proceduresunmatched
Structured Dataunmatched
Warehousingunmatched
Writing Skillsunmatched
XML (EXtensible Markup Language)unmatched

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Resume Builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Resume Builder