Macpower Digital Assets Edge
Product Architect (Snowflake Cloud Data Warehouse Architect)
Macpower Digital Assets Edge, Dublin, Ohio, United States, 43016
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.
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.