Data Engineer II

Job Description:

We’re looking for a Data Engineer II to join our Investment Data Technology team and help build scalable, reliable data solutions that fuel smarter investment decisions. This is an exciting opportunity to work across multiple modern data platforms while supporting business-critical use cases in a fast-paced asset management environment.

Key responsibilities:

• Support data pipelines and integrations that power investment data and analytics across platforms
• Work hands-on with ETL tools like SSIS, Fivetran, dbt and Census to connect and transform data from multiple sources
• Build and maintain data models using dbt and Snowflake to support investment management and data operations teams from vendor data consumption to analytics
• Develop and deploy reports using SSRS to serve internal stakeholders including Research Analysts, Portfolio Managers and Risk teams
• Assist with data hygiene, lineage, and governance practices to ensure consistency and reliability
• Troubleshoot and optimize SQL queries and pipeline performance

Years of Experience

• 4-8 years of Data Engineering experience required

Qualifications

• Bachelor’s degree in computer science, Mathematics, Statistics, or related engineering field required. Advanced degree preferred.

Special Requirements

• Prior experience of working in Finance domain (Investment bank, Asset Management firm, Hedge Fund).
• Good to have exposure to large scale distributed applications.

Required Skills & Qualifications:

• 4-8 years of experience in data engineering, BI, or analytics roles
• Hands-on experience with SSRS, SSIS, SQL, Snowflake, dbt, and one or more modern ETL tools (e.g., Fivetran, Census)
• Familiarity with cloud platforms, data warehouses, and investment data concepts
• Proficiency in Python for data engineering, automation and API development
• Knowledge of Investment Management data domains including Security Masters, Reference data, Indexes, Positions (IBOR, ABOR, trades) and Analytics
• Strong analytical mindset and attention to detail
• Comfort working in cross-functional settings with business and tech teams

Core Values

• Strong interpersonal, oral, and written communication and collaboration skills with all levels of management
• Strong organizational skills including the ability to adapt to shifting priorities and meet frequent deadlines,
• Demonstrated proactive approach to problem-solving with strong judgment and decision-making capability.
• Highly resourceful and collaborative team-player, with the ability to also be independently effective and exude initiative and a sense of urgency.
• Exemplifies our customer-focused, action-oriented, results-driven culture.
• Forward looking thinker, who actively seeks opportunities, has a desire for continuous learning, and proposes solutions.
• Ability to act with discretion and maintain complete confidentiality.
• Dedicated to the firm’s values of non-negotiable integrity, valuing our people, exceeding client expectations, and embracing intellectual curiosity and rigor.