Apex Informatics, a management consulting firm, is seeking a skilled Snowflake Cloud Data Warehouse Architect to join our team. The ideal candidate will have extensive experience designing and implementing scalable data warehouse solutions using Snowflake on a cloud platform. As our Snowflake Cloud Data Warehouse Architect, you will work closely with our clients to identify opportunities to optimize their data analytics capabilities and develop customized solutions to meet their unique business needs.

You will have the opportunity to work with a team of highly skilled consultants and data scientists across a wide range of industries, ensuring that you stay at the forefront of industry trends and technology advancements.

Responsibilities

• Design and develop end-to-end data architectures, including data modeling, data preparation, ETL processes and visualization reporting
• Create and implement scalable data warehouse solutions using Snowflake on a cloud platform, demonstrating a deep understanding of data architecture best practices
• Collaborate with cross-functional teams to identify and define data requirements, ensuring alignment with business objectives
• Provide leadership in the design, implementation, and maintenance of data flow processes, reviewing project deliverables to ensure data architecture guidelines are met
• Develop technical documentation and perform system testing to ensure accuracy and completeness
• Translate complex business requirements into technical specifications, ensuring data architecture solutions are designed to meet business needs
• Stay current on industry trends, best practices, and technologies related to data architecture and analytics

Requirements

• Proven experience as a Snowflake Cloud Data Warehouse Architect, with at least 5 years of experience designing and implementing data architectures, ETL processes and visualization reporting using Snowflake on a cloud platform
• Strong skills and experience with SQL, data modelling, ETL techniques, and data quality standards
• Experience in object-oriented programming languages
• Excellent understanding of Data Warehousing, Data Lake and IoT concepts and technologies
• Strong business acumen and the ability to translate complex business requirements into technical specifications
• Excellent communication skills with the ability to collaborate with both technical and non-technical stakeholders
• A Bachelor's Degree in Computer Science, Information Systems or related field
• Around 10+ Years of Experience in Data Warehouse Architecture with One End-to-End Implementation of Snowflake Cloud Data Warehouse.
• Expertise in Snowflake Data Modeling. Snowflake Architecture experience in designing and developing projects.
• Must have strong working experience in writing Oracle complex SQL queries and PL/SQL programming.
• Should have good working knowledge in Unix Shell scripting, Understand ETL, primarily Informatica Cloud, for data engineering.
• Create technical design and architecture documents.
• Provide guidance to developers in software design and development including review