remote
Snowflake Engineer - Jitterbit & Salesforce Integration - Blackstraw LLC
Software Engineer
Design and implement Snowflake data pipelines integrating Salesforce data via Jitterbit, ensuring high‑performance, secure, and scalable data solutions for enterprise AI initiatives.
About the role
Key Responsibilities
- Develop and maintain Snowflake data models, warehouses, and pipelines to ingest and transform Salesforce data.
- Design, configure, and optimize Jitterbit integrations between Salesforce APIs and Snowflake, handling data mapping, error handling, and performance tuning.
- Collaborate with data engineers, analysts, and AI teams to define data requirements and ensure data quality, lineage, and governance.
- Implement automated ETL/ELT workflows using SQL and Python scripts, supporting CI/CD pipelines and monitoring solutions.
- Provide technical support and troubleshooting for production data flows, addressing latency, failures, and security concerns.
Requirements
- 3+ years of hands‑on experience with Snowflake, including schema design, clustering, and query optimization.
- Proven expertise in Jitterbit integration platform and Salesforce APIs (REST/SOAP).
- Strong SQL proficiency and experience scripting data pipelines in Python or similar languages.
- Solid understanding of data warehousing concepts, ETL/ELT best practices, and cloud environments (AWS, Azure, or GCP).
- Excellent problem‑solving skills and ability to work cross‑functionally in fast‑paced, data‑driven projects.
Skills
snowflakesalesforcesqlpython