Staff Software Engineer - AI-Driven Data Lineage & Connectors

FormativGroup; Austin (TX); On-site; USD 180,000 - 225,000; Full time

Benefits offered by this job

Medical, dental, vision insurance

401(k) plan

Paid time off

Discretionary bonuses / commissions

Job summary

FormativGroup seeks a technically hands-on engineer to own connectors and parsers that power our product. You will work in an AI-first environment, collaborating with a Principal Architect to craft reusable patterns and drive fast, high-quality development.

You will parse XML, SQL, and vendor formats to build accurate lineage and dependency maps, and you will create automated tests and datasets to verify accuracy across complex data systems.

Qualifications

• Strong data engineering, metadata, or systems integration experience.
• Hands-on work with ETL platforms, SQL parsing, data lineage, or transformation logic.
• Experience reverse engineering unfamiliar or poorly documented systems.
• Comfort working in TypeScript and building automated tests.
• Well-versed in AI-assisted software development and embedding AI tools into the development process.
• Bias for shipping quickly, testing thoroughly, and fixing errors rather than explaining them away.

Responsibilities

• Build connectors for legacy ETL platforms, databases, and modern cloud data systems.
• Parse XML, SQL, repository exports, scripts, and vendor-specific formats.
• Turn extracted metadata into accurate lineage and dependency models.
• Create automated tests and known-good datasets to verify connector accuracy.
• Improve the connector framework with our Principal Architect and document reusable patterns.
• Integrate AI into daily development workflow to accelerate reverse engineering, coding, testing, debugging, and documentation.

Skills

Data engineering

Metadata

Systems integration

SQL parsing

Reverse engineering

TypeScript

AI-assisted development

Testing automation

Tools

Informatica PowerCenter

DataStage

Talend

SSIS

OpenMetadata

OpenLineage

Job description

FormativGroup seeks a technically hands-on engineer to own connectors and parsers that power our product. You will work in an AI-first environment, collaborating with a Principal Architect to craft reusable patterns and drive fast, high-quality development.

You will parse XML, SQL, and vendor formats to build accurate lineage and dependency maps, and you will create automated tests and datasets to verify accuracy across complex data systems.