Randstad
snowflake data architect
Randstad, Spring, Texas, us, 77391
snowflake data architect.
spring , texas
posted september 10, 2024
job details
summary
$57 - $66.50 per hour
contract
no requirements
category computer and mathematical occupations
reference1065157
job details
job summary:
Work Location: ONSITE - Spring, TX
Required:
Snowflake Architecture experience in designing and architecting Snowflake projects
Expertise in Snowflake Data Modeling ELT using Snowflake SQL implementing stored procedures and standard DWHETL concepts
Clear understanding of Snowflakes advanced concepts like virtual warehouses query performance using micro partitions and pruning zero copy clone time travel resource monitors n security control methods including network data role based etc
Proficient with data platform architecture design data dictionaries multidimensional models objects star and snowflake schemas as well as structures for data lakes data science and data warehouses using Snowflake Responsibilities will also include technical delivery review resolution of architecture issues and for the migration of the existing onpremises application to AWSAzure Snowflake platform
Demonstrate expertise in Snowflake data modeling and ELT using Snowflake SQL implementing complex stored procedures and best practices with data warehouse and ETL concepts
Have a solid understanding of delivery methodology and lead teams in the implementation of the solution according to the design architecture
Hands-on experience with Snowflake utilities such as SnowSQL, SnowPipe, Python, Tasks, Streams, Time travel Optimizer Metadata Manager data sharing and stored procedures
Indepth understanding of Data WarehouseODS ETL concept and modeling structure principles
Experience in Data warehousing OLTP OLAP Dimensions Facts and Data modeling
Experience gathering and analyzing system requirements
Good working knowledge of any ETL tool
Ability to effectively function in a cross teams environment
location: Spring, Texas
job type: Contract
salary: $57.00 - 66.50 per hour
work hours: 8am to 4pm
education: No Degree Required
responsibilities:
The Snowflake Architect Should Develop analytics based solutions that produce quantitative and qualitative business insights Work with partners as necessary to integrate systems and data quickly and effectively regardless of technical challenges or business environments
Lead effort to design build n configure applications acting as primary POC
Own end to end RFP or RFI or Proactive proposals client presentations n solution workshop Contribute in area ie estimation building PoVs offerings development training and capability building
Client facing role in term of running solution workshops client visits handled large RFP pursuits n managed multiple stakeholders
Deploy fully operational data warehouse solutions into production on Snowflake
Perform project management activities including project documentation business requirements and project tracking
Snowflake SQL Writing SQL queries against Snowflake Developing scripts Unix Python etc to do Extract Load and Transform data
qualifications:
Experience level: Experienced
Minimum 3 years of experience
Education: No Degree Required
skills:
Snowflake
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).
This posting is open for thirty (30) days.
spring , texas
posted september 10, 2024
job details
summary
$57 - $66.50 per hour
contract
no requirements
category computer and mathematical occupations
reference1065157
job details
job summary:
Work Location: ONSITE - Spring, TX
Required:
Snowflake Architecture experience in designing and architecting Snowflake projects
Expertise in Snowflake Data Modeling ELT using Snowflake SQL implementing stored procedures and standard DWHETL concepts
Clear understanding of Snowflakes advanced concepts like virtual warehouses query performance using micro partitions and pruning zero copy clone time travel resource monitors n security control methods including network data role based etc
Proficient with data platform architecture design data dictionaries multidimensional models objects star and snowflake schemas as well as structures for data lakes data science and data warehouses using Snowflake Responsibilities will also include technical delivery review resolution of architecture issues and for the migration of the existing onpremises application to AWSAzure Snowflake platform
Demonstrate expertise in Snowflake data modeling and ELT using Snowflake SQL implementing complex stored procedures and best practices with data warehouse and ETL concepts
Have a solid understanding of delivery methodology and lead teams in the implementation of the solution according to the design architecture
Hands-on experience with Snowflake utilities such as SnowSQL, SnowPipe, Python, Tasks, Streams, Time travel Optimizer Metadata Manager data sharing and stored procedures
Indepth understanding of Data WarehouseODS ETL concept and modeling structure principles
Experience in Data warehousing OLTP OLAP Dimensions Facts and Data modeling
Experience gathering and analyzing system requirements
Good working knowledge of any ETL tool
Ability to effectively function in a cross teams environment
location: Spring, Texas
job type: Contract
salary: $57.00 - 66.50 per hour
work hours: 8am to 4pm
education: No Degree Required
responsibilities:
The Snowflake Architect Should Develop analytics based solutions that produce quantitative and qualitative business insights Work with partners as necessary to integrate systems and data quickly and effectively regardless of technical challenges or business environments
Lead effort to design build n configure applications acting as primary POC
Own end to end RFP or RFI or Proactive proposals client presentations n solution workshop Contribute in area ie estimation building PoVs offerings development training and capability building
Client facing role in term of running solution workshops client visits handled large RFP pursuits n managed multiple stakeholders
Deploy fully operational data warehouse solutions into production on Snowflake
Perform project management activities including project documentation business requirements and project tracking
Snowflake SQL Writing SQL queries against Snowflake Developing scripts Unix Python etc to do Extract Load and Transform data
qualifications:
Experience level: Experienced
Minimum 3 years of experience
Education: No Degree Required
skills:
Snowflake
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).
This posting is open for thirty (30) days.