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
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
Lead enterprise-scale ServiceNow transformation deals by co-designing North Star operating models, driving executive alignment, architecting platform strategy across workflow, intelligence, and governance, and partnering with pursuit, product, and delivery teams to convert discovery into long-term transformation roadmaps.
Top Skills:
AIAPIsBusiness Process AutomationCmdbCsmData GovernanceEnterprise ArchitectureFsmGrcIntegration PatternsItomItsmServicenowServicenow IntelligenceWorkflow Orchestration
Artificial Intelligence • Cloud • Consumer Web • Productivity • Software • App development • Data Privacy
Lead high-visibility AI-focused design initiatives: define opportunities, own projects end-to-end, execute interaction and visual design, simplify complex workflows, shape design strategy, collaborate with Product and Engineering, influence stakeholders, and use generative AI for exploration and prototyping.
Top Skills:
Generative Ai
Computer Vision • Digital Media • Kids + Family • Mobile • Software • Sports
Manage and grow the Video Enablement engineering team, own core video pipeline (ingest, transcode, storage, playback), enable third-party device integrations, collaborate on video roadmap, ensure scalable resilient AWS infrastructure, mentor engineers, contribute technically when needed, and support production incidents and cross-team enablement.
Top Skills:
AWSC#GoGoproKotlinLive StreamingMevoNode.jsPlaybackReactRustSwiftTranscodingTypescriptVideo IngestVod
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
