As part of our Enterprise Data and Analytics initiative, we are looking for a consultant Snowflake data architect who is an expert with Snowflake and has the ability to architect Snowflake data mart, work with our Internal technology team as well as the Data Engineering team to implement a data mart solution.
The Data and analytics organization is on the third year of our data initiative Ethos. We are in the process of standing up the technology and building a new data mart using Snowflake. We are looking for a Snowflake Data Architect with experience designing a new Data Warehouse/data mart. The project involves building a new data mart for our Enterprise Risk department, enabling the business to bring in new external data sets via Snowflake Marketplace and or other sites and finally be able to implement risk models in R/Python with this snowflake DataMart. The team is currently working as a Microsoft shop with both on prem and Azure SQL database and pipelines using ETL (Azure Data Factory).
· Lead and support our infrastructure team to architect, configure and implement Snowflake.
· Integrate Snowflake with our existing technologies such as Microsoft Azure, Azure SQL Database, Tableau.
· Import at least 1 external dataset (Probably S&P Global) using Snowflake marketplace.
· Create Datamart for our internal Enterprise Risk Management department.
· Enable R/Python modeling with Snowpark
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to
HR@insightglobal.com.
To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy:
https://insightglobal.com/workforce-privacy-policy/ .
- Strong experience with multiple snowflake implementations as an architect
* Snowflake experience with Marketplace, Snowpark, Snowpipe, and external tables
- Experience integrating with Azure
- Experience designing a new data warehouse/data mart
Soft Skills: Strong technical communication skills, Self Starter, Ability to work in ambiguous environments, Providing most efficient, secure and sustainable solution after weighing out all the options based on all the resources available at the bank and outside the bank. Providing solutions in a reasonable time.
- Experience coaching and educating a team on Snowflake adoption
- Experience in banking or financial industry
- Experience in a highly regulated and secure environment
- Agile experience
- Theoretical knowledge of Microsoft Azure & Azure SQ Database
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.