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
Artificial Intelligence • Productivity • Sales • Software
Serve as a technical Customer Success Manager advising B2B clients on AI-led transformation using monday.com's platform. Drive adoption, design scalable automated solutions, lead technical workshops, use product usage data to identify expansion opportunities, and represent customer needs to Product and Engineering.
Top Skills:
APIsGenerative AiMonday.Com
Fintech • Mobile • Payments • Software • Financial Services
Provide multi-channel technical support for enterprise API partners, diagnose and debug REST APIs, interpret logs and query databases, respond to high-severity incidents, collaborate with engineering and product teams, and capture partner issue trends to improve the platform.
Top Skills:
DatabasesJavaScriptPythonRest ApisSwift
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


