Snowflake Developer - II

We are seeking a skilled Snowflake Developer - II to join our Data Engineering team. The ideal candidate will be responsible for designing, developing, optimizing, and maintaining data solutions on the Snowflake Cloud Data Platform. The role involves building scalable data pipelines, data warehouses, ETL/ELT processes, and ensuring efficient data integration from multiple sources.

The candidate should have strong expertise in Snowflake, SQL, data modeling, cloud technologies, and modern data engineering practices. This role requires close collaboration with business stakeholders, data architects, analysts, and engineering teams to deliver high-quality, data-driven solutions. Key Responsibilities

• Design, develop, and maintain scalable data warehouse solutions using Snowflake.
• Build and optimize ETL/ELT pipelines for loading and transforming large datasets.
• Develop and maintain data models, schemas, and database objects.
• Implement data integration processes from multiple on-premises and cloud sources.
• Optimize Snowflake performance through query tuning, clustering, partitioning, and warehouse management.
• Develop data transformation logic using SQL, Snowflake Stored Procedures, and Snowpark.
• Collaborate with Data Engineers, Analysts, and Business Teams to understand data requirements.
• Monitor, troubleshoot, and resolve data-related issues.
• Ensure data quality, governance, security, and compliance standards are maintained.
• Support production deployments and perform root cause analysis for data issues.
• Automate data workflows and orchestration processes.
• Contribute to data architecture and best practice initiatives., Lead customer implementations of SOPHiA GENETICS genomic analysis solutions, from planning and sample selection through configuration, training, adoption, and issue resolution. Manage MaxCare Program schedules, timelines, sampling strategies, Statements of Work, technical setup, and cross-functional delivery. Translate laboratory, bioinformatics, data, and clinical regulatory requirements into practical solutions while building trusted customer relationships. The field-based US role includes approximately 30% travel. Top Skills: BioinformaticsCustom ReportingFederated Sso AuthenticationLibrary PreparationNext-Generation SequencingSophia Ddm Platform PNC Bank

Software Engineer

2 Hours Ago Remote or Hybrid USA 75K-150K Annually Junior 75K-150K Annually Junior Machine Learning * Payments * Security * Software * Financial Services Develops, tests, deploys, maintains, and debugs software across the full project lifecycle. Translates business requirements into technical designs, supports production systems, documents solutions, estimates development tasks, collaborates with teammates, and mentors newer developers. The role requires application architecture, SDLC, testing, troubleshooting, and maintenance experience using Java, .NET, and/or Delphi, with Delphi preferred. Top Skills: .NetDelphiJava PNC Bank

Senior Software Engineer

2 Hours Ago Remote or Hybrid USA Senior level Senior level Machine Learning * Payments * Security * Software * Financial Services Designs, develops, tests, deploys, maintains, and debugs software solutions. Leads complex technical initiatives, Java microservices and API integration, OpenShift deployments, server and database administration, release management, production support, vulnerability remediation, incident resolution, and vendor coordination. Supports remote deposit platforms while managing application resiliency, security compliance, documentation, and stakeholder communication. Top Skills: AgileAPIsCandescent Remote Deposit/CaptureCloud-Native ArchitecturesConnect:DirectContainerizationDevOpsJavaLinuxMicroservicesMicrosoft Sql ServerOpenshift Container PlatformPowershellPythonSdlcShell ScriptingWindows Server

What you need to know about the Colorado Tech Scene

With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.

Key Facts About Colorado Tech

• Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
• Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
• Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
• Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
• Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
• Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute

• Strong hands-on experience with Snowflake Data Cloud.
• Expertise in Snowflake Architecture, Virtual Warehouses, Databases, Schemas, and Stages.
• Experience with Snowflake Features such as:
• Snowpipe
• Streams & Tasks
• Time Travel
• Zero Copy Cloning
• Secure Data Sharing
• Materialized Views
• Snowpark

SQL & Data Warehousing

• Strong proficiency in SQL and query optimization.
• Experience designing and implementing Data Warehouse solutions.
• Strong knowledge of Data Modeling concepts:
• Star Schema
• Snowflake Schema
• Dimension Modeling
• Fact Tables

ETL/ELT Development

• Experience building ETL/ELT pipelines.
• Hands-on experience with data ingestion and transformation frameworks.
• Experience handling structured and semi-structured data (JSON, XML, Parquet, Avro).

Cloud Platforms

• Experience working with one or more cloud platforms:
• AWS
• Azure
• Google Cloud Platform (GCP)

Programming

• Experience with Python or Java for data processing and automation.
• Familiarity with Snowpark development using Python or Java.

Data Integration Tools

Experience with one or more of the following:

• Informatica
• Matillion
• Talend
• Azure Data Factory (ADF)
• Airflow
• dbt

Preferred Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or related field.
• 4+ years of experience in Data Engineering.
• 2+ years of hands-on Snowflake development experience.
• Experience working in Agile/Scrum environments.
• Knowledge of CI/CD practices and DevOps methodologies.

Nice to Have

• Snowflake Certification.
• Experience with Databricks.
• Apache Spark.
• Kafka/Event Streaming.
• Data Lake Architecture.
• Terraform or Infrastructure as Code (IaC).
• Machine Learning data preparation workloads.

Key Competencies

• Strong Analytical and Problem-Solving Skills
• Data Modeling Expertise
• Database Performance Tuning
• Stakeholder Communication
• Attention to Detail
• Collaboration and Teamwork
• Agile Mindset

Experience:

4 to 8 Years Employment Type:

Full-Time Mandatory Skills:

• Snowflake
• SQL
• Data Warehousing
• ETL/ELT Development
• Cloud Platform (AWS/Azure/GCP)
• Data Modeling
• Performance Optimization

Good to Have:

• Python
• Snowpark
• dbt
• Airflow
• Databricks
• CI/CD Pipeline Experience

Posted 9 Hours Ago In-Office or Remote Hiring Remotely in United States 37K-132K Annually Mid level In-Office or Remote Hiring Remotely in United States 37K-132K Annually Mid level Develop and maintain scalable Snowflake data warehouses, ETL/ELT pipelines, data models, and integrations across cloud and on-premises sources. Optimize queries, clustering, partitioning, and warehouse performance; implement transformations using SQL, stored procedures, and Snowpark. Monitor data quality, governance, security, deployments, and production issues. Collaborate with engineers, architects, analysts, and business stakeholders while automating workflows and contributing to data architecture and best practices. The summary above was generated by AI, Minimum Compensation: USD 37,000 Maximum Compensation: USD 132,000 Compensation is based on actual experience and qualifications of the candidate. The above is a reasonable and a good faith estimate for the role. Medical, vision, and dental benefits, 401k retirement plan, variable pay/incentives, paid time off, and paid holidays are available for full time employees. This position is not available for independent contractors No applications will be considered if received more than 120 days after the date of this post