Senior Data Engineer: Snowflake, Airflow & Finance Data

The Phoenix Group®; New York (NY); In loco; USD 120.000 - 180.000; Tempo pieno

Descrizione del lavoro

The Phoenix Group is seeking a hands-on Senior Data Engineer to own complex pipelines from ingestion through transformation and delivery. You will design and build scalable pipelines using Snowflake, dbt, and Airflow to support investment and financial data.

Collaborate with investment, finance, portfolio management, operations, and analytics teams to translate requirements into reliable datasets for dashboards and reporting.

Competenze

• 5+ years of professional Data Engineering experience, ideally within a sophisticated financial environment.
• Prior experience within private equity, asset management, investment management, hedge funds, or financial services.
• Strong hands-on experience with Snowflake.
• Experience building transformation pipelines and data models using dbt.
• Production experience with Apache Airflow for workflow orchestration.
• Advanced SQL skills and strong proficiency with Python.
• Experience building and maintaining CI/CD pipelines for data platforms and data engineering applications.
• Strong understanding of ETL/ELT architecture, data warehousing, dimensional modeling, and modern cloud data platforms.
• Experience integrating data from multiple APIs, databases, files, SaaS applications, and third-party data providers.
• Familiarity with Git-based development workflows and automated testing/deployment.
• Strong communication skills with the ability to work with both technical teams and financial stakeholders.

Mansioni

• Design, build, and maintain scalable data pipelines and ETL/ELT workflows supporting investment and financial data.
• Develop and optimize modern data architecture leveraging Snowflake as the cloud data warehouse.
• Build reusable and well-tested data transformation models using dbt.
• Develop, schedule, and monitor complex data workflows and pipelines using Apache Airflow.
• Build integrations across internal and external data sources, including investment and third-party datasets.
• Write advanced SQL and Python for data ingestion, transformation, automation, and processing.
• Implement and maintain CI/CD pipelines for data engineering workflows with testing and deployment.
• Partner with investment, finance, portfolio management, operations, and analytics teams to translate requirements.
• Collaborate with BI and analytics teams to create reliable datasets for dashboards and reporting.
• Establish best practices around data quality, testing, lineage, governance, and documentation.
• Troubleshoot pipeline failures, performance issues, and data-quality problems across the data ecosystem.
• Help improve and modernize the firm's data platform as it scales.

Conoscenze

Snowflake

dbt

Apache Airflow

SQL

Python

CI/CD

Strumenti

Databricks

AWS

Azure

Power BI

Sigma

iLevel

Descrizione del lavoro

The Phoenix Group is seeking a hands-on Senior Data Engineer to own complex pipelines from ingestion through transformation and delivery. You will design and build scalable pipelines using Snowflake, dbt, and Airflow to support investment and financial data.

Collaborate with investment, finance, portfolio management, operations, and analytics teams to translate requirements into reliable datasets for dashboards and reporting.