FormativGroup Logo

FormativGroup

Staff Software Engineer - Data Integration

Posted 5 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

7 Hours Ago
Remote or Hybrid
United States
17-25 Hourly
Junior
17-25 Hourly
Junior
Artificial Intelligence • Automotive • Greentech • Information Technology • Machine Learning • Software • Cybersecurity
Provide remote technical support for VinSolutions and Cox Automotive products via phone, email, and chat. Troubleshoot and resolve application issues, log cases in the CRM, escalate to other teams as needed, and keep clients informed while meeting quality standards and shift requirements.
Top Skills: Genesys PurecloudExcelMicrosoft OutlookMicrosoft WordSalesforceVinsolutions
9 Hours Ago
Remote
United States
190K-190K Annually
Senior level
190K-190K Annually
Senior level
Security • Cybersecurity
Design, build, and deploy production-grade ML systems for ICS/xOT cybersecurity, including threat detection, anomaly detection, NLP/LLM applications, and scalable data pipelines with observability and MLOps practices for cloud and on-prem environments.
Top Skills: Ci/CdDockerGoHuggingfaceJavaKubernetesLlmsMessage QueuingMlopsModel VersioningNlpPipeline OrchestrationPythonPyTorchRetrieval-Augmented Generation (Rag)RustScikit-LearnSQLStream ProcessingTensorFlow
9 Hours Ago
Remote
United States
152K-152K Annually
Senior level
152K-152K Annually
Senior level
Security • Cybersecurity
Hunt, identify, and analyze adversary tools, malware, and tradecraft targeting ICS/OT. Develop and maintain analysis tools and scripts, contribute to threat assessments and customer advisories, leverage intel and network analysis tools, recommend automation and telemetry improvements, and support incident response and external communications.
Top Skills: C#CensysDiamond ModelJoe SandboxKill ChainMitre Att&CkNetflowPythonShodanStorm Query LanguageSynapseVirustotal

What you need to know about the Boston Tech Scene

Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.

Key Facts About Boston Tech

  • Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
  • Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
  • Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
  • Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account