Data Architect

Data ArchitectFull-time · Onsite (Greater Cleveland, OH Area)ABOUT THE ROLEA prominent manufacturing organization in the Greater Cleveland area is seeking a pragmatic, detail-oriented Data Architect to spearhead a major data modernization initiative. This critical enterprise project involves transitioning core data ecosystems from a legacy Siebel environment into Salesforce and Snowflake.Serving as the technical anchor for the data migration strategy, the Data Architect will collaborate directly with onsite engineering and business teams. This individual will tackle complex data mapping challenges, untangle legacy Siebel structures, and design scalable schemas in a multi-cloud environment to ensure the new Snowflake data warehouse is optimized for long-term analytics. For a professional who enjoys the puzzle of turning legacy complexity into clean, modern data architectures, this project offers high impact and visibility.KEY RESPONSIBILITIESLead 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 SnowflakeArchitect Snowflake Solutions: Design, optimize, and maintain Snowflake environments, ensuring clean data modeling, efficient data sharing, and robust warehouse performanceModernize Data Structures: Collaborate with onsite engineering and business stakeholders to translate legacy Siebel data models into scalable, modern CRM and analytical data schemasEnsure Data Governance: Establish and enforce data quality standards, access patterns, and security guardrails across a multi-cloud data landscapeCollaborate Cross-Functionally: Work closely alongside Salesforce teams, data engineers, and business analysts to ensure a seamless data transition with minimal business disruptionREQUIRED QUALIFICATIONS5+ years of experience in data architecture, data modeling, or data warehouse designLegacy 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 schemasDeep 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 migrationsExpert SQL Skills: Ability to reverse-engineer complex, nested legacy queries and write clean, optimized code for modern cloud platformsMulti-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 weekEducation: Bachelor’s degree in Computer Science, Data Engineering, or a related field; Master’s degree is a plusNICE TO HAVE (PREFERRED) Salesforce Experience: Familiarity with the Salesforce data model, standard/custom objects, and CRM data integration patternsCertifications: Active Snowflake SnowPro Core/Advanced or cloud provider certifications (AWS, Azure, GCP)Experience with dbt for transformation workflows and data documentationWhat We OfferCompetitive salary and performance-based incentivesComprehensive health, dental, and vision coverageProfessional development and training opportunitiesThis position is open to multiple engagement models, including Permanent/Full-Time, Contract, or Corp-to-Corp (C2C) arrangements. We are looking for the best talent and are flexible on the employment structure for the right candidate.We cannot work with third-party agencies at this time. Resumes submitted via unapproved agencies will be automatically rejected.