Saxon Global
Snowflake Consultant w/d DBT and Python Exp
Saxon Global, New York, New York, us, 10261
Hi
Hope you are doing good.
We are looking for Snowflake Consultant w/d DBT and Python Exp. This is a full time/ contract position. Please check the job description and reply to me if you are available for this position.
Title: Snowflake Consultant w/d DBT and Python Exp
Location: New York City, NY
Duration: Full Time/ Contract
Technical Skills:
Essential
At least 3 years' experience within Data & AnalyticsAt least 2 year's experience using DBT and PythonHands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using PythonA background in SQL and principles of data warehousingExperience 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 GCPExperience in end-to-end implementation of Snowflake cloud data warehouse and end to end data warehouse implementations on-premiseExpertise in Snowflake - data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL conceptsDeep understanding of relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modelling)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 managementWrite SQL statements and Schema design / dimensional data modeling.Implement Snowflake ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL conceptsDelivery of Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuningDeploy Snowflake features such as data sharing, events and lake-house patternsManage Snowflake utilities such as SnowSQL, SnowPipe, Big Data model techniques using PythonDelivery of Data Migration from Legacy DW platforms to Snowflake cloud data warehouseImplement data security and data access controls and designEnsure scalability and high availability, fault tolerance, and elasticity within the data systems we deployWork with common version-control systems such as GIT or VSTSStay current with vendor/product roadmaps and make recommendations for adoptionMaintain a customer-focused attitude.Desirable:
Experience of programming languages including Object-Oriented language (.Net. Java, C, Python)GIT experienceGood knowledge of DevOps / DataOps principles with working knowledge of Docker and LinuxExpertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuningExpertise in deploying Snowflake features such as data sharing, events and lake-house patterns.Experience with data security and data access controls and designExperience with AWS or Azure data storage and management technologies such as S3 and ADLSA 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 environmentAdministration and ensuring that adequate security procedures are developedHandling large sets of data and be able to confidently process them into required formatsProvide technical input and effective data analysis to projectsAssessing and defining Data Design strategyAbility to conduct workshops / training programs / support with all questions on Snowflake to clients / end usersExperience in consulting or working with large enterprise clientsExpertise in communicating requirements and data needs to technical teammatesBehavioral Skills:
Ability to work independently and adapt your style to rapid organisational and software changesAbility to switch gears quickly and work in a fast-paced start-up culture.Consultative approachExcellent written and verbal communication skillsAnalytical and Structured approach to workParticipates 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 CoreSnowpro Advanced desirable
Thanks and Regards,
Manish Kumar
P: 972-430-7053 Email:
manish.k@saxonglobal.com
Linkedin:
linkedin.com/in/manishtechie14
Suite # 660 1320 Greenway Drive, Irving, TX 75038
Website:
https://saxonglobal.com/
Hope you are doing good.
We are looking for Snowflake Consultant w/d DBT and Python Exp. This is a full time/ contract position. Please check the job description and reply to me if you are available for this position.
Title: Snowflake Consultant w/d DBT and Python Exp
Location: New York City, NY
Duration: Full Time/ Contract
Technical Skills:
Essential
At least 3 years' experience within Data & AnalyticsAt least 2 year's experience using DBT and PythonHands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using PythonA background in SQL and principles of data warehousingExperience 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 GCPExperience in end-to-end implementation of Snowflake cloud data warehouse and end to end data warehouse implementations on-premiseExpertise in Snowflake - data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL conceptsDeep understanding of relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modelling)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 managementWrite SQL statements and Schema design / dimensional data modeling.Implement Snowflake ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL conceptsDelivery of Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuningDeploy Snowflake features such as data sharing, events and lake-house patternsManage Snowflake utilities such as SnowSQL, SnowPipe, Big Data model techniques using PythonDelivery of Data Migration from Legacy DW platforms to Snowflake cloud data warehouseImplement data security and data access controls and designEnsure scalability and high availability, fault tolerance, and elasticity within the data systems we deployWork with common version-control systems such as GIT or VSTSStay current with vendor/product roadmaps and make recommendations for adoptionMaintain a customer-focused attitude.Desirable:
Experience of programming languages including Object-Oriented language (.Net. Java, C, Python)GIT experienceGood knowledge of DevOps / DataOps principles with working knowledge of Docker and LinuxExpertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuningExpertise in deploying Snowflake features such as data sharing, events and lake-house patterns.Experience with data security and data access controls and designExperience with AWS or Azure data storage and management technologies such as S3 and ADLSA 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 environmentAdministration and ensuring that adequate security procedures are developedHandling large sets of data and be able to confidently process them into required formatsProvide technical input and effective data analysis to projectsAssessing and defining Data Design strategyAbility to conduct workshops / training programs / support with all questions on Snowflake to clients / end usersExperience in consulting or working with large enterprise clientsExpertise in communicating requirements and data needs to technical teammatesBehavioral Skills:
Ability to work independently and adapt your style to rapid organisational and software changesAbility to switch gears quickly and work in a fast-paced start-up culture.Consultative approachExcellent written and verbal communication skillsAnalytical and Structured approach to workParticipates 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 CoreSnowpro Advanced desirable
Thanks and Regards,
Manish Kumar
P: 972-430-7053 Email:
manish.k@saxonglobal.com
Linkedin:
linkedin.com/in/manishtechie14
Suite # 660 1320 Greenway Drive, Irving, TX 75038
Website:
https://saxonglobal.com/