Staff Software Engineer - Data Integration
FormativGroup30 days ago
Remote, United StatesStaff+
Base Salary
$180k - $225k/yr
Responsibilities
- Build connectors for legacy ETL platforms, databases, and modern cloud data systems.
- Parse XML, SQL, repository exports, scripts, and vendor-specific formats.
- Convert extracted metadata into accurate lineage and dependency models.
- Create automated tests and known-good datasets to verify connector accuracy.
- Improve the connector framework with the Principal Architect and document reusable patterns.
- Use AI in reverse engineering, coding, testing, debugging, and documentation while owning technical decisions and final correctness.
Requirements
- Strong experience in data engineering, metadata, or systems integration.
- Hands-on experience with ETL platforms, SQL parsing, data lineage, or transformation logic.
- Experience reverse engineering unfamiliar or poorly documented systems.
- Proficiency with TypeScript and automated testing.
- Demonstrated experience embedding AI tools into the software development process.
- Experience with Informatica PowerCenter, DataStage, Talend, or SSIS is preferred.
- Knowledge of graph models, OpenMetadata, OpenLineage, compilers, or parsers is preferred.
- Experience delivering software into regulated or security-reviewed environments is preferred.
- Must be authorized to work for any U.S. employer; the company cannot provide or take over employment-visa sponsorship.
- Must reside in one of the listed eligible U.S. states or Washington, DC.
Benefits
- Medical, dental, vision, 401(k), paid time off, and other comprehensive benefits.
- Discretionary bonuses, commissions, or other incentive programs may be available.
- Applicants must be authorized to work for any U.S. employer; visa sponsorship is unavailable.
- Candidates must reside in an eligible U.S. state or Washington, DC.
- The role is with an early-stage, funded company and a small product team.
Tech Stack
Categories
BackendData Engineering
About FormativGroup
FormativGroup is a technology consulting and implementation partner that modernizes complex business platforms for enterprises by connecting workflows, applications, and data across ecosystems. It provides strategy, solution design, system integration, and ongoing support across cloud and on‑premises stacks, with engagements in industries such as insurance. The company is privately held, PE‑backed, and headquartered in White Plains, New York.