Senior Data Engineer, Real-Time Private Credit Analytics

Alter Domus; New York (NY); In loco; USD 88.000 - 145.000; Tempo pieno

Vantaggi offerti da questo lavoro

Professional accreditations

Flexible arrangements

Birthday day off

Continuous mentoring

Sports & social events

Employee Assistance Program

Employee Share Plan

Descrizione del lavoro

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.

Competenze

• 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).

Mansioni

• 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.

Conoscenze

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

Strumenti

dbt

Snowflake

Databricks

BigQuery

Redshift

Airflow

Dagster

Prefect

Descrizione del lavoro

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.