View all jobs
Data Architect - Snowflake
Remote, CanadaTitle: Data Architect - Snowflake
As a Data Architect (Snowflake), you will work directly with our strategic clients on key initiatives. You will have the opportunity to build an in-depth understanding of their business issues and implement organizational strategies that drive adoption of change. We are looking for experts, with broad and deep expertise in the Data Management and Analytics space with a focus on Snowflake as well as strong experience in consultative selling, who can build credibility and trust with our clients and provide knowledge that addresses individual and unique business needs.
We are one of the largest data focused services company in North America and provides both professional and managed services and expertise in Database Management, Application Development and Management, Cloud & Infrastructure Management, Packaged Applications and BI/Analytics
Must have total 12+ yrs. in IT and 3+ years' experience working as a snowflake Data Architect and 8+ years in Data warehouse, ETL, BI projects. Preferably SSIS or Informatica.
Who are we LOOKING for
The ideal Data Architect for this opening is an experienced technology architect with strong business acumen. You are as comfortable working with a technical team as you are with client business leaders (C-Suite and down) and you know how to build bridges between the two. With your excellent communications skills, you are adept at mapping business needs to technology solutions and helping non-technical audiences understand the benefits of these solutions.
As a Data Architect (Snowflake), you will work directly with our strategic clients on key initiatives. You will have the opportunity to build an in-depth understanding of their business issues and implement organizational strategies that drive adoption of change. We are looking for experts, with broad and deep expertise in the Data Management and Analytics space with a focus on Snowflake as well as strong experience in consultative selling, who can build credibility and trust with our clients and provide knowledge that addresses individual and unique business needs.
We are one of the largest data focused services company in North America and provides both professional and managed services and expertise in Database Management, Application Development and Management, Cloud & Infrastructure Management, Packaged Applications and BI/Analytics
Must have total 12+ yrs. in IT and 3+ years' experience working as a snowflake Data Architect and 8+ years in Data warehouse, ETL, BI projects. Preferably SSIS or Informatica.
Who are we LOOKING for
The ideal Data Architect for this opening is an experienced technology architect with strong business acumen. You are as comfortable working with a technical team as you are with client business leaders (C-Suite and down) and you know how to build bridges between the two. With your excellent communications skills, you are adept at mapping business needs to technology solutions and helping non-technical audiences understand the benefits of these solutions.
- Expertise in Snowflake – data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts
- Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understand how to use these features
- Expertise in deploying Snowflake features such as data sharing, events and lake-house patterns
- Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using Python
- Should have good SQL scripting skills(TSQL or PLSQL).
- Experience in Data Migration from RDBMS to Snowflake cloud data warehouse
- Deep understanding of relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modelling)
- Experience with data security and data access controls and design
- Experience with AWS or Azure data storage and management technologies such as S3 and ADLS
- Build processes supporting data transformation, data structures, metadata, dependency and workload management
- Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning and troubleshoot
- Provide resolution to an extensive range of complicated data pipeline related problems, proactively and as issues surface
- Must have expertise in AWS or Azure Platform as a Service (PAAS).
- Certified Snowflake cloud data warehouse Architect (Desirable).
- Should be able to troubleshoot problems across infrastructure, platform and application domains.
- Must have experience of Agile development methodologies
- Strong written communication skills. Is effective and persuasive in both written and oral communication.