Data Engineer(DBT, SQL, Airflow, BQ; Public Investments)

Job Description

• Design, build and maintain scalable data pipelines using SQL, dbt, Airflow and BigQuery.
• Develop dbt models and transformations for reliable and reusable data processing.
• Build and manage Airflow DAGs for data ingestion, transformation and workflow orchestration.
• Develop complex SQL queries and optimize data processing and BigQuery performance.
• Design and maintain data models and data warehouse solutions on BigQuery.
• Implement data quality checks, validation and reconciliation across data pipelines.
• Work with investment/public-market data including portfolio, securities, market or investment-related datasets.