Staff Software Engineer - Data Integration

FormativGroup

$180K — $225K *
US-AnywhereRemote in United States
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 5-7 years of data engineering or systems integration experience.
  • Hands-on experience with ETL platforms and SQL parsing.
  • Skills in reverse engineering poorly documented systems.
  • Proficient in TypeScript for automated testing and development.
  • Extensive experience in AI-assisted software development with active integration into workflows.
  • Quick execution mindset with focus on thorough testing and bug fixing.

Responsibilities

  • Build connectors for various ETL platforms and cloud data systems.
  • Parse and process different data formats including XML and SQL.
  • Develop lineage and dependency models from extracted metadata.
  • Create automated tests and datasets to validate connector functionality.
  • Enhance the connector framework in collaboration with the Principal Architect.
  • Incorporate AI tools into development processes for efficiency.

Benefits

  • Comprehensive medical, dental, and vision insurance.
  • 401(k) retirement plan options.
  • Paid time off for work-life balance.
  • Potential for discretionary bonuses and commissions.
Full Job Description
What you'll do
  • 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 your daily development workflow to accelerate reverse engineering, coding, testing, debugging, and documentation.


What we're looking for
  • 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, with demonstrated experience embedding AI tools into the development process rather than using them occasionally.
  • A bias for shipping quickly, testing thoroughly, and fixing errors rather than explaining them away.


Nice to have
  • Experience with Informatica PowerCenter, DataStage, Talend, SSIS, or similar platforms.
  • Knowledge of graph models, OpenMetadata, OpenLineage, compilers, or parsers.
  • Experience delivering software into regulated or security-reviewed environments.


Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment visa currently.

To be considered for this position, candidates must reside in one of the following U.S. states: AL, AR, AZ, CA, CO, CT, DE, FL, GA, IA, ID, IL, IN, KS, MA, MD, MI, MN, MO, NC, NH, NJ, NV, NY, OH, OK, OR, PA, TN, TX, VA, WI, and Washington DC. Candidates residing outside these states are not eligible for consideration currently.

We are committed to pay equity and transparency. The compensation range for this position represents our good faith estimate of the range we reasonably expect to pay for this role at the time of posting. The actual compensation offered will be determined based on factors such as the candidate's experience, skills, education, work location, and internal equity.

In addition to base pay, employees may be eligible for discretionary bonuses, commissions, or other incentive programs, as well as a comprehensive benefits package that includes medical, dental, vision, 401(k), paid time off, etc.

Estimated Compensation Range:

$180,000-$225,000 USD

#formativgroupcareers #WorkWithUs

Click here to view our Privacy Policy

Similar Jobs

More Jobs at FormativGroup

More Information Technology Jobs

Find similar Staff Software Engineer - Data Integration jobs: