Job Title: Data Architect (Snowflake)
Location: Las Vegas NV (Onsite)
Contract
We are seeking a Snowflake Architect to play a crucial role in designing implementing and maintaining our clients data platforms using the Snowflake cloud data platform Informatica cloud Azure and Oracle.
What will you do
-
Design and develop scalable highperformance data architectures on the Snowflake cloud data platform to meet the evolving business needs and data growth.
-
Lead the implementation of Snowflakebased data solutions including data modeling schema design and data integration pipelines.
-
Optimize data storage data retrieval and query performance in Snowflake to ensure the efficient processing of largescale datasets.
-
Implement and maintain robust data security practices including data encryption rolebased access controls and data privacy measures to safeguard sensitive information.
-
Develop and maintain documentation of the data architecture data flow and data models of the data warehouse appropriate for various audiences.
-
Provide direction on adoption of Cloud technologies (Snowflake) and industry best practices in the field of data warehouse architecture and modelling.
-
Take ownership of technical solutions from design and architecture perspective for projects in presales phase as well as on going projects
-
Design endtoend data integration architectures using Informatica considering data sources data transformation data mapping and data delivery to meet business objectives.
-
Possess a deep understanding of the Informatica platform including PowerCenter Data Quality Master Data Management and Informatica Cloud and leverage its capabilities to design efficient and scalable data solutions.
-
Collaborate with data engineers and data analysts to define data mappings transformation rules and data workflows to ensure data accuracy and consistency.
-
Lead and participate in the development of ETL/ELT workflows using Informatica tools optimizing data extraction loading and transformation processes.
What are we looking for
-
Bachelors or Masters degree in Computer Science Information Systems or a related field.
-
Proven experience as a Data Architect or similar role with a focus on cloudbased data solutions.
-
Indepth knowledge of Snowflake cloud data platform and its components such as Virtual Warehouses Snowflake Data Sharing etc.
-
Indepth knowledge of Informatica PowerCenter Informatica Cloud Informatica Data Quality and other Informatica products.
-
Experience establishing data quality processes performing data analysis participating in technology implementation planning implementing data integration processes.
-
Expertise in Snowflake data modeling in star snowflake and data vault 2.0 ELT using Snow Pipe implementing stored procedures and standard DWH and ETL concepts.
-
Create and maintain documentation of the data architecture flow and models of the data warehouse for various stakeholders.
-
Handson experience in data modeling data integration and ETL/ELT processes.
-
Design and implement scalable and streamlined data pipelines to address key business use cases and to meet data SLA requirements.
-
Proficiency in SQL and other data querying languages.
-
Collaborate with data engineers and analysts to establish data mappings transformation rules and workflows for ensuring data accuracy and consistency.
-
Experience in Data Migration to Snowflake cloud data warehouse.
-
Strong understanding of data governance data security and data management best practices.
-
Experience with cloud infrastructure and services preferably AWS or Azure.
-
Excellent analytical problemsolving and communication skills.
-
Ability to work collaboratively in a team environment and interact with stakeholders at all levels of the organization.