Product Architect (Snowflake Cloud Data Warehouse Architect)

Macpower Digital Assets Edge Private Limited

Dublin, OH

JOB DETAILS
SALARY
$60–$60 Per Hour
SKILLS
Access Control, Agile Programming Methodologies, Amazon Simple Storage Service (S3), Amazon Web Services (AWS), Architectural Services, Best Practices, Cloning, Cloud Architecture, Cloud Computing, Communication Skills, Data Management, Data Migration, Data Modeling, Data Processing, Data Storage, Data Warehousing, Database Extract Transform and Load (ETL), Healthcare, Identify Issues, Information/Data Security (InfoSec), JSON, Metadata, Microsoft Windows Azure, Offshoring, Performance Tuning/Optimization, Presentation/Verbal Skills, Process Development, Process Modeling, Project Development, Project Execution, Relational Databases (RDBMS), Snowflake Schema, Software Engineering, Stored Procedures, Structured Data, Warehousing, Writing Skills, XML (EXtensible Markup Language)
LOCATION
Dublin, OH
POSTED
11 days ago
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.

About the Company

M

Macpower Digital Assets Edge Private Limited