Data Architect - Snowflake DataOps/Devops
Fulltime only
Location DC or remote ( ready to relocate after COVID)
Open for H1 transfer.
Snowflake Consultant Job 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.
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
• Perform Talend code reviews to make sure they follow the established standards and best practices
• Stay current with vendor/product roadmaps and make recommendations for adoption
• Maintain a customer-focused attitude.
Technical Skills:
Essential
• At least 3 years’ experience within Data & Analytics
• 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
• Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using Python
• Deep understanding of relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modelling)
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
• Hands on experience with DBT
• 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