Snowflake Architect

2 weeks ago

Naperville, United States Delta System and Software Inc. Full time
Location Naperville IL. This position requires the consultant to work onsite in Napervile IL as the position will work HYBRID. Non local consultants are OK as long as they are willing to relocate to Naperville IL. Duration Over 12 months Start Date ASAP Visa Status All OK. Citizens GC GC EAD (will highly prefer GC EAD candidates to join us directly) H1B and TN Visa all OK. NO OPT/CPT EAD

Job Summary:

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 AWS Cloud and Looker.

Responsibilities

  • 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 considering data sources data transformation data mapping and data delivery.
  • Lead and participate in the development of ETL/ELT workflows 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 Snowflake 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.
  • Must have strong experience AWS AirByte DBT AWS S3 AWS Lambda
  • Must have experoence in Looker BI
  • 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 AWS cloud infrastructure and services preferably.
  • Excellent analytical problemsolving and communication skills.
  • Ability to work collaboratively in a team environment and interact with stakeholders at all levels of the organization.