Back to jobs
New

Data Architect

Remote

First San Francisco Partners (FSFP) is a leading business advisory and information management consultancy dedicated to helping organizations leverage their data to improve strategic decision-making, reduce risk, create operational efficiencies and fuel unprecedented business success. Our consulting services include data management, data governance, Collibra (data governance and data quality software) implementation/adoption, data architecture, data quality, master and reference data management, metadata management and data privacy.

Kelle O’Neal founded the company in 2007 and is its Chief Executive Officer. FSFP’s leading position and strong reputation in our industry is because of our experienced senior leaders and dedicated consultants, business analysts and sales, administrative and marketing staff.

FSFP serves clients throughout the U.S., including large consumer brands, notable financial institutions and other organizations who want to make their information (data) actionable.

FSFP’s culture is centered on teamwork and a shared passion for what we do. We believe in treating clients (and one another) with respect and delivering measurable results for clients. Our FIRST values (Focus, Integrity, Resourcefulness, Skillfulness and Teamwork) guide our interactions.

The Data and Information Architect is a client-facing lead responsible for shaping enterprise data and information architectures that align to business strategy and accelerate adoption of data governance, master and reference data, metadata, and data quality capabilities. This person blends architecture rigor with consulting judgment: they design extensible target-state architectures, translate business needs into pragmatic implementation roadmaps, and partner with stakeholders across business and IT to deliver outcomes that stick.

The ideal candidate has progressed through roles such as data analyst, data modeler, data steward, and architect. That breadth lets them connect strategy, design, and execution rather than treat them as separate workstreams. They are equally comfortable advising executives on a roadmap and sitting with a development team to validate a logical model or review a metadata asset model.

Domain Expertise

  • Data Architecture and Modeling: Develops and maintains enterprise high-level data models and targeted subject area models at the conceptual, logical, and physical levels. Captures data requirements from business strategies and data initiatives, designs for current and future state, and reviews physical implementations against enterprise data requirements. Maintains an expert understanding of cloud, hybrid, and on-premise storage patterns, including the security, access, and performance implications of each.
  • Information Architecture: Designs the structures that make information findable, usable, and trustworthy. Defines business glossaries, taxonomies, reference data structures, and asset models that anchor the meaning of data across the organization. Aligns information architecture with content, search, and analytics needs so that downstream consumers can locate and interpret data without having to reverse-engineer it.
  • Data Governance and Metadata Management: Designs and implements enterprise data governance and metadata management solutions. Translates business and technical requirements into Collibra (or comparable platform) configurations, including operating models, asset models, workflows, and stewardship processes. Develops metagovernance recommendations, designs automated metadata import and export methods, and recommends curation processes for high-quality content.
  • Master and Reference Data Management: Familiar with industry-standard MDM and RDM patterns and able to advise on implementation styles (registry, centralized, co-existence, hybrid) based on use case fit. Integrates MDM into the broader data architecture through APIs, batch, or streaming, and aligns match/merge, hierarchy, and stewardship workflows with the governance operating model.
  • Data Quality and Lineage: Assesses and improves data quality through profiling, rule definition, and ongoing monitoring. Implements lineage capture so that data flow from source to consumption is visible and explainable. Recommends and configures capabilities for business and technical metadata, data lineage, data profiling, and issue or request management.
  • Regulatory and Privacy Awareness: Maintains a working understanding of major data-related regulations (HIPAA, GDPR, CCPA, and equivalents) and how they shape architecture decisions, classification schemes, access controls, and retention design.

Key Responsibilities

  • Lead data and information architecture engagements end to end, including strategy, design, implementation oversight, education, standards creation, and ongoing measurement.
  • Conduct workshops and interviews with business and IT stakeholders to assess current-state maturity, identify pain points, and shape a future-state roadmap.
  • Identify, document, and prioritize use cases that drive the strategy and roadmap, and translate them into target-state designs.
  • Develop and maintain enterprise data models, asset models, and architecture patterns for data layers, data stores, integration, and provisioning.
  • Configure and oversee implementation of data governance and metadata platforms (e.g., Collibra), including operating model alignment, workflow design, and bulk metadata loads.
  • Perform architecture and technology gap analyses, recommend solutions, and produce implementation roadmaps that move clients toward future state.
  • Ensure documentation for models, architectures, and standards is accurate, well organized, and curated for ongoing use.
  • Develop and deliver training materials, use case documentation, and implementation specifications that support adoption beyond the engagement.
  • Provide thought leadership on emerging practices, including data mesh, data fabric, semantic layers, and AI-supported governance.

Technical Skills and Tools

  • Data Catalog and Governance Platforms: Hands-on expertise with metadata tools such as Collibra, Alation, Informatica CDGC, Microsoft Purview, or Unity Catalog.
  • Data Modeling Tools: Proficiency with enterprise data modeling tools (e.g., erwin, ER/Studio, PowerDesigner, or equivalents) and the ability to produce conceptual, logical, and physical models that hold up under review.
  • Cloud Data Platforms: Familiarity with modern cloud data ecosystems, including Databricks and Unity Catalog, Snowflake, and major hyperscaler data services. Understands how governance policies (access controls, classifications, lineage) apply within those environments.
  • MDM and RDM Tools: Practical experience with at least one MDM platform (e.g., Informatica MDM, Reltio, Profisee, or Semarchy). Understands match/merge configuration, hierarchy management, and steward workflows.
  • Data Quality and Lineage: Experience with data quality tools (e.g., Informatica Data Quality, Collibra Data Quality, Ataccama) and lineage or observability capabilities, whether tool-driven or implemented through metadata integration.
  • SQL and Databases: Strong SQL skills and a solid grasp of relational database design. Comfortable working across platforms such as Oracle, SQL Server, Postgres, and cloud-native equivalents.
  • AI and Automation: Uses modern AI assistants thoughtfully to speed up design and delivery work.

This range is based on our market pay structures. Individual salaries are determined by a variety of factors including, but not limited to business considerations, local market conditions, internal equity and candidate qualifications, such as skills, experience and education. 

Pay Transparency Notice: First San Francisco Partners will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c) 

Benefits Summary

At First San Francisco Partners, the health and safety of our employees and their families is a top priority. We support our employees in all aspects of their life, including health and financial well-being. Full Time employees scheduled to work 40 hours per week are offered a variety of benefits including medical, dental and vision insurance; a 401(K) savings plan, disability coverage; life and accident coverage, vacation time and paid holidays.  

Temporary Consultants are not eligible for First San Francisco benefits but can participate in other company incentives including our Employee Referral Program.  

EEOC Statement

First San Francisco Partners is committed to hiring and retaining a diverse workforce. We are proud to be an Equal Opportunity Employer, making hiring decisions without regard to race, color, religion, sexual orientation, gender identity, marital status, national origin, age, veteran status, disability, or any other protected class.  

Create a Job Alert

Interested in building your career at First San Francisco Partners? Get future opportunities sent straight to your email.

Apply for this job

*

indicates a required field

Phone
Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Cover Letter

Accepted file types: pdf, doc, docx, txt, rtf


Select...
Select...
Select...

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in First San Francisco Partners’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Select...
Select...
Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...

Voluntary Self-Identification of Disability

Form CC-305
Page 1 of 1
OMB Control Number 1250-0005
Expires 04/30/2026

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Select...

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.