Data Platform Architect for AI Foundation & MDM

Leon Capital Group; Dallas (TX); On-site; USD 140,000 - 190,000; Full time

Job summary

Leon Capital Group, Dallas-based, is seeking a hands-on Data Engineer to own the data foundation across its healthcare, real estate, and financial services portfolio. You will consolidate fragmented data, clean, resolve, and produce a single trusted record for AI workloads.

Reporting to the Chief Innovation Officer, you will build canonical models and curated marts, enable consistent provenance, and scale the platform across the portfolio while enforcing data ownership and regulatory safeguards.

Qualifications

• 7+ years building data systems end to end, ideally as an early or founding data hire.
• Deep master data management expertise: canonical data models, matching, survivorship, and golden-record programs.
• Strong data engineering fundamentals: schema design, ETL/ELT, data quality and de-duplication discipline.
• Deep SQL and warehouse experience; Azure‑anchored stack (Azure SQL, dbt) with multi‑cloud exposure (Azure/AWS).
• Proven experience integrating with messy enterprise/vendor systems and with flat-file or SFTP feeds without clean API.
• Comfort owning data infrastructure in a major cloud environment without a dedicated platform team.
• Experience handling regulated data (PHI, HIPAA, financial) securely.
• Excellent judgment under ambiguity and ability to prioritize across initiatives.
• Bias toward data quality: trustworthy data as the precondition for downstream steps.

Responsibilities

• Consolidate and harden existing cloud data platforms: fix broken syncs, reduce single points of failure, and meet security standards.
• Design and own the canonical data model and curated marts for long-term portability.
• Own master data management end to end: define canonical entities, matching, survivorship, and golden-record rules.
• Run cleansing and identity resolution as a continuous discipline; standardize and validate source data.
• Build ingestion pipelines from heterogeneous sources with provenance: APIs, flat-files, SFTP feeds.
• Stand up the curated data layer that AI depends on: feed data to lead scoring and predictive workloads.
• Build validation, monitoring, and lineage to catch data-quality issues before models.
• Treat the platform as a reusable pattern, scaling across portfolio initiatives.

Skills

Data modeling

Master data management

SQL / data warehouse

ETL / ELT pipelines

Data quality & deduplication

Cloud platforms (Azure/AWS)

Vendor systems integration

Regulatory data handling

Decision making under ambiguity

Job description

Leon Capital Group, Dallas-based, is seeking a hands-on Data Engineer to own the data foundation across its healthcare, real estate, and financial services portfolio. You will consolidate fragmented data, clean, resolve, and produce a single trusted record for AI workloads.

Reporting to the Chief Innovation Officer, you will build canonical models and curated marts, enable consistent provenance, and scale the platform across the portfolio while enforcing data ownership and regulatory safeguards.