Job Title: Apptad Snowflake Architect
Job Location: Las Vegas NV
Job Duration: LongTerm
Job Description:
- Snow Pro certificate Mandatory for this role
- 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
- Snow Flake Data Architect Cloud Platform.
- 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 SnowPipe 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.