IntellectFaces, Inc ยท 8 hours ago
Snowflake Developer
Denver, CO
Contract
Remote
Mid Level
Maximize your interview chancesConsultingInformation Technology
Hiring Manager
Rajah kaleeswaran
Insider Connection @IntellectFaces, Inc
Get 3x more responses when you reach out via email instead of LinkedIn.
Responsibilities
Collaborate with data architects to design and develop Snowflake data models and schemas.
Create and maintain a well-structured data warehouse and data lake architecture.
Develop ETL (Extract, Transform, Load) processes to ingest data from various sources into Snowflake.
Ensure data integration processes are efficient, reliable, and scalable.
Design and implement data pipelines using Snowflake features like tasks and streams.
Able to Code using Python, Pyspark, Scala as needed.
Knowledge in Java a plus.
At least one project experience in On-prem to Snow flake or any Cloud migration.
Optimize query performance by creating and maintaining appropriate indexes, materialized views, and clustering keys.
Identify and resolve performance bottlenecks in data processing.
Write complex SQL queries, stored procedures, and user-defined functions (UDFs) to support data analytics and reporting needs.
Ensure SQL code follows best practices for readability and performance.
Implement and manage security measures, including role-based access control (RBAC) and data encryption, to protect sensitive data.
Audit and monitor data access and user activities.
Define and implement data quality checks and validation processes to maintain data accuracy.
Establish data quality rules and alerts to proactively identify issues.
Create and maintain technical documentation for data models, ETL processes, and data dictionaries.
Document best practices, standards, and guidelines for Snowflake development.
Use version control systems (e.g., Git) for managing Snowflake SQL scripts and objects.
Coordinate the deployment of changes to Snowflake environments.
Set up monitoring and alerting for Snowflake environments to proactively detect and respond to issues.
Troubleshoot and resolve incidents related to data processing and performance.
Implement backup and recovery strategies to ensure data integrity and availability.
Develop and test data recovery procedures.
Collaborate with data engineers, and business analysts to understand data requirements and provide data solutions.
Work with cross-functional teams to support data-related projects and initiatives.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
Highly skilled professional responsible for designing, implementing, and optimizing data solutions using the Snowflake cloud data platform.
Collaborate with data architects to design and develop Snowflake data models and schemas.
Create and maintain a well-structured data warehouse and data lake architecture.
Develop ETL (Extract, Transform, Load) processes to ingest data from various sources into Snowflake.
Ensure data integration processes are efficient, reliable, and scalable.
Design and implement data pipelines using Snowflake features like tasks and streams.
Able to Code using Python, Pyspark, Scala as needed.
At least one project experience in On-prem to Snowflake or any Cloud migration.
Optimize query performance by creating and maintaining appropriate indexes, materialized views, and clustering keys.
Identify and resolve performance bottlenecks in data processing.
Write complex SQL queries, stored procedures, and user-defined functions (UDFs) to support data analytics and reporting needs.
Ensure SQL code follows best practices for readability and performance.
Implement and manage security measures, including role-based access control (RBAC) and data encryption, to protect sensitive data.
Audit and monitor data access and user activities.
Define and implement data quality checks and validation processes to maintain data accuracy.
Establish data quality rules and alerts to proactively identify issues.
Create and maintain technical documentation for data models, ETL processes, and data dictionaries.
Document best practices, standards, and guidelines for Snowflake development.
Use version control systems (e.g., Git) for managing Snowflake SQL scripts and objects.
Coordinate the deployment of changes to Snowflake environments.
Set up monitoring and alerting for Snowflake environments to proactively detect and respond to issues.
Troubleshoot and resolve incidents related to data processing and performance.
Implement backup and recovery strategies to ensure data integrity and availability.
Develop and test data recovery procedures.
Collaborate with data engineers, and business analysts to understand data requirements and provide data solutions.
Work with cross-functional teams to support data-related projects and initiatives.
Preferred
USC and GC are preferred
Knowledge in Java a plus
Company
IntellectFaces, Inc
At IntellectFaces, we specialize in providing state-of-the-art technology solutions and expert consulting services.
Founded in 2011
51-200 employees
H1B Sponsorship
IntellectFaces, Inc has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2023 (1)
2022 (1)
Funding
Current Stage
Growth StageCompany data provided by crunchbase
