Data Engineer

``` About the Company Client is seeking a Senior Data Engineer with deep expertise in data operations, infrastructure for analytics, and database performance optimization to join our Investment Technology team. This role plays a critical part in building and maintaining the data backbone that powers internal applications, sustainability reporting, investment analytics, and decision-making platforms across Apollo’s asset classes. About the Role You will be responsible for architecting and operating scalable, reliable data infrastructure that supports both operational and analytical workloads. This includes managing ETL pipelines, optimizing storage and access patterns, and supporting structured data modeling for use by analysts, data scientists, and application developers. Responsibilities • Design, build, and maintain robust data infrastructure to support analytics, reporting, and sustainability workflows • Own the architecture and administration of relational and cloud-native databases (e.g., PostgreSQL, Snowflake, Redshift, MySQL) • Build and manage ETL/ELT pipelines for ingesting and transforming data across systems and third-party sources • Optimize database schemas, indexes, partitioning strategies, and storage for both query performance and cost-efficiency • Enable and support analytics platforms by providing clean, well-documented, queryable datasets for downstream use (BI, dashboards, AI/ML) • Implement and monitor data quality, governance, and access control policies • Collaborate with data analysts, ESG specialists, and application developers to streamline data access and analytical readiness • Automate and scale platform operations using infrastructure-as-code, containerization, and cloud-native orchestration tools • Establish and manage data observability, pipeline monitoring, and alerting for reliability and integrity • Support ESG data integration for internal and external sustainability disclosures, investment analysis, and regulatory reporting Qualifications • 8+ (or 5+ with exceptional expertise) years of experience in data engineering, data platform infrastructure, or analytics-focused engineering • Strong command of SQL and database optimization techniques • Experience with data warehouse systems (e.g., Snowflake, Redshift, BigQuery) and OLAP/OLTP hybrid design • Proficiency with Python or similar for scripting, transformation, and data operations • Familiarity with data pipeline frameworks (e.g., Airflow, dbt, Luigi) and orchestration practices • Hands-on experience with cloud platforms (e.g., AWS, Azure) and cloud-native data services • Experience building data platforms for analytics, BI, or machine learning use cases • Knowledge of CI/CD, Git, and Agile methodologies applied to data workflows • Solid understanding of data security, access control, and compliance Preferred Skills • Experience working with ESG/sustainability datasets or regulatory data (e.g., MSCI, CDP, SFDR) • Knowledge of investment data models, portfolio risk data, or financial instrument structures • Exposure to data versioning, columnar formats (Parquet, ORC), or data lake architectures • Familiarity with infrastructure-as-code tools (e.g., Terraform, CloudFormation) and containerization (e.g., Docker, Kubernetes) • Experience with data observability, monitoring pipelines, and alerting frameworks Pay range and compensation package Remote or NYC On-site (US-based preferred) Equal Opportunity Statement Client is committed to diversity and inclusivity. ```