Product Architect Snowflake cloud data warehouse Dublin, OH

ESR Healthcare; Dublin (OH); On-site; USD 80,000 - 120,000; Full time

Job summary

An innovative firm is seeking a skilled Product Architect specializing in Snowflake cloud data warehousing. This role requires extensive experience in data modeling, ELT processes, and implementing complex stored procedures, along with strong communication skills. You will be responsible for data migration, building solution architectures, and supporting data transformation processes. The ideal candidate will have a solid understanding of both structured and semi-structured data and experience with cloud storage technologies like AWS and Azure. Join a forward-thinking team where your expertise will drive impactful solutions in the healthcare domain.

Qualifications

• 10+ years of experience in data architecture and cloud data warehousing.
• Expertise in Snowflake and data migration from RDBMS to cloud.

Responsibilities

• Implement complex stored procedures and standard DWH and ETL concepts.
• Coordinate with teams during project execution and represent as architect.

Skills

Data modelling

ELT using Snowflake

Complex stored procedures

Data Migration from RDBMS

Agile development methodologies

Strong written communication skills

Healthcare domain experience

Education

Bachelor’s degree

Tools

Snowflake

AWS

Azure

Job description

Product Architect Snowflake cloud data warehouse Dublin, OH

Snowflake cloud data warehouse, Data modelling, ELT using Snowflake, implementing complex stored procedures and standard DWH and ETL concepts.

Experience level: Mid-senior

Experience required: 10 Years

Education level: Bachelor’s degree

Job function: Information Technology

Industry: Information Technology and Services

Pay rate: View hourly pay rate

Total position: 1

Relocation assistance: No

Visa sponsorship eligibility: No

Must have experience with at least two end-to-end implementations of Snowflake cloud data warehouse.

Job Description:

1. Expertise in Data modelling, ELT using Snowflake, implementing complex stored procedures and standard DWH and ETL concepts.
2. Experience in Data Migration from RDBMS to cloud data warehouse.
3. Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, zero copy clone, time travel, and understanding how to use these features.
4. Experience in Data Masking & Security features of Snowflake.
5. Experience in handling Structured & semi-structured data (JSON, XML).
6. Experience with AWS or Azure data storage and management technologies such as S3 and ADLS.
7. Must have experience with Agile development methodologies.
8. Strong written communication skills. Is effective and persuasive in both written and oral communication.
9. Exposure or expertise working in the healthcare domain will be an added advantage.
10. Study as and TO planning along with TCS and customer stakeholders.
11. Build solution architecture, design, reviews.
12. Build processes supporting data transformation, data structures, metadata, dependency, and workload management.
13. Implementation of this architecture.
14. Provide resolution to an extensive range of data pipeline-related problems, proactively and as issues surface.
15. Work with development team and customer teams during the entire execution.
16. Represent as architect to customer on various forums during the lifecycle of the project.
17. Co-ordinate with offshore team during project execution.