Job Details

ID #20236926
State Texas
City Dallas / fort worth
Job type Permanent
Salary USD Depends on Experience Depends on Experience
Source Photon Infotech
Showed 2021-09-25
Date 2021-09-17
Deadline 2021-11-15
Category Et cetera
Create resume

Data Architect - Snowflake

Texas, Dallas / fort worth, 75201 Dallas / fort worth USA

Vacancy expired!

Greetings everyone,

I hope you are staying safe. We are hiring a Data Architect with Snowflake experience to join our Digital Engineering team.

Who are we?

For the past 20 years, we have powered many Digital Experiences for the Fortune 500. Since 1999, we have grown from a few people to more than 4000 team members across the globe that are engaged in various Digital Modernization. For a brief 1 minute video about us, you can check https://youtu.be/uJWBWQZEA6o.

What do we need?
  • Demonstrated ability to have successfully completed multiple, complex technical projects and create high-level design and architecture of the solution, including class, sequence and deployment infrastructure diagrams.
  • Take ownership of technical solutions from design and architecture perspective for projects in presales phase as well as on-going projects.
  • Prior experience with application delivery using an Onshore/Offshore model
  • Experience with gathering end user requirements and writing technical documentation
  • Time management and multitasking skills to effectively meet deadlines under time-to-market pressure
  • Suggest innovative solutions based on new technologies and latest trends to sales team.
  • Review the architectural/ technological solutions for ongoing projects and ensure right choice of solution.
  • Work closely with sales team and clients to understand their business, capture requirements, identify pain areas, accordingly, propose an ideal solution and win business.

What are we looking for?
  • Must have experience working as

    a snowflake Data Architect
  • Must have experience at least two end to end implementation of

    Snowflake cloud data warehouse and end to end data warehouse implementations on-premise preferably on Oracle.
  • 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
  • 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
If you are interested, I would love to talk to you about our company and the opportunity. Otherwise, I thank you for your time and I wish you a great day. Stay safe. Regards,Jacob

Vacancy expired!

Subscribe Report job