Product Architect (Snowflake Cloud Data Warehouse Architect)
Automate your job search with Sonara.
Submit 10x as many applications with less effort than one manual application.1
Reclaim your time by letting our AI handle the grunt work of job searching.
We continuously scan millions of openings to find your top matches.
Overview
Remote
On-site
Compensation
$60-$60/hour
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.
Automate your job search with Sonara.
Submit 10x as many applications with less effort than one manual application.
FAQs About Product Architect (Snowflake Cloud Data Warehouse Architect) Jobs at Macpower Digital Assets Edge Private Limited
What is the work location for this position at Macpower Digital Assets Edge Private Limited?
This job at Macpower Digital Assets Edge Private Limited is located in Dublin, OH, according to the details provided by the employer. Some roles may also include multiple work locations depending on the requirement.
What pay range can candidates expect for this role at Macpower Digital Assets Edge Private Limited?
Candidates can expect a pay range of $60–$60 per hour for this role.
What employment applies to this position at Macpower Digital Assets Edge Private Limited?
The employer has not provided this information. This may be discussed during the hiring process.
What is the process to apply for this position at Macpower Digital Assets Edge Private Limited?
You can apply for this role at Macpower Digital Assets Edge Private Limited either through Sonara's automated application system, which helps you submit applications 10X faster with minimal effort, or by applying manually using the direct link on the job page.