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.
a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; }
Job Summary
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.
- 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
- 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
- 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).
- Experience working with one or more cloud platforms:
- AWS
- Azure
- Google Cloud Platform (GCP)
- Experience with Python or Java for data processing and automation.
- Familiarity with Snowpark development using Python or Java.
Experience with one or more of the following:
- Informatica
- Matillion
- Talend
- Azure Data Factory (ADF)
- Airflow
- dbt
- 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.
- Snowflake Certification.
- Experience with Databricks.
- Apache Spark.
- Kafka/Event Streaming.
- Data Lake Architecture.
- Terraform or Infrastructure as Code (IaC).
- Machine Learning data preparation workloads.
- Strong Analytical and Problem-Solving Skills
- Data Modeling Expertise
- Database Performance Tuning
- Stakeholder Communication
- Attention to Detail
- Collaboration and Teamwork
- Agile Mindset
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
- Python
- Snowpark
- dbt
- Airflow
- Databricks
- CI/CD Pipeline Experience
Compensation, Benefits and Duration
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
Photon Chicago, Illinois, USA Office
11 East Adams Street Suite 1100, Chicago, IL, United States, 60603
Similar Jobs
.png)
eCommerce • Fintech • Hardware • Payments • Software • Financial Services
Field-driven full-cycle sales role owning a geographic territory: prospecting door-to-door, running demos, closing deals across Square products, building local partnerships, and maintaining pipeline and Salesforce rigor to consistently exceed quota.
Top Skills:
AfterpaySalesforceSquare
Artificial Intelligence • Information Technology • Professional Services • Software • Analytics • Generative AI • Big Data Analytics
Leads QA strategy and testing for Adobe Experience Manager projects, including functional, automation, API, accessibility, UI/UX, integration, regression, and release testing. Manages test planning, case reviews, defect lifecycle, quality metrics, and release sign-offs while mentoring QA engineers. Validates AEM Sites, Assets, Forms, workflows, Dispatcher, integrations, and responsive experiences. Integrates automated testing into CI/CD pipelines and collaborates with developers, designers, architects, and stakeholders to improve product quality and compliance.
Top Skills:
Accessibility InsightsAdaAdobe AnalyticsAdobe CommerceAdobe Experience Manager (Aem)Adobe LaunchAdobe TargetAndiAxeAzure DevopsBrowser Developer ToolsConfluenceCypressFigmaGitGraphQLJenkinsJIRAJmeterLighthouseLoadrunnerNvdaPlaywrightPostmanRest AssuredSeleniumSQLWaveWcag 2.1/2.2
Cloud • Security • Software • Cybersecurity • Automation
Owns GitLab’s enterprise pricing, packaging, monetization, and commercialization strategy. Develops pricing programs, enterprise agreements, bundling, channel and cloud marketplace structures, discounting frameworks, and competitive deal plays. Partners with Product, Sales, Finance, Marketing, Deal Desk, Revenue Operations, and partners to implement scalable commercial programs. Creates pricing enablement materials, makes data-backed recommendations, influences senior stakeholders, and documents decisions in an asynchronous, globally distributed environment.
Top Skills:
Ai AgentsAutomationAWSGitlabGoogle Cloud PlatformAzure
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
