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
Cloud • Information Technology • Security • Software • Cybersecurity
Drive automation-first reliability for a global, multi-cloud platform: build scalable infra (AWS/GCP/bare-metal), write automation (Python/Go), implement observability (Prometheus/Grafana/OpenTelemetry), lead incident response/on-call, define SLIs/SLOs, and partner on operability reviews and post-incident analysis.
Top Skills:
AnsibleAWSAzureBgpC/C++DnsGCPGoGrafanaGreHaproxyHelmIpsecItilLinuxOpentelemetryPrometheusPythonRhelTemporalTerraform
Aerospace • Hardware • Information Technology • Security • Software • Cybersecurity • Defense
Lead supplier quality for Printed Wiring Boards: audit suppliers, perform source and first-article inspections, drive root-cause analysis and corrective actions, implement process improvements, and ensure compliance with PWB and aerospace standards to deliver first-time quality.
Top Skills:
ApqpAs9100As9102Asme Y14.5Asme Y15.1Black BeltControl PlanFirst Article InspectionGreen BeltIpc-6012Ipc-6013Ipc-6018Ipc-A-600Ipc-A-610Ipc-Tm-650Lean Six SigmaMil-Prf-31032Mil-Prf-38534Mil-Prf-55110Mil-Std-883PfmeaPpapSource Inspection
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
