The specialist will design and implement data extraction and loading solutions using Snowflake, lead a team, and ensure solution efficiency.
This is a remote position.
The Snowflake Data Acquisition and Integration Specialist will be responsible for the design and implementation of the data extract and load with Snowflake as the target data sink. This role will extract data from numerous 3rd party data platforms, including cloud SaaS API and on-premise sources. The candidate will work closely with the solution architect and data architect to implement a high-performing data platform that fulfills the requirements of the business. They will lead a team of developers through the implementation, deployment, and enhancement of analytics solutions.
Requirements
Responsibilities:
- Support the analytics solution in data extract and load solution delivery
- Translate functional specifications and business requirements into architectural designs that include complex data models and front-end visualizations
- Propose and implement potential improvements for existing integration patterns
- Maintain data extract and load programs
- Select appropriated technology components to realize solution designs
- Anticipate future data needs in solution designs and reference architecture
- Ensure accurate and up-to-date project and solution life cycle documentation
Who you are:
- 5+ years of experience with data extract and load integration patterns
- 3+ years of experience with the Snowflake data platform
- 3+ years of experience with Snowflake data integration patterns
- 3+ years of experience with Python
- 2+ years of experience with Dell Boomi
- 2+ years AWS Data
- 5+ years of SQL experience
- 2+ years SAP BODS
- 2+ years SAP SLT (Landscape Transformation Replication Server)
- Experience with orchestration tools such as Redwood
- Experience with Power BI a plus
Similar Jobs
Artificial Intelligence • Information Technology • Consulting • Big Data Analytics
The Snowflake Data Acquisition and Integration Specialist designs and implements data extraction and loading solutions, works with various data platforms, and enhances analytics solutions.
Top Skills:
AWSDell BoomiGitPythonRedwoodSap BodsSnowflakeSQL
Aerospace • Information Technology • Software • Cybersecurity • Design • Defense • Manufacturing
Operate and maintain Insitu unmanned aircraft systems, conduct preflight planning and mission briefings, collect and analyze flight data, perform troubleshooting and field maintenance, coordinate with customers and subject-matter experts, manage spares inventory, and deploy worldwide in austere environments to support customer missions.
Top Skills:
Basic NetworkingIntegratorRq21ScaneagleUas Platforms
Aerospace • Information Technology • Software • Cybersecurity • Design • Defense • Manufacturing
Operate and maintain Insitu unmanned aircraft systems, plan and execute missions, collect/analyze payload and video data, perform pre/post-flight checks and maintenance, support customers in field deployments, and complete inventory and mission reporting. Deployable to remote/austere locations up to 70% travel.
Top Skills:
Basic NetworkingIntegratorRq21ScaneagleUas
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
