Tripoint Solutions LLC

Salesforce Data Architect

Tripoint Solutions LLC United States · $140K–$160K/yr

IT Services and IT Consulting · 51-200 employees

7 h ago
Remote salesforce Principal (10+ yrs) Full-time United States
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

The architect will lead the migration from Salesforce EDA to Education Cloud and manage the enterprise data model across all integrated systems. They are responsible for designing ETL pipelines, maintaining data quality standards, and documenting architecture decisions.

What they look for

Salesforce Data Architecture Salesforce Education Cloud Data Migration Data Modeling ETL Design AWS Glue MuleSoft Salesforce Data 360 SQL Data Quality Rules Identity Resolution Data Pipelines Enterprise Data Modeling Data Dictionary Confluence Jira

Requirements

Candidates must have over 8 years of experience in data architecture and hands-on expertise with Salesforce Education Cloud or EDA. A bachelor's degree and U.S. citizenship are required, along with the ability to pass a federal background investigation.

Benefits

Medical insurance Dental insurance Vision insurance Flexible spending account Health savings account Life insurance Disability insurance Paid time off Paid holidays 401(k) retirement plan Professional development reimbursement

Full description

Position Summary

The Data Architect owns the data design for a large enterprise Salesforce platform as it moves from Salesforce Education Data Architecture (EDA) to Salesforce Education Cloud. This position maps and migrates data between data models, keeps external partner data feeds and recurring reporting intact through the change, and sets the enterprise data model the wider team builds to. The architect must know the Education Cloud data model and work independently.

Responsibilities

  • Design the mapping of all record types from EDA to the Education Cloud data model.
  • Plan and lead data migration, including validation, reconciliation, and cutover.
  • Own the enterprise data model across Salesforce, connected third-party systems, external partner data exchanges, and the reporting environment.
  • Design ETL and data pipelines using AWS Glue, MuleSoft, and related services.
  • Own the Salesforce Data 360 design: data streams, data model mapping, identity resolution, and activation.
  • Protect the continuity of point-in-time counts and recurring reporting data through the migration.
  • Maintain the data dictionary and define data quality rules with the data team.
  • Document data architecture decisions, models, and lineage in Confluence.
  • Estimate work in hours and log time against assigned Jira tickets.

Required Qualifications

  • Bachelor's degree in Computer Science, Information Systems, Data Science, or a related field.
  • 8+ years of data architecture, data modeling, or data engineering experience.
  • Hands-on experience with the Salesforce Education Cloud or EDA data model.
  • Hands-on experience with Salesforce Data 360 (formerly Data Cloud), including data ingestion and harmonization.
  • Led data migration between Salesforce data models or into Salesforce, including mapping, validation, and reconciliation.
  • Enterprise data modeling experience (conceptual, logical, and physical).
  • ETL design experience and advanced SQL.
  • Active Salesforce Trailblazer account with a public profile.
  • U.S. citizenship.
  • Ability to obtain and maintain a favorably adjudicated federal background investigation. A security clearance is not required.
  • Ability to handle and safeguard Controlled Unclassified Information.

Required Salesforce Certifications

The certification requirement must be current and verifiable:

  • One of: Salesforce Certified Platform Data Architect or Platform Administrator.

Candidates must list their certifications on their resumes and provide their Trailblazer profile URL. Required certifications will be verified before interviews are scheduled.

Preferred Qualifications

  • Salesforce Certified Data 360 Consultant.
  • AWS certification (Data Engineer or Solutions Architect).
  • AWS Glue, Amazon Redshift, or MuleSoft experience.
  • Experience supporting regulatory or compliance reporting.
  • Experience with recurring data exchange between partner organizations.
  • Experience supporting federal government technology programs.
  • Current favorably adjudicated federal background investigation.

Location: Remote. The selected candidate must be currently located in, or willing to relocate to, a state supported by Tripoint Solutions corporate offices: AL, CO, DC, DE, FL, GA, IL, IN, KS, LA, MD, MN, MS, NC, NJ, OH, PA, SC, TN, TX, or VA. (No relocation assistance provided)

Clearance Requirements:

  • U.S. Citizenship is required.
  • A favorably adjudicated (approved) National Agency Check with Inquiries (NACI) or equivalent (Tier 1 Investigation) or ability to obtain a government clearance.

About Tripoint Solutions

We are technology innovators, partnered with state-of-the-art providers, such as AWS, ServiceNow, and UiPath, to drive digital transformation in the federal space. TPS teams are bringing automation and data science into areas of the government that are crying out for fresh tech—making positive impacts felt by tens of thousands of users, countless citizens, and all six branches of the military each day. Our Agile teams are responsible for envisioning, launching, and operating the massive data systems and analytics platforms used to manage $14.5B in government procurements and $200B in military real estate assets globally. At TPS, we apply the power of cloud technologies to help the government think smarter and function better—for everyone.

TPS Company Values

  • We value and respect each employee's dedicated work and unique contributions as they directly impact who we are and what we do.
  • Your talent and innovative thinking bring leading-edge solutions to our customers.
  • Our success is driven by the dedication of our employees.
  • Employee-generated solutions have sustained our continued success and customer satisfaction

Benefit Offerings

Tripoint Solutions builds flexibility into health benefit plan choices, covers most of the monthly premiums, and helps employees build a career with impact through our generous professional development program.

We offer all full-time employees:

  • Medical, Dental, Vision benefits with a national provider network
  • Flexible Spending and Health Savings Accounts (FSA & HSA)
  • Company-paid Life and Disability insurance including Short-Term, Long-Term, and Accidental
  • Supplemental Insurance
  • Paid time off (PTO)
  • 11 paid holidays
  • 401(k) Retirement Plan
  • Professional Development Reimbursement Program to pursue undergraduate, graduate, training, and certifications
  • Monthly transportation, parking, and cell phone service reimbursement

Similar roles