Senior Data & Solutions Architect

Prosights, Inc.; New York (NY); On-site; USD 140,000 - 195,000; Full time

Job summary

Prosights, Inc. seeks an experienced data architect to define canonical models, domain boundaries, and integration contracts across acquired and legacy systems. You will shape the target data architecture and governance by design.

You will profile imperfect data, run sessions with stakeholders, and collaborate with engineers through implementation, reconciliation, and go-live to ensure delivery quality. This role requires 8+ years in data engineering or enterprise integration, strong SQL and

Qualifications

• 8+ years of experience in data architecture, engineering, or related field.
• Strong SQL and data modeling skills.
• Experience with enterprise integration, ERP/CRM data, and data governance.

Responsibilities

• Profile imperfect data and define target architecture.
• Run sessions with business owners, data teams, security, and finance.
• Collaborate with engineers through implementation, reconciliation, and go-live.
• Make explicit tradeoffs between ideal future state and delivering value.

Skills

Data architecture

Data engineering

Solution architecture

Enterprise integration

Data modeling

SQL

ERP/CRM data

Business acumen

Decision making

Job description

Prosights is a data transformation partner to the largest private equity-backed portfolio companies. We unify messy data after M&A, turn documents into clean structured data, replace spreadsheet workflows with real software, and keep data in sync across disparate systems. We embed engineers inside the company, ship a working prototype in 48 hours, and have production software live in about four weeks. More than 70% of the 10 largest PE firms have used ProSights.

What you would build

Target data architecture. Define canonical models, domain boundaries, system-of-record decisions, and integration contracts across acquired and legacy systems.

Migration design. Create profiling, mapping, reconciliation, lineage, cutover, and rollback approaches for high-stakes customer, contract, financial, and operational data.

Solution blueprints. Translate an operating workflow into a pragmatic architecture spanning source systems, databases, warehouses, applications, and AI services.

Governance by design. Build identity, retention, data quality, auditability, access control, and stewardship into the solution from the beginning.

Reusable patterns. Turn successful models, mappings, and decision frameworks into assets the next team can use.

What the job is actually like

Profile imperfect data directly and challenge assumptions before drawing the target architecture.

Run working sessions with business owners, data teams, security, finance, and third-party system integrators.

Pair with engineers through implementation, reconciliation, and go-live rather than handing over a diagram.

Make explicit tradeoffs between the ideal future state and the fastest safe path to customer value.

Review architecture across multiple engagements and raise the quality bar for the whole delivery organization.

Who you are

Experienced architect. 8+ years across data engineering, solution architecture, enterprise integration, or large-scale migration.

Hands-on with data. Strong SQL and data modeling; comfortable profiling source systems and validating transformations yourself.

Enterprise fluent. You understand warehouses, lakehouses, APIs, eventing, MDM, identity, governance, and the realities of ERP and CRM data.

Business-minded. You can explain why a model or system boundary matters to a CFO, operator, or functional leader.

Decisive under ambiguity. You create clarity without pretending the source data or organization is cleaner than it is.

About the interview

Three to four conversations with the founders, engineering, and delivery team, followed by a paid architecture exercise using a realistic multi-system customer scenario. We will focus on how you interrogate the data, frame tradeoffs, and create a design that can actually be implemented.