Data Warehouse Architect

Datawarehouse Architect role

• Lead and Architect migration of data analytics environment from SAP BW/HANA to Snowflake with performance and reliability.

• Assess and understand the ETL jobs, workflows, BI tools and reports

• Based on the findings from the assessment, define a high level roadmap for migration to Snowflake on AWS/Azure along with a future state reference architecture on AWS cloud

• Responsible for end-to-end data analytics design and architecture for Snowflake in AWS.

• Improve existing data pipelines in cloud for data transformation and aggregation.

• Address a majority of technical inquiries concerning customization, integration, enterprise architecture and general feature / functionality of Snowflake

• Setup, configure and deploy Snowflake

• Guide the team to handle configurations for multiple departments/groups within single environment stack.

• Lead data analytics team for implementing the standard methodologies.

• Enable partners to make key decisions with accurate data analysis, reports and presentations of key findings.

• Snowflake Solution Architect with expertise in Design, and Implementation of highly scalable, highly available, Cloud (IaaS, PaaS, and SaaS) services and solutions.

• Proven Experience in crafting Database / Data warehouse solutions in cloud (Preferably AWS, Alternatively Azure, GCP).

• Familiar with SAP ECC, SAP BW/HANA, Retail Industry

• Key must have skill sets – Snowflake, AWS, Python, SQL

Required Qualifications

• Bachelor’s Degree in Engineering or relevant field

• 10+ years of success in consultative/sophisticated deployment project, architecture, design, implementation and/or support of data and analytics solutions

• Hands on development Design and Develop applications using Snowflake

• In depth understanding of Snowflake Architecture including Snow SQL, Performance tuning, Compute and Storage

• Expertise in using Spark SQL with various data sources like JSON, Parquet and Key Value Pair.

• Experience in creating tables, partitioning, bucketing, loading and aggregating data using Snowflake

• Analytical and problem-solving skills.

• Acute attention to detail.

We are committed to affirmatively providing equal opportunity to all associates and qualified applicants without regard to race, color, ancestry, national origin, religion, sex, marital status, age, sexual orientation, gender identity or expression, legally protected physical or mental disability or any other basis protected under applicable law.