Job Summary:
The Data Sherpas is a prominent manufacturing organization in the Greater Cleveland area seeking a pragmatic, detail-oriented Data Architect to lead a major data modernization initiative. The role involves transitioning core data ecosystems from a legacy Siebel environment into Salesforce and Snowflake, while collaborating with engineering and business teams to tackle complex data mapping challenges and design scalable schemas.
Responsibilities:
• Lead Data Mapping & Migration : Own the comprehensive source-to-target data mapping, transformation logic, and lineage tracking required to migrate legacy Siebel data into Salesforce and Snowflake
• Architect Snowflake Solutions : Design, optimize, and maintain Snowflake environments, ensuring clean data modeling, efficient data sharing, and robust warehouse performance
• Modernize Data Structures : Collaborate with onsite engineering and business stakeholders to translate legacy Siebel data models into scalable, modern CRM and analytical data schemas
• Ensure Data Governance : Establish and enforce data quality standards, access patterns, and security guardrails across a multi-cloud data landscape
• Collaborate Cross-Functionally : Work closely alongside Salesforce teams, data engineers, and business analysts to ensure a seamless data transition with minimal business disruption
Qualifications:
Required:
• 5+ years of experience in data architecture, data modeling, or data warehouse design
• Legacy System Migration Expertise: Proven experience working with or migrating data away from Siebel (or closely related legacy CRM/ERP systems like Oracle EBS), with a deep understanding of complex legacy data schemas
• Deep Expertise with Snowflake: Strong production experience designing and optimizing Snowflake environments (SnowSQL, data sharing, schema design)
• Advanced Data Mapping Skills: Demonstrated success leading extensive source-to-target data mapping and lineage tracking for large-scale enterprise migrations
• Expert SQL Skills: Ability to reverse-engineer complex, nested legacy queries and write clean, optimized code for modern cloud platforms
• Multi-Cloud Familiarity: Hands-on experience working within major cloud ecosystems (AWS, Azure, or GCP)
• Location: Ability to work full-time onsite in the Greater Cleveland, OH area, 5 days a week
• Education: Bachelor’s degree in Computer Science, Data Engineering, or a related field; Master’s degree is a plus
Preferred:
• Salesforce Experience: Familiarity with the Salesforce data model, standard/custom objects, and CRM data integration patterns
• Certifications: Active Snowflake SnowPro Core/Advanced or cloud provider certifications (AWS, Azure, GCP)
• Experience with dbt for transformation workflows and data documentation
Company:
The Data Sherpas emerge as a beacon of expertise and innovation in the rapidly evolving digital era. Founded in 2010, the company is headquartered in San Francisco, USA, with a team of 11-50 employees. The company is currently Early Stage.