Data Architect (Only W2)

⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Data Architect/Data Modeler with 11+ years of experience, focusing on legal operations transformation. Contract length and pay rate are unspecified. Key skills include Salesforce, Snowflake, SQL, and data governance. On-site location in Cupertino, CA or Austin, TX.
🌎 - Country
United States
💱 - Currency
$ USD
💰 - Day rate
Unknown
Unknown
🗓️ - Date discovered
April 15, 2025
🕒 - Project duration
Unknown
🏝️ - Location type
On-site
📄 - Contract type
W2 Contractor
🔒 - Security clearance
Unknown
📍 - Location detailed
Cupertino, CA
🧠 - Skills detailed
#Leadership #CRM (Customer Relationship Management) #Data Integrity #AI (Artificial Intelligence) #Tableau #Security #Data Design #Snowflake #Data Modeling #Automation #Migration #Strategy #Data Architecture #"ETL (Extract #Transform #Load)" #ML (Machine Learning) #SQL (Structured Query Language) #Scala #Data Quality #Data Migration #Documentation #Data Governance #Data Analysis #Data Profiling #Compliance #Data Management #Data Security
Role description

Role: Data Architect/Data Modeler

Location: Cupertino, CA or Austin, TX

Experience:11+Years

Need Architects. W2 profiles only

Below both JDs are open; anyone who fits either of these JDs is welcomed.

JD-1

Lead Data Strategist – Legal Operations Transformation

Summary:

This role will focus on driving improvements in data integrity, governance, and standardization across legal operations. You will work on the business side of the Data Management Office, ensuring that matter, billing, vendor, litigations, patents, contracts, and compliance data is clean, consistent, and aligned with enterprise standards. A key component of the role will also include leveraging AI to support data remediation efforts and ensuring that our legal department data is fit-for-purpose in AI-enabled use cases.

Key Responsibilities:

   • Lead business data architecture efforts within Legal Operations in collaboration with cross-functional stakeholders.

   • Define and maintain canonical data definitions and standards across legal, billing, vendor, litigation, patent, contract, and compliance domains.

   • Partner with Legal Ops leadership to implement scalable data governance practices that align with enterprise data strategies.

   • Conduct current-state assessments and design optimized, future-state data flows that support transformation goals.

   • Identify and resolve data quality and integrity issues through root-cause analysis and hands-on remediation, leveraging AI tools where appropriate.

   • Shape and execute a strategy for making business data AI-ready, including proper labeling, enrichment, and structuring for downstream analytics and ML use cases.

   • Translate complex business needs into detailed technical and operational data requirements.

   • Engage confidently with both business and technical stakeholders to drive alignment and adoption.

Key Qualifications:

   • 10+ years of experience in business data analysis, data architecture, or related fields.

   • Proven success in transformation initiatives or large-scale enterprise change programs.

   • Deep understanding of enterprise data management, governance, and quality frameworks.

   • Experience with Salesforce, Snowflake, and Tableau to support reporting, data modeling, and analytics needs.

   • Strong SQL skills, with working knowledge of data profiling tools and techniques.

   • Exposure to machine learning (ML) concepts and best practices for structuring data to support AI use cases.

   • Experience using or guiding the use of AI/ML technologies for data remediation, categorization, or enrichment.

   • Excellent facilitation and documentation skills; able to drive consensus and clarity across varied stakeholders.

   • Highly detail-oriented, hands-on, and pragmatic—able to toggle between strategy and execution.

   • Demonstrated ability to navigate complex, matrixed environments in large tech or enterprise settings.

   • Familiarity with legal operations, billing systems, or professional services environments is a strong plus.

   • Self-starter with a high sense of ownership, accountability, and follow-through.

JD-2

Principal Salesforce Data Architect – Legal Ops & Billing

Summary:

This role is responsible for ensuring the Salesforce data architecture that supports legal operations—especially matter lifecycle management, litigation, patents, contracts, compliance data, and billing—is robust, scalable, and well-integrated. As part of the transformation program, you’ll lead design efforts for the technical data model, working across teams to optimize performance, data quality, and long-term maintainability.

Key Responsibilities:

   • Lead Salesforce data model design and architecture in support of matter management, litigation, patent, contract, compliance data, and billing system modernization.

   • Ensure robust, scalable structures for data intake, tracking, billing, and vendor integration within Salesforce.

   • Partner with Legal Ops, Engineering, and Salesforce admin/developer teams to design and implement best-in-class data solutions.

   • Translate business requirements into clean, efficient technical data models that promote accuracy and maintainability.

   • Support data migration and data integrity efforts with a meticulous and methodical approach.

   • Provide hands-on support for prototyping, testing, and validating data model changes throughout the transformation.

   • Advocate for architectural best practices and help educate internal teams on scalable Salesforce data design.

   • Operate with a strong sense of ownership and attention to detail, driving initiatives from concept through execution.

Key Qualifications:

   • 8–10+ years of Salesforce data architecture and implementation experience, preferably in legal, finance, or operations contexts.

   • Deep expertise in Salesforce platform architecture, including custom object modeling, relationships, data security, and automation frameworks.

   • Experience with CRM Analytics (CRMA) and Salesforce reporting layers to support operational and executive insights.

   • Strong working knowledge of SQL for data validation, migration, and transformation tasks.

   • Experience in defining or working within a semantic data layer to enable consistent business metrics and reporting.

   • Demonstrated ability to work across systems, integrating Salesforce with legacy platforms and third-party tools.

   • Excellent communicator and collaborator—able to align engineers, analysts, and business users around clear technical plans.

   • Strong problem-solving mindset with exceptional attention to detail.

   • Comfortable navigating complexity in large, fast-paced enterprise environments.

   • Proactive, hands-on, and highly accountable with a strong bias toward execution.