CBTS · 1 day ago
Snowflake Developer (Greenfield)
United States
Contract
Remote
Mid Level
$75/hr - $79/hr
3+ years exp
Maximize your interview chancesCloud ComputingCloud Infrastructure
Hiring Manager
Jason P.
Insider Connection @CBTS
Get 3x more responses when you reach out via email instead of LinkedIn.
Responsibilities
• Greenfield - Setup and Configuration of Snowflake in the cloud
Stand-up a new Snowflake cloud environment (Greenfield) from scratch in the cloud. Provide strategy, design and implementation of Snowflake cloud solution.
• Design & Develop Data Solutions:
Develop scalable and efficient data models, tables, and views in Snowflake, ensuring the performance and reliability of data solutions.
• ETL/ELT Process Development:
Design and implement ETL/ELT pipelines to extract, transform, and load data into Snowflake from various sources (e.g., APIs, databases, flat files). Optimize data flows for performance and scalability.
• Snowflake Data Modeling:
Develop and maintain dimensional and relational data models in Snowflake, ensuring proper indexing, partitioning, and optimization techniques are applied.
• Performance Optimization:
Monitor and optimize Snowflake queries and database performance using techniques like clustering, materialized views, and query optimization strategies. Address performance bottlenecks and improve overall efficiency.
• Data Transformation:
Write and optimize complex SQL queries to transform data for reporting and analytics. Ensure proper use of Snowflake’s features, such as time travel, zero-copy cloning, and multi-cluster warehouses.
• Integration with Other Tools:
Integrate Snowflake with various third-party tools, data lakes, and data warehouses (e.g., AWS S3, Azure Blob Storage, Google Cloud Storage). Use data integration platforms like Matillion, Talend, or Informatica for data workflows.
• Collaboration with Teams:
Collaborate with data engineers, analysts, and stakeholders to gather requirements, define solutions, and deliver high-quality, scalable data products.
• Data Governance & Security:
Implement data governance practices by managing user roles, access controls, and security policies in Snowflake. Ensure compliance with data privacy regulations and internal standards.
• Testing & Debugging:
Develop unit and integration tests for Snowflake data processes to ensure data quality and reliability. Identify and troubleshoot data issues and bugs effectively.
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
MUST HAVE experience setting up Snowflake in the cloud. Must be able to Stand-up Snowflake from scratch designing solution for set-up and configuration.
Proven experience in developing and managing data solutions in Snowflake, including creating databases, schemas, tables, stages, file formats, and virtual warehouses.
Strong SQL development skills, with experience writing and optimizing complex queries, stored procedures, and user-defined functions (UDFs).
Experience with ETL/ELT tools like Matillion, Talend, Informatica, or Apache NiFi. Experience with cloud-based ETL processes is a plus.
Strong understanding of cloud platforms (AWS, Azure, Google Cloud) and their integration with Snowflake, particularly cloud storage services (e.g., S3, Azure Blob, Google Cloud Storage).
Proficiency in scripting languages like Python, JavaScript, or Bash for data automation, orchestration, and integration tasks.
Experience in optimizing Snowflake resources and queries to improve system performance and reduce costs.
Strong background in data warehousing principles, dimensional modeling, and best practices for managing large datasets.
Familiarity with version control systems (e.g., Git) and experience in integrating Snowflake development processes with CI/CD pipelines.
Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field.
3+ years of experience working as a Snowflake Developer or in a similar role, developing cloud-based data solutions.
Strong analytical and problem-solving skills, with the ability to work independently and as part of a team.
Excellent communication skills to effectively collaborate with technical and non-technical stakeholders.
Attention to detail, with a strong focus on data accuracy and performance optimization.
Ability to manage multiple priorities and work in a fast-paced, dynamic environment.
Preferred
Snowflake certification (e.g., SnowPro Core) or cloud certifications (AWS Certified Solutions Architect, Azure Data Engineer, etc.) are a plus.
Knowledge of business intelligence tools like Tableau, Power BI, or Looker and their integration with Snowflake.
Exposure to big data tools (e.g., Hadoop, Spark) and experience with integrating Snowflake into data lake environments is advantageous.
Familiarity with Agile development methodologies and experience working in an Agile environment.
Company
CBTS
CBTS provides end-to-end IT and communications solutions that allow businesses to improve efficiency, enable innovation, and mitigate risk.
1,001-5,000 employees
H1B Sponsorship
CBTS 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
2020 (1)
Funding
Current Stage
Late StageTotal Funding
unknown2024-02-06Acquired· undefined
Leadership Team
Phil Clark
SVP, National Territory Sales
Randy Barnhardt
SVP, Service Provider and Global Account Sales
Recent News
Cincinnati Business Courier
2024-02-18
Company data provided by crunchbase
