Data Automation Engineer / Analyst – Global Investment Fund – 250k+

Mondrian Alpha; New York (NY); Hybrid; USD 120,000 - 160,000; Full time

Job summary

Mondrian Alpha in New York is seeking an engineer at the intersection of software and data to automate manual processes across investment and operations teams. The role will build the automation, contribute to reporting, and deliver end-to-end solutions that reduce spreadsheet errors and improve daily workflows.

The candidate will own Python-based automation, write advanced SQL, and design dashboards with self-service tooling, collaborating with front and middle offices to identify automatable

Qualifications

• 3 to 8 years of experience across software development and data or analytics engineering.

Responsibilities

• Build and own Python automation across investment and operations teams.

Skills

Python

SQL

Automation

Data analytics

Production-grade code

Tools

dbt

Airflow

Power BI

Tableau

Looker

Snowflake

BigQuery

Redshift

Job description

A multi-strategy investment fund is hiring an engineer to sit at the point where software engineering and data work meet. The role builds the automation that removes manual process from the middle of the business, the reporting layer that investment and operations teams rely on, and the tooling that turns recurring analytical requests into systems nobody has to think about again. The work touches performance reporting, position and P&L data, and the operational flows that have to be right before the market opens. Every manual spreadsheet step this role eliminates is a source of error and a person's morning returned to them, and the fund treats that as real value rather than housekeeping.

What You'll Do

• Build and own Python based automation that replaces manual and semi manual processes across investment and operations teams
• Write and optimise complex SQL against large datasets, and own the data models behind reporting
• Design the reporting and analytics layer that business users depend on daily, including dashboards and self service tooling
• Sit with stakeholders across the front and middle office to find processes worth automating, then deliver them end to end
• Apply real engineering discipline to data work: version control, testing, code review, deployment, monitoring

Must-haves

• 3 to 8 years of experience across software development and data or analytics engineering
• Strong Python, written to production standard rather than script standard. This is non-negotiable, the role needs genuine developer depth
• Advanced SQL, including query optimisation and data modelling
• A track record of building automation that replaced a manual process and stayed in production
• Comfort working directly with business stakeholders and turning loose requirements into working systems

Nice-to-haves

• BI tooling experience (Power BI, Tableau, Looker)
• dbt, Airflow, or similar transformation and orchestration frameworks
• Cloud data warehouse experience (Snowflake, BigQuery, Redshift)
• Exposure to financial data: P&L, positions, returns, risk
• Experience in a multi-strategy or multi-asset environment

Why This Role

This is a hybrid profile that most firms handle badly, splitting it between a developer who does not understand the data and an analyst who cannot ship code. This fund wants one person who does both, and gives that person the autonomy to decide what gets automated. The structure is flat, the feedback loop from build to impact is measured in days, and the work is visible to senior people across the business. For an engineer who is happiest when their code quietly deletes somebody's recurring problem, and who wants the data fluency to know which problem to delete, this is that.

Who should apply

Candidates coming from either direction are welcome: developers who have moved toward data, and BI or analytics engineers who have built real software. No finance background required.