InterSystems

InterSystems

Lead Data Modeler

Boston, MA

Sponsorship not specifiedDetected 2 days ago
SQLData AnalysisData EngineeringCRM

Stay score

odds of building a lasting career here

40Risky
Cap-exempt (no lottery)0
Sponsors this role90
Entry-level history0
PERM / green-card track0
Lottery odds40
Fits your clock70

Thin sponsorship signal and lottery-bound. A low-probability bet with your clock running. Prioritize cap-exempt roles and proven entry-level sponsors first.

Lottery odds assume a STEM candidate.

Personalize to your clock →

Employer immigration record

from this employer's Department of Labor filings

Green-card filing pattern in this occupation

Context, not a finding about this posting: of this employer's 41 green-card filings in this occupation, 100% were for a worker who already held the job.

Green-card intent detected

InterSystems Corporation obtained a prevailing wage determination for Software Developers in Boston, MASSACHUSETTS on 2026-06-09. No matching green-card filing appears in our data yet. The determination expires in 0 days (2026-09-06), and a green-card filing must follow before then or the employer starts over.+2 more active determinations on file

Green-card follow-through: 89%

Of 9 labor certifications old enough to have been used, 1 expired without the employer filing the next step. Median time from filing to decision: 395 days.100% of their filings were for a worker who already held the job.Only certifications past the 180-day window are counted — recent ones cannot have expired yet.

Files H-1B transfers

4 transfer filings in the last year, covering 4 workers. Median labor-condition decision: 8 days. An employer that already files transfers is one that can take over an existing H-1B.

Sourced from Department of Labor LCA, PERM and prevailing-wage disclosure data. Employer matching is by name, so figures may be split across an employer's legal entities. Absence of a filing means none appears in our copy of the data, not that none exists.

Community outcomes

No reports yet — be the first to help the next applicant.

About the role

  • This role sits at the center of our data lake / data warehouse initiative and will be responsible for defining how data is structured, understood, and used across the organization.
  • You will work closely with Data Engineering, Sales Tech, CRM, Marketing Technology, and business stakeholders to translate fragmented legacy CRM and operational systems into a unified, scalable data model.
  • This is a hands-on role requiring strong SQL and data analysis skills, with an emphasis on data modeling, source-to-target mapping, and cross-system reconciliation.

Responsibilities

  • Design and maintain conceptual, logical, and physical data models across the data lake / warehouse.
  • Build scalable, extensible models that reduce redundancy and support analytics, reporting, and operational workflows.
  • Validate incoming data against expected mappings and ensure alignment with defined models.
  • Partner with Data Engineers to identify and resolve discrepancies across systems and pipelines.
  • Develop frameworks for data validation, integrity checks, and consistency monitoring.
  • Maintain and optimize schemas and views within the data warehouse, ensuring high performance and reliability.

Skills

  • Data Modeling & Architecture Ownership
  • Define canonical data definitions, relationships, and business logic across fragmented legacy systems.
  • Establish modeling standards, naming conventions, and documentation practices across the platform.
  • Continuously refine models as new data sources and use cases emerge.
  • Source-to-Target Mapping & Data Translation
  • Analyze legacy CRM and other operational datasets to understand structure, quality, and business meaning.
  • Define detailed source-to-target mapping logic for ingestion into the data model.
  • Provide clear, implementation-ready transformation specifications to Data Engineers.
  • Act as the primary owner of how legacy data translates into the unified system.
  • Data Quality, Reconciliation & Discrepancy Resolution
Apply directly at InterSystems →Create a free account for alerts like thisView InterSystems immigration profile

This listing is sourced directly from InterSystems's careers page and normalized into a canonical job model.