Position: Snowflake Architect
Duration: 12+ months
Location: Naperville, IL
Primary Skills: AWS, Lambda, snowflake, S3,AWS Airbyte, DBT, looker
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, high-performance data architectures on the Snowflake cloud data platform to meet the evolving business needs and data growth.
• Lead the implementation of Snowflake-based 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 large-scale datasets.
• Implement and maintain robust data security practices, including data encryption, role-based 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 end-to-end 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?
• Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.
• Proven experience as a Snowflake Architect or similar role, with a focus on cloud-based data solutions.
• In-depth 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 experience 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.
• Hands-on 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, problem-solving, and communication skills.
• Ability to work collaboratively in a team environment and interact with stakeholders at all levels of the organization.