Senior Data Engineer

Overview

This position sits within a team responsible for acquiring, organizing, and maintaining investment portfolio data for large-scale institutional clients. As a Senior Data Engineer, you will play a key role in building and sustaining scalable data infrastructure that supports both new client onboarding and ongoing data operations.

You will partner closely with incoming clients to evaluate their portfolio structures, including complex entity relationships, fund hierarchies, and underlying investment components. A major part of the role involves collaborating with client-side data teams to design efficient onboarding approaches, ensuring smooth integration into internal systems and enabling consistent downstream data access.

Success in this role requires the ability to resolve discrepancies between external data formats and internal schemas, proactively address data quality concerns, and maintain strict standards around data security and confidentiality. Strong technical expertise in Python and SQL is essential.

Key Responsibilities

• Build, maintain, and enhance scalable data pipelines to support ingestion, transformation, and storage of large datasets
• Analyze complex datasets to uncover trends, inconsistencies, and actionable insights that inform business decisions
• Identify data anomalies, structural issues, and reliability concerns; troubleshoot and resolve data-related challenges
• Evaluate and improve system performance to ensure efficient processing and timely delivery of accurate data
• Develop and optimize ETL processes using Python to support automated data workflows
• Write and refine advanced SQL queries to support data extraction, transformation, and performance tuning
• Design and maintain database objects (e.g., stored procedures) across MySQL and Microsoft SQL Server environments
• Establish and enforce best practices for secure data handling, storage, and sharing
• Partner with business and technical stakeholders to develop data models aligned with operational needs
• Ensure adherence to internal policies and external regulations related to data security and privacy
• Provide guidance and oversight to junior data team members

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Mathematics, Statistics, or a related discipline
• Demonstrated experience in data engineering, particularly in building and supporting data pipelines
• Experience working with financial datasets, investment portfolios, or banking-related information is a plus
• Strong knowledge of relational databases, including schema design, indexing strategies, and query optimization (MySQL, MSSQL)
• Advanced proficiency in Python and SQL for data processing and analysis
• Hands-on experience with data modeling, mapping, and integration based on business requirements
• Ability to interpret and work with large, complex datasets
• Familiarity with modern database technologies and enterprise data environments
• Solid understanding of data governance, management practices, and compliance standards
• Proven ability to manage multiple priorities and meet tight deadlines
• Strong analytical thinking and attention to detail
• Effective communicator, able to translate technical concepts for non-technical audiences
• Demonstrated leadership capabilities and ability to collaborate across teams

Work Arrangement

• Full-time, exempt role based in New York
• Hybrid schedule: 3 days in-office (Tuesdays and Wednesdays required), 2 days remote, subject to business needs
• Equal Opportunity Employer committed to a diverse and inclusive workplace
• Must be authorized to work in the U.S. without sponsorship

Salary Range: $140,000.00-$175,000.00, plus bonus.

#LI-Hybrid

Exempt/Not Exempt: Exempt