Job Description

Description:

Who are we looking for?

We are looking for experienced Snowflake Consultants to join our delivery team. This is an exciting opportunity to work for a growing, ambitious company.

Working across a variety of cloud environments, your role is to turn business ideas into full data architectures on either existing or new enterprise developments. The ideal candidate has a deep technical knowledge of modern data architecture, Snowflake Cloud Data Platform, and possesses a desire and passion for supporting other members of the team.

You will act as a subject matter expert involved in a variety of projects. You will be someone who enjoys working with a team and mentoring others. You will work with our clients and suppliers to understand requirements and to help them to understand Mphasis Datalytyx solutions. You will attend workshops and meetings to provide support to existing customers.

You will be someone who thrives in identifying challenges and delivering improvements, thinks analytically and has great communication skills . You will work pro-actively to increase knowledge of the business beyond the delivery team, including how our commercial and production teams work.

You will have worked in a similar role before and are looking to expand your experience and expertise, building on your ideas and experience from previous roles. You will work hard to ensure the correct underlying architecture is in place for other teams to build their solutions upon. This will include keeping up to date with the latest ideas and technologies and introducing them to Mphasis Datalytyx where appropriate.

You will have a solid grounding in Computer Science and Software Engineering principles, either from a formal education background or through extensive experience in your career. As well as being technically strong, you will also have an understanding of business and how our work within the delivery team contributes to the success of the business as a whole.

Technical Skills:

At least 3 years’ experience within Data & Analytics

At least 2 year’s experience using DBT and Python

Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using Python

A background in SQL and principles of data warehousing

Experience of ETL design and dev, including Test-Driven development.

Snowflake design and engineering experience and certification plus exposure to one of either Azure, AWS or GCP

Experience in end-to-end implementation of Snowflake cloud data warehouse and end to end data warehouse implementations on-premise

Expertise in Snowflake – data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts

Deep understanding of relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modelling)

Some of the activities that you will engage in include:

Build processes supporting data transformation, data structures, metadata, dependency and workload management

Write SQL statements and Schema design / dimensional data modeling.

Implement Snowflake ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts

Delivery of Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning

Deploy Snowflake features such as data sharing, events and lake-house patterns

Manage Snowflake utilities such as SnowSQL, SnowPipe, Big Data model techniques using Python

Delivery of Data Migration from Legacy DW platforms to Snowflake cloud data warehouse

Implement data security and data access controls and design

Ensure scalability and high availability, fault tolerance, and elasticity within the data systems we deploy

Work with common version-control systems such as GIT or VSTS

Stay current with vendor/product roadmaps and make recommendations for adoption

Maintain a customer-focused attitude.

Desirable:

Experience of programming languages including Object-Oriented language (.Net. Java, C, Python)

GIT experience

Good knowledge of DevOps / DataOps principles with working knowledge of Docker and Linux

Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning

Expertise in deploying Snowflake features such as data sharing, events and lake-house patterns.

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

A track record of achievement and recognition within the IT industry as evidenced by significant promotion since leaving University.

A strong academic track record including the achievement of a good honours degree or equivalent.

Process Skills:

Working in an agile methodology environment

Administration and ensuring that adequate security procedures are developed

Handling large sets of data and be able to confidently process them into required formats

Provide technical input and effective data analysis to projects

Assessing and defining Data Design strategy

Ability to conduct workshops / training programs / support with all questions on Snowflake to clients / end users

Experience in consulting or working with large enterprise clients

Expertise in communicating requirements and data needs to technical teammates

Behavioral Skills:

Ability to work independently and adapt your style to rapid organisational and software changes

Ability to switch gears quickly and work in a fast-paced start-up culture.

Consultative approach

Excellent written and verbal communication skills

Analytical and Structured approach to work

Participates as a team member and fosters teamwork by inter-group coordination within the scope of the role.

Effectively collaborates and communicates with all stakeholders to ensure client satisfaction.

Trains and coach members of project groups to ensure effective knowledge management activity.

Certification:

Snowpro Core

Snowpro Advanced desirable

Job Type: Full-time

Salary: $100,000.00 - $120,000.00 per year

Benefits:

• Health insurance

Schedule:

• Monday to Friday

Supplemental pay types:

• Signing bonus

Ability to commute/relocate:

• New York, NY 10027: Reliably commute or planning to relocate before starting work (Required)

Work Location: One location

Speak with the employer
+91 9196513292

Similar Jobs