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 • Fintech • Information Technology • Logistics • Payments • Business Intelligence • Generative AI
Lead RevOps data modeling, ETL/DBT development on Snowflake, SQL-based analytics, and Tableau reporting. Optimize and maintain RevOps systems (Salesforce, Clari, Outreach, Gong/Chorus), ensure data quality, apply advanced analytics/AI concepts for forecasting, and partner cross-functionally to deliver actionable revenue insights.
Top Skills:
Ai/MlChorusClariDbtGongOutreachRevenue IntelligenceSalesforceSnowflakeSQLTableau
Artificial Intelligence • Fintech • Information Technology • Logistics • Payments • Business Intelligence • Generative AI
Lead RevOps data modeling, ETL/DBT development, and dashboarding to ensure high-quality revenue data. Build Snowflake data marts, author complex SQL, create Tableau visualizations, apply AI/ML forecasting, and partner with Sales, Marketing, Finance, and IT to resolve data quality and reporting issues.
Top Skills:
Ai/MlChorusClariDbtGongOutreachPower BISalesforceSalesforce Revenue IntelligenceSnowflakeSQLTableau
What you need to know about the Los Angeles Tech Scene
Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering
