Data Engineer

Alter Domus; Chicago (IL); On-site; USD 88,000 - 145,000; Full time

Benefits offered by this job

Alter Domus Academy

LinkedIn Learning

Six learning zones

Birthday day off

Job summary

Alter Domus in Chicago is seeking a Senior Data Engineer to build and maintain data pipelines powering a new suite of analytics products for private credit. You will extract data from core administration systems, transform into analytics-ready structures, and ensure near-real-time delivery.

You will own the data-in-motion layer, implement CDC, and collaborate with the Data Architect and Platform Engineer to align logical design with delivery requirements.

Qualifications

• 5+ years of professional data engineering experience building production pipelines.
• Expert proficiency in Python and SQL.
• Experience with cloud data platforms (Snowflake, Databricks, BigQuery, Redshift) and dbt.
• Experience with orchestration tools (Airflow, Dagster, Prefect) and CI/CD for data pipelines.
• Strong experience with CDC, streaming, or event-driven architectures.
• Experience with regulatory filing ingestion and parsing (e.g., XBRL).
• Familiarity with loan-level data structures in financial contexts.
• Experience building pipelines for external clients, not just internal BI.
• Cloud certifications (AWS, Azure, or GCP).

Responsibilities

• 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
• Implement extraction logic for complex financial data including loan balances, rate structures, allocations, and maturities
• Implement change-data-capture (CDC) and incremental refresh patterns for near-real-time data
• Ingest and validate structured data from regulatory filings and third-party sources, deduplicate against primary data
• Collaborate with the Data Architect and Platform Engineer to align logic, schema, and delivery requirements

Skills

Python

SQL

Data pipelines

CDC/Streaming

Data modelling

Regulatory ingestion

External clients

Cloud basics

CI/CD

Tools

Snowflake

Databricks

BigQuery

Redshift

dbt

Airflow

Dagster

Prefect

AWS

Job description

About this job

Alter Domus (meaning “The Other House” in Latin) is a world leading provider of integrated solutions for the alternative investment industry, 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. We encourage all interested candidates to apply and discuss their salary expectations and overall package with the recruitment team.

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.

(Alter Domus Privacy notice can be reviewed via Alter Domus webpage: https://alterdomus.com/privacy-notice/)