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
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Leads commercial auto risk control for complex, high-premium accounts. Conducts risk surveys, partners with underwriting and claims, coaches consultants and clients, develops training curriculum, evaluates service quality, analyzes risk and industry data, applies AI insights, and delivers driver coaching and fleet management resources. The role also monitors commercial auto, telematics, mobility, and autonomous vehicle trends while influencing risk control strategy and procedures.
Top Skills:
AIFmcsa SmsMS OfficeTelematics
Big Data • Information Technology • Software • Analytics • Energy
Handle incoming owner relations inquiries about revenue, land, division orders, JIB, A/R, and A&P. Log and follow up cases in a tracking system, build trusting client relationships, manage difficult situations calmly, provide accurate timely responses, and participate in cross-training.
Top Skills:
MS Office
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
