Data Architect - Google Cloud Platform Strategic HR Solutions

About Strategic HR Solutions

Job Description

Role : Data Architect Roles And Responsibilities 10+ years of relevant work experience, including previous experience leading Data related projects in the field of Reporting and Analytics. Design, build & maintain scalable data lake and data warehouse in cloud (GCP) Expertise in gathering business requirements, analysing business needs, defining the BI/DW architecture to support and help deliver technical solutions to complex business and technical requirements Creating solution prototype and participating in technology selection. Perform POC and technical presentations Architect, develop and test scalable data warehouses and data pipelines architecture in Cloud Technologies (GCP) Experience in SQL and No SQL DBMS like MS SQL Server, MySQL, PostgreSQL, DynamoDB, Cassandra, MongoDB. Design and develop scalable ETL processes, including error handling. Expert in Query and program languages MS SQL Server, T-SQL, PostgreSQL, MY SQL, Python, R. Preparing data structures for advanced analytics and self-service reporting using MS SQL, SSIS, SSRS Write scripts for stored procedures, database snapshots backups and data archiving. Experience with any of these cloud-based technologies : PowerBI/Tableau, Azure Data Factory, Azure Synapse, Azure Data Lake AWS RedShift, Glue, Athena, AWS Quicksight Google Cloud Platform Good To Have Agile development environment pairing DevOps with CI/CD pipelines AI/ML background (ref:hirist.tech),