Staff Software Engineer - Data Integration
FormativGroupabout 2 hours ago
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 throughout reverse engineering, coding, testing, debugging, and documentation while retaining ownership of technical decisions and 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.
- Comfort working in TypeScript and building automated tests.
- Demonstrated experience embedding AI tools into the software development process.
- Preferred experience with Informatica PowerCenter, DataStage, Talend, SSIS, or similar platforms.
- Preferred knowledge of graph models, OpenMetadata, OpenLineage, compilers, or parsers.
- Preferred experience delivering software into regulated or security-reviewed environments.
- Must be authorized to work for any U.S. employer without current employment visa sponsorship.
- Must reside in one of the specified eligible U.S. states or Washington, DC.
Benefits
- Medical, dental, and vision benefits.
- 401(k) plan.
- Paid time off.
- Discretionary bonuses, commissions, or other incentive programs may be available in addition to base pay.
- Applicants must be authorized to work for any U.S. employer without current visa sponsorship.
- Candidates must reside in one of the listed eligible U.S. states or Washington, DC.
Tech Stack
Categories
BackendData Engineering
About FormativGroup
Modern organizations depend on business systems that work in concert. FormativGroup enables our clients by connecting their processes and workflows, applications, and layers of data in ways that reflect how the business needs to operate. We help organizations knock down technology barriers, integrate workflows, and design connected data ecosystems, so information is available where and when they need it most. We are industry-centric consultants with expertise in design AND execution, working across your ecosystem to future-proof your business environment. See how you can transform possibility into progress with FormativGroup.