Data Engineer

Alter Domus; New York (NY); On-site; USD 88,000 - 145,000; Full time

Benefits offered by this job

Professional accreditations

Flexible arrangements

Birthday day off

Continuous mentoring

Sports & social events

Employee Assistance Program

Employee Share Plan

Job summary

Alter Domus in New York seeks a data engineering professional to build and maintain pipelines powering a new private credit analytics suite. You will extract data from loan systems, transform into analytics-ready structures, and enable near-real-time delivery with incremental refresh.

You own the data-in-motion layer, coordinating with the Data Architect and Platform Engineer to ensure clean, validated, and reconciled data lands in the analytics platform for downstream use.

Qualifications

• 5+ years of professional data engineering experience building production pipelines at scale.
• Expert proficiency in Python and SQL.
• Hands-on experience with modern cloud data platforms (Snowflake, Databricks, BigQuery, Redshift) and transformation frameworks (dbt).
• Experience with orchestration tools (Airflow, Dagster, Prefect) and CI/CD for data pipelines.
• Strong experience with CDC, streaming, or event-driven architectures.
• Solid understanding of data modelling—star schema, slowly changing dimensions, master data management.
• Experience with regulatory filing ingestion and parsing (XBRL, HTML extraction from public filings).
• Familiarity with loan-level data structures (credit agreements, facilities, tranches, pro-rata allocations).
• Experience building pipelines that serve external commercial clients (not only internal BI).
• Cloud platform certifications (AWS, Azure, or GCP).

Responsibilities

• Pipeline Build & ETL: Design, build, and maintain production-grade ETL/ELT pipelines to extract, transform, and load data from core administration platforms into the analytics data model.
• Data Extraction & Transformation: Implement extraction logic for complex financial data including loan balances, rate structures, pro-rata allocations, utilisation and maturity dates.
• Incremental Refresh Logic: Implement CDC and incremental refresh patterns for near-real-time data delivery.
• Supplementary Data Ingestion: Build pipelines to ingest and validate data from regulatory filings and third-party sources, deduplicate and integrate into master data.
• Data Quality & Monitoring: Implement automated quality checks—completeness, freshness, range validation, referential integrity, duplicate detection; build pipeline failure alerts.
• Collaboration: Work with Data Architect and Platform Engineer to ensure alignment between logical design, physical implementation, and delivery requirements.

Skills

Data Engineering

Python

SQL

Cloud Platforms

Snowflake

Databricks

BigQuery

Redshift

dbt

Airflow

Dagster

Prefect

CI/CD

CDC/Streaming

Data Modeling

Regulatory Ingestion

External Clients

Certifications

Tools

dbt

Snowflake

Databricks

BigQuery

Redshift

Airflow

Dagster

Prefect

Job description

Select how often (in days) to receive an alert: Create Alert

As a world leading provider of integrated solutions for the alternative investment industry, Alter Domus (meaning “The Other House” in Latin) is proud to be home to 90% of the top 30 asset managers in the private markets, and more than 6,000 professionals across 24 jurisdictions.

With a deep understanding of what it takes to succeed in alternatives, we believe in being different in what we do, how we work, and most importantly in how we enable and develop our people. Invest yourself in the alternative, and join an organization where you progress on merit, where you can speak openly with whoever you are speaking to, and where you will be supported along whichever path you choose to take.

Find out more about life at Alter Domus at careers.alterdomus.com

JOB DESCRIPTION:

You will build and maintain the data pipelines that power a new suite of private credit analytics products. This means extracting data from large-scale loan administration systems, transforming it into analytics-ready structures, implementing incremental refresh logic for near-real-time delivery, and resolving entities across multiple sources. You own the "data in motion" layer — everything from source extraction through to landing clean, validated, reconciled data into the platform for downstream consumption.

Key Responsibilities:

• Pipeline Build & ETL:Design, build, and maintain production-grade ETL/ELT pipelines to extract, transform, and load data from core administration platforms into the analytics data model. Handle tens of thousands of live records with daily (or intraday) refresh requirements
• Data Extraction & Transformation:Implement extraction logic for complex financial data — including loan balances (funded, unfunded, PIK, outstanding), rate structures (index, floor, spread, all-in), pro-rata allocations, utilisation calculations, and maturity dates
• Incremental Refresh Logic:Implement change-data-capture (CDC) and incremental refresh patterns to deliver near-real-time data without full reloads. Critical for client-facing products where same-day freshness is expected
• Supplementary Data Ingestion:Build pipelines to ingest and validate structured data from regulatory filings and third-party sources, de-duplicate against the primary dataset, and integrate into the master data layer
• Data Quality & Monitoring:Implement automated quality checks — completeness, freshness, range validation, referential integrity, duplicate detection. Build alerting for pipeline failures and anomalies
• Collaboration:Work closely with the Data Architect (who defines the logical model and schema) and the Platform Engineer (who owns the infrastructure your pipelines run on) to ensure alignment between logical design, physical implementation, and delivery requirements

Requirements:

• 5+ years of professional data engineering experience building production pipelines at scale
• Expert proficiency in Python and SQL
• Hands‑on experience with modern cloud data platforms (e.g., Snowflake, Databricks, BigQuery, Redshift) and transformation frameworks (e.g., dbt)
• Experience with orchestration tools (e.g., Airflow, Dagster, Prefect) and CI/CD for data pipelines
• Strong experience with CDC, streaming, or event-driven architectures
• Solid understanding of data modelling — star schema, slowly changing dimensions, master data management
• Experience with regulatory filing ingestion and parsing (e.g., XBRL, HTML extraction from public filings)
• Familiarity with loan‑level data structures (credit agreements, facilities, tranches, pro-rata allocations)
• Experience building pipelines that serve external commercial clients (not only internal BI)
• Cloud platform certifications (AWS, Azure, or GCP)

WHAT WE OFFER:

We are committed to supporting your development, advancing your career, and providing benefits that matter to you.

Our industry‑leading Alter Domus Academy offers six learning zones for every stage of your career, with resources tailored to your ambitions and resources from LinkedIn Learning.

Salary range: We offer a salary of $87,500 to $145,000+ for this role.

Our global benefits also include:

• Support for professional accreditations
• Flexible arrangements, generous holidays, plus an additional day off for your birthday!
• Continuous mentoring along your career progression
• Active sports, events and social committees across our offices
• 24/7 support available from our Employee Assistance Program
• The opportunity to invest in our growth and success through our Employee Share Plan

Alter Domus is an Equal Opportunity Employer: Equity Statement
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, or protected veteran status.