Principal Data Architect

Connection

. Define and evolve CFC-wide data architecture across all major systems and platforms .

Posted 5/5/2026full-timeRemote • Arizona, California, Colorado, Connecticut, Florida, Illinois, Massachusetts, New Jersey, New Mexico, New York, Ohio, Oregon, Pennsylvania, Texas, Virginia, Washington • 🇺🇸 United StatesLead💰 $170,000 - $190,000 per yearWebsite

Tech Stack

Tools & technologies

AzureCloudSQL

About the role

Key responsibilities & impact

Define and evolve CFC-wide data architecture across all major systems and platforms
Establish clear data domains, system boundaries, and integration patterns
Assess current and future organizational data needs and translate them into architectural direction
Develop long-term data architecture patterns that balance scalability, maintainability, and delivery constraints
Design and maintain conceptual, logical, and physical data models representing CFC’s core entities, relationships, and measures
Define, document, and govern source system schemas including canonical fields, data types, naming standards, and versioning approaches
Establish systems of record and systems of reference for key domains such as accounts, licenses, users, and programs
Ensure consistent implementation of data models across operational systems
Create clear documentation that enables shared understanding across technical and non-technical stakeholders
Architect and guide data flows between CFC systems to support operations, analytics, research, and decision-making
Design integration and transformation approaches that preserve semantic meaning
Oversee large-scale data integration, transformation, and storage patterns for reliable analytics
Monitor and evolve data flows to reduce duplication, fragility, and unnecessary complexity
Embed privacy, security, and compliance requirements directly into data models and integrations
Partner with IT, security, and legal teams to align architecture with regulatory and policy requirements
Ensure privacy and security protocols, including field-level encryption, role-based access control, deletion, and auditing are architected into and consistently supported across CFC’s data architecture
Define data quality standards and validation strategies, including management of schema drift over time
Enablement & Collaboration
Work closely with engineers, analysts, researchers, data stewards, and business partners
Serve as a subject-matter expert on CFC’s data architecture
Communicate complex data concepts clearly to diverse audiences

Requirements

What you’ll need

10+ years of experience designing and delivering data solutions, with at least 5 years in a data architecture role.
Bachelor’s degree in computer science, computer engineering, or related field, or equivalent experience
Extensive experience with relational databases and SQL
2+ years' experience with Lakehouse architectures, including Delta Lake technologies and medallion layer data modeling
Demonstrated experience designing and maintaining enterprise-scale data models and source schemas
Experience with data integration, transformation, and cleansing technologies
Strong understanding of data security, privacy, and compliance principles
Experience with cloud-based platforms (Azure preferred)
Experience with custom-built data systems, semi-structured data, data quality issues, and data optimization.
Ability to analyze undocumented data structures, identify source-to-target mappings, and uncover hidden data dependencies.

Benefits

Comp & perks

We cover 100% of your premiums for medical, dental and vision coverage and 50% for your dependent’s medical and dental premiums
Retirement plan + company match up to 3%
A flexible work subsidy: $100 per month that you can use on things like phone and internet costs, office supplies, or even commuting costs
16 paid holidays (including winter break and 1 floating holiday), 3 weeks' vacation in your first year, and separate sick leave accrual
Other great benefits include: monthly contribution to childcare and/or dependent expenses, FSA account, parental leave, sabbatical leave, employee assistance program, annual wellness reimbursement, growth and development opportunities, disability and life insurance.

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

data architecturerelational databasesSQLLakehouse architectureDelta Lakedata modelingdata integrationdata transformationdata cleansingdata quality

Soft Skills

collaborationcommunicationanalytical skillssubject-matter expertise

Certifications

Bachelor's degree in computer scienceBachelor's degree in computer engineering