Lead design and implementation of Snowflake data warehouse solutions; oversee ETL/ELT pipelines (Airflow, DBT Cloud) into Snowflake; implement data security; and maintain documentation including data models, ETL workflows, and system configurations.
This is a remote position.
- Lead the design and implementation of Snowflake data warehouse solutions, ensuring scalability, performance, and security.
- Oversee the development and maintenance of ETL pipelines for extracting, transforming, and loading data into Snowflake.
- Implement robust security measures to protect sensitive data within Snowflake.
- Maintain technical documentation, including data models, ETL workflows, and system configurations.
Requirements
- 12+ years minimum and 7+ with Snowflake is a Must
- Must have Snowflake, DBT Cloud, Airflow, Finance Background, Data Modeling, and Dimensional Modeling.
- Strong knowledge of cloud data warehouse in particular Snowflake
- Strong knowledge in Airflow (MWAA)
- Strong Knowledge on DBT Cloud
- Expertise in Snowflake - data modeling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts
N/A. This is a remote contract job.
Similar Jobs
Machine Learning • Security • Software • Analytics • Defense
Plan and execute internal audits, perform risk assessments and detailed testing of financial and operational controls, identify weaknesses and recommend corrective actions, prepare audit documentation and reports, collaborate with departments to implement recommendations, support internal audit planning, perform analytics, leverage technology to improve controls, and participate in special projects while staying current with regulatory and industry best practices.
.png)
Fintech • Insurance • Machine Learning • Analytics • Financial Services • Automation
Manage workers' compensation claims end-to-end for California: investigate, determine compensability, set reserves, administer benefits, control litigation, negotiate settlements, and provide claims guidance to agents and insureds while ensuring regulatory compliance and excellent customer service.
Top Skills:
Google SuiteSlack
Fintech • Social Impact • Financial Services
Support People Ops programs by coordinating employee events, internal communications, recognition, and benefits administration. Manage vendor processes, analyze engagement feedback, support open enrollment and benefits operations, and provide logistical support for in-person and virtual company initiatives.
Top Skills:
AdobeCanvaGoogle SheetsGoogle SlidesExcelPowerPoint
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
