AI & Data Solutions Architect

Ledgent Technology; San Diego (CA); Hybrid; USD 150,000 - 180,000; Full time

Job summary

Ledgent Technology is seeking a hands-on Platform & Data Solutions Architect in San Diego, CA, to own the data model, platform backbone, and integrations powering a growing app suite. You will lead the transformation of information into a structured, AI-ready foundation and act as the technical backbone of the data platform.

You will design canonical data models, build shared services, implement governance, and enable AI capabilities while collaborating across teams in a fast-moving,

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Software or Data Engineering, or equivalent practical experience.
• Hands-on experience designing and building production data platforms on a modern relational database with schema design and access controls.
• Hands-on full-stack development and modern web application delivery, including server-side and API work.
• Practical experience building AI and LLM features (agentic workflows, retrieval/RAG, natural-language-to-data, document processing) beyond prompting.
• Experience integrating enterprise systems via REST APIs and building or consuming ETL pipelines with data-governance discipline.
• Familiarity with Microsoft 365, SharePoint, and Entra ID in data contexts.

Responsibilities

• Design and own a shared, canonical data model and a well-partitioned relational database used by multiple applications.
• Lead transformation of data across structured and unstructured content into governed, AI-ready data.
• Build shared platform services (authentication/SSO, admin/role mgmt, document processing, AI gateway) with secure access controls.
• Support application development across departments, providing backend support or hands-on delivery as needed.
• Set guardrails for source control, environments, secrets, and lightweight reviews to enable autonomous shipping.
• Own integrations to systems of record (e.g., Yardi) and external data sources via APIs and connectors.

Skills

Full-stack development

Data platform design

REST APIs

AI/LLM features

Security-first architecture

Collaborator and communicator

Education

Bachelor's degree in Computer Science / Information Systems / Software or Data Engineering, or equivalent

Tools

MSSQL

PostgreSQL

Supabase

Node.js

Cloudflare

SharePoint

Entra ID

Job description

Key Details

Direct Hire/PermLocation: San Diego, CA - HybridPay: $150-180k + 10% bonus Must be eligible to work in the US without sponsorship now or in the future.

Summary

We are developing modern data infrastructure to run our business more efficiently. We are seeking a hands-on Platform & Data Solutions Architect to design and build the shared data model, platform backbone, and integrations that power a growing suite of applications, and to lead the transformation of our information into a structured, well-governed, AI-enabled foundation. You will be the technical backbone of the platform and the company's one-stop shop for data: architecting the data structures, building shared services and integrations, enabling safe and data-governance compliant data architecture for applications, and collaborating on delivering or thoughtfully sourcing AI capabilities. This is a rare opportunity to own a modern platform end-to-end in a fast-moving, entrepreneurial environment.

Core Responsibilities

Data architecture. Design and own a shared, canonical data model and a well-partitioned relational database where multiple applications read and write safely. You build real applications and the data foundation beneath them, not read-only dashboards. Data and document strategy. Lead the transformation of the company's information, both structured system data and unstructured documents, into structured, governed, AI-ready data. This includes a strategy for content that today lives across systems such as SharePoint and Office365, working with multiple stakeholders on the business and compliance decisions about what to bring in, when, and how. Platform backbone and security. Build and own shared platform services (authentication and SSO, administration and role management, document processing, and an AI and natural-language gateway). Implement access controls such as row-level security in the database as the platform's security backbone. Enablement and cross-department support. Support application development across every department, not only those already building. Some teams have a hands-on builder who can drive their own app and needs backend support to get it over the line, other teams know what they want but need someone more hands-on to build it with them. Provide both modes of support, reading what each department needs and flexing your involvement to match. Set the guardrails (source control, environments, secrets, and a lightweight review process) that let capable builders ship autonomously without compromising data integrity. Integration and source-of-truth discipline. Own integrations to our systems of record, including Yardi and its data layer, which remains our accounting system of record, and to market-data and vendor sources via APIs and connectors. Handle any write-back through approval-gated workflows, enable integrations of sources of truth. Support for accounting and finance. Enable AI and automation for finance and accounting processes with deterministic standard of validation. Model-agnostic AI delivery and build-vs-buy. Deliver custom AI and agentic solutions, including natural-language "talk to your data" and retrieval (RAG) capabilities, where in-house is the right call. Evaluate build-vs-buy per use case, including overseeing technical due diligence for any AI solutions.

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, Software or Data Engineering, or equivalent practical experience.
• Demonstrated experience designing and building production data platforms on a modern relational database, including schema design, access controls such as row-level security, and databases that serve multiple applications.
• Hands-on full-stack development and modern web application delivery, including server-side and API work.
• Practical experience building AI and LLM features (agentic workflows, retrieval/RAG, natural-language-to-data, and document processing) beyond basic prompting.
• Experience integrating enterprise systems via REST APIs and building or consuming ETL pipelines, with strong source-of-truth and data-governance discipline.
• Working familiarity with the Microsoft ecosystem (Microsoft 365, SharePoint, and Entra ID), where a significant portion of our data lives today.
• Tooling-agnostic judgment, dynamic, and adaptable: prototype fast, pivot based on merit.
• Energized by fast change, and able to make progress even with unclear paths.
• A strong collaborator and communicator who can take an "ask" from any department and support it effectively, flexing between backend support for a team's own builder and more hands-on delivery for teams that need it.
• You are not expected to arrive knowing how each team operates; you listen, translate a business need into a technical path, and meet each team at its level of technical capability.
• Security-first instincts and personal credibility: you think in data flows, trust boundaries, and access controls.

Strongly Preferred

• MSSQL, PostgreSQL, Supabase or similar, Node.js, and Cloudflare or similar edge and serverless platforms.
• Experience with leading LLM platforms (Claude, Copilot, or OpenAI) and MCP (Model Context Protocol) server or connector development.
• Entra ID SSO/SAML, least-privilege access design, and security-first architecture.
• Experience enabling "citizen developers" and line-of-business builders safely against shared infrastructure.
• Large-scale document ingestion, knowledge-retrieval, or RAG over an enterprise corpus.
• Experience with Yardi, or commercial real estate data systems (CoStar, CompStak, Argus, GreenStreet).
• Range across company sizes: From larger, structured organizations, to smaller, fast-moving firms.
• Commercial real estate, real estate finance, or institutional investment domain exposure.

All qualified applicants will receive consideration for employment without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran status. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the California Fair Chance Act, City of Los Angeles' Fair Chance Initiative for Hiring Ordinance, Los Angeles County Fair Chance Ordinance, and San Francisco Fair Chance Ordinance.