The Snowflake Data Acquisition and Integration Specialist designs and implements data extraction and loading solutions, works with various data platforms, and enhances analytics solutions.
This is a remote position.
The Snowflake Data Acquisition and Integration Specialist will be responsible for designing and implementing 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 be part of a team of developers through implementing, deploying, and enhancing analytics solutions.
Requirements
Responsibilities:
- Support the analytics solution in data extract and load solution delivery
- Translate functional specifications and business requirements into technical 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
- Contribute to the team's knowledge by providing guidance, conducting code reviews, and sharing expertise.
Skills:
Must Have
- 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 AWS Data Lake Reference Architecture
- 5+ years of SQL experience
- 2+ years with GitHub or similar CI/CD processes
Nice to Have
- 2+ years SAP BODS
- 2+ years of experience with Dell Boomi
- 2+ years SAP SLT (Landscape Transformation Replication Server)
- Experience with orchestration tools such as Redwood
Similar Jobs
Artificial Intelligence • Information Technology • Consulting • Big Data Analytics
The specialist will design and implement data extraction and loading solutions using Snowflake, lead a team, and ensure solution efficiency.
Top Skills:
Aws DataDell BoomiPower BIPythonRedwoodSap BodsSap SltSnowflakeSQL
.png)
eCommerce • Fintech • Hardware • Payments • Software • Financial Services
Lead end-to-end delivery of high-priority, cross-functional Revenue initiatives including product and partnership launches. Develop integrated program plans, establish governance and operating cadences, drive cross-functional alignment, manage risks and dependencies, and create repeatable launch frameworks and executive communications to ensure successful market readiness and post-launch stabilization.
Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
Lead buy- and sell-side Quality of Earnings engagements: analyze financials, assess earnings quality, working capital, and net debt; prepare diligence reports and presentations; manage VDRs; mentor junior staff; support valuation, deal structuring, integration planning, and business development.
Top Skills:
ExcelFinancial DatabasesVirtual Data Rooms
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
