What are the responsibilities and job description for the Product Architect position at Gulf Coast Automation Group?
Experience level: Mid-senior
Experience required: 10 Years
Education level: Bachelors degree
Job function: Information Technology
Industry: Information Technology and Services
Relocation assistance: No
Visa sponsorship eligibility: No
Must have experience in at least two end-to-end implementations of Snowflake cloud data warehouse.
Job Description:
Expertise in Data modeling, ELT using Snowflake, implementing complex stored Procedures, and standard DWH and ETL concepts.
Experience in Data Migration from RDBMS to cloud data warehouse
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. Experience in Data Masking & Security features of Snowflake
Experience in handling Structured & semi-structured data (JSON, XML)
Experience with AWS or Azure data storage and management technologies such as S3 and ADLS
Must have experience with Agile development methodologies.
Strong written communication skills. Is effective and persuasive in both written and oral communication.
Exposure or expertise working in the healthcare domain will be an added advantage.10 Years
Build solution architecture, design, and reviews
Build processes supporting data transformation, data structures, metadata, dependency, and workload management.
Implementation of this architecture:
Provide resolution to an extensive range of data pipeline-related problems, proactively and as issues surface.
Working with the development team, and customer teams during the entire execution.
Representations as an architect to the customer on various forums during the lifecycle of the project.
Coordination with the offshore team during project execution.
