FormativGroup Logo

FormativGroup

Staff Software Engineer - Data Integration

Posted 27 Days Ago
In-Office or Remote
Hiring Remotely in Time, IL
180K-225K Annually
Senior level
In-Office or Remote
Hiring Remotely in Time, IL
180K-225K Annually
Senior level
Build and maintain connectors that parse ETL tools, databases, and vendor formats; convert extracted metadata into accurate lineage/dependency models; create automated tests and known-good datasets; improve connector framework and document reusable patterns; integrate AI into development, testing, and debugging workflows.
The summary above was generated by AI

Our product helps regulated enterprises understand what will break before they migrate from legacy data platforms. Our software reads ETL tools, databases, and proprietary formats, then turns that information into trusted lineage and dependency maps.

We are early-stage, funded, and building a small product team. You will own the connectors and parsers that make the product work. We operate AI-first. You are expected to actively use AI throughout the development process to move faster, improve quality, and solve unfamiliar technical problems. Engineers still own every technical decision and the final correctness of the output.


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.

Why Join FormativGroup

At FormativGroup, you’ll work with people who are practical, collaborative, and focused on solving meaningful business and technology problems. We’re growing, which means you’ll have opportunities to contribute ideas, work closely with experienced leaders, and help shape how we deliver for clients.


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

FormativGroup operates within the critical middle layer of business technology, where applications and systems connect infrastructure to business processes. We are specialists who help the middle market take full advantage of their technology investments with deep, industry-centric expertise, all in one place, to unify fragmented systems. With deep technical expertise across cloud architecture, system integration, AI, and data strategy, we bridge the gap between business goals and modern platforms.  

FormativGroup is an equal opportunity employer providing opportunities to applicants and employees without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.

ADA Specifications: Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this position. 

#formativgroupcareers #WorkWithUs


Click here to view our Privacy Policy

Similar Jobs

34 Minutes Ago
Easy Apply
Remote or Hybrid
US
Easy Apply
114K-188K Annually
Senior level
114K-188K Annually
Senior level
Marketing Tech • Social Media • Software • Analytics • Business Intelligence
Leads go-to-market financial planning and analysis, partnering with Sales, Revenue Operations, and Partnerships leadership. Owns GTM reporting, P&L planning, forecasting, variance analysis, financial modeling, pipeline and bookings analysis, sales capacity planning, quota setting, and compensation design. Builds scalable reporting and data solutions using Pigment, Salesforce, Tableau, and SQL while providing strategic insights on pricing, packaging, revenue, and business performance.
Top Skills: ExcelPigmentSalesforceSQLTableau
2 Hours Ago
Remote or Hybrid
US
230K-290K Annually
Senior level
230K-290K Annually
Senior level
HR Tech • Information Technology • Professional Services • Sales • Software
Leads payroll services and operations across the US and UK, owning strategy, implementation quality, customer outcomes, scalability, revenue, and P&L. Builds and scales payroll service models for SMB and mid-market customers, partners with Product, Engineering, Customer Success, Sales, and Operations, and develops a high-performing organization. Uses AI, automation, and innovative operating approaches to improve efficiency, retention, expansion, and service delivery.
Top Skills: AIAutomationSaaS
Yesterday
Remote or Hybrid
Illinois, USA
150K-250K Annually
Senior level
150K-250K Annually
Senior level
Fintech • Machine Learning • Payments • Software • Financial Services
Leads product management for Capital One’s Anti-Money Laundering risk platform. Responsibilities include launching regulatory-compliance features, partnering with data and technology teams, using AI tools for product discovery and delivery, developing the product roadmap, and driving a multi-year enterprise risk management transformation. The role requires cross-functional leadership, customer-focused product development, business and technology strategy, integrated problem-solving, and risk mitigation.
Top Skills: Anti-Money Laundering (Aml)Artificial Intelligence (Ai)

What you need to know about the Los Angeles Tech Scene

Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.

Key Facts About Los Angeles Tech

  • Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
  • Key Industries: Artificial intelligence, adtech, media, software, game development
  • Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
  • Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account