Senior AI Data Engineer: Lakehouse Pipelines & Leadership

Aimlroles; Jersey City (NJ); On-site; USD 126,000 - 210,000; Full time

Job summary

BNY is seeking an experienced data engineer to design and operate robust batch and streaming data pipelines powering AI and analytics across cloud and lakehouse platforms.

You will model data, ensure quality, implement lineage and metadata, and optimize performance while mentoring engineers and leading complex delivery in a global financial services environment located in Jersey City, NJ.

Qualifications

• Bachelor’s degree in Computer Science, Engineering, or a related field, or equivalent experience.
• 9–11 years of experience in software development and data engineering; financial services experience is a plus.
• Strong experience building large-scale batch and streaming data pipelines and backend data environments.
• Deep expertise in Spark/Databricks, Kafka, SQL, and orchestration tools such as Airflow and/or dbt.
• Strong understanding of cloud and lakehouse architectures, distributed processing, and storage formats such as Parquet and Delta.
• Experience with data modeling, schema design, lineage, metadata, and data quality frameworks.
• Proven ability to improve performance, scalability, reliability, cost efficiency, and governance across data platforms.
• Strong stakeholder management, problem-solving, and technical leadership skills, including mentoring engineers and leading complex delivery.

Responsibilities

• Design, build, and optimize batch and streaming data pipelines that deliver high-quality, governed data to AI, analytics, and enterprise platforms.
• Develop scalable transformation frameworks across cloud and lakehouse environments with a strong focus on reliability, performance, and cost efficiency.
• Implement data modeling, schema design, lineage, metadata, and data quality controls to create trusted, reusable data assets.
• Build and support orchestration and workflow automation for complex pipelines and dependencies using modern data engineering tools.
• Partner with analytics, AI, business, and technology teams to translate requirements into scalable, secure, and governed data solutions.
• Resolve complex platform and pipeline issues related to performance, reliability, integration, and data quality.
• Promote engineering best practices in distributed processing, testing, monitoring, security, and continuous improvement.
• Provide technical leadership and mentoring while contributing to the adoption of modern data engineering and lakehouse capabilities.

Skills

Spark/Databricks

Kafka

SQL

Airflow

dbt

Data engineering

Leadership

Education

Bachelor’s degree in Computer Science, Engineering, or related field

Tools

Airflow

dbt

Databricks

Job description

BNY is seeking an experienced data engineer to design and operate robust batch and streaming data pipelines powering AI and analytics across cloud and lakehouse platforms.

You will model data, ensure quality, implement lineage and metadata, and optimize performance while mentoring engineers and leading complex delivery in a global financial services environment located in Jersey City, NJ.