Data Engineer

Trillium is a leading proprietary trading firm active in US Equities, US Options, Canadian Equities, and OTC Equities. With trading technology built, tested, and optimized in-house, our engineers and technologists collaborate with our traders to deliver tools and functionality designed to support their needs. Our passion for the markets and our drive to succeed have propelled our track record of growth and profitability for over 20 years. At Trillium, we are a team of problem solvers and independent thinkers dedicated to seizing market opportunities.

We are headquartered in New York City, with additional trading floors in Chicago and Miami. To learn more about Trillium, visit

The Role

As a Data Engineer at Trillium, you will be responsible for building and maintaining the foundation that powers analytics across the firm. You’ll design robust data pipelines, integrate new data sources, and create business-ready datasets that enable fast, accurate, and scalable reporting and analysis. Your work will ensure that Trillium’s analytics team can focus on delivering insights—confident that the data underneath is clean, reliable, and automated.

This is not just a maintenance role, it’s a chance to help define the firm’s enterprise data environment. You’ll play a key part in shaping standards, architecture, and best practices that scale as Trillium expands its analytics capabilities. As Trillium modernizes its data environment, you will drive the evaluation and adoption of cloud and modern data platforms.

You’ll partner closely with our Data Scientist, technologists, and cross-functional stakeholders in Finance, HR, Risk, and Trading. Together, you will connect disparate datasets into a cohesive, governed infrastructure that supports smarter, faster decision-making across the organization. As Trillium continues to expand its analytics capabilities, this role offers the opportunity to influence architectural choices and grow in scope as the function matures.

Responsibilities

• Design, build, and maintain reliable, automated data pipelines that feed dashboards, reports, and analytical models


• Develop and optimize database structures to support high-quality, business-ready datasets across trading, risk, HR, and finance


• Integrate new data sources and vendors into Trillium’s data ecosystem


• Implement and maintain strong data governance, access controls, and compliance standards across sensitive datasets


• Ensure data accuracy, speed, and reliability by implementing best practices in monitoring, validation, and quality control


• Partner with the Data Scientist to enable exploratory studies, predictive modeling, and firmwide analytics


• Collaborate with technologists to align infrastructure, tools, and integration standards


• Continuously seek opportunities to improve automation, reduce manual processes, and enhance the scalability of analytics at Trillium

Requirements

• Bachelor’s or Master’s degree in Computer Science, Data Engineering, Information Systems, or a related field


• 3-6 years of experience in data engineering, ETL development, or database architecture (experience in financial services or trading a plus)


• Strong SQL expertise (PostgreSQL, MySQL, or similar) and experience designing normalized and denormalized data models


• Proficiency with Python and other scripting languages for building and maintaining ETL pipelines and data loaders


• Experience with API, batch, and real-time streaming data ingestion methodologies


• Experience optimizing large-scale datasets and query performance tuning (partitioning, indexing, caching)


• Experience with AWS services as they relate to data storage and data pipelines


• Experience with CI/CD pipelines and infrastructure as code, is a plus


• Familiarity with BI/reporting tools such as Tableau, Power BI, or RStudio/Posit, is a plus but not a requirement


• Experience with data orchestration and workflow management (e.g., Airflow, dbt, or similar)


• Knowledge of cloud data platforms (Snowflake, Redshift, BigQuery, Databricks, or similar), with the ability to guide evaluation, adoption, and integration


• Strong grasp of data governance, quality control, security, and monitoring practices


• A mindset of partnership—comfortable explaining technical concepts to non-technical stakeholders and helping others integrate, trust, and use data effectively

Location : This is a hybrid role based in NYC

Compensation and Perks

• The reasonably estimated salary for this role is $105,000 - $140,000 + additional bonus if applicable. Actual compensation is based on a number of factors including but not limited to the candidate's skills, qualifications, and experience.


• Complimentary breakfast on Tuesdays and lunch on Wednesdays and Thursdays


• Trillium sets itself apart with a collaborative culture built on mutual respect and a shared commitment to excellence. Many of our team members have chosen to build their entire careers here, drawn by an environment that values long-term growth, fosters innovation, and creates a truly great place to work.


• Trillium offers a wide range of best in class, comprehensive and inclusive employee benefits and perks including PTO, medical and dental insurance, 401(K) matching, parental leave, pre- tax commuter benefits, and catered lunches.

USA Pay Range

$105,000—$140,000 USD

Trillium is an Equal Opportunity Employer. In order to provide equal employment and advancement opportunities to all individuals, employment decisions at Trillium are based on merit, qualifications, and the needs of the company. Trillium does not discriminate on the basis of race, creed, color, religion, sex, national origin, age, disability, predisposing genetic characteristics, ancestry, military status, family care status, marital status, sexual orientation, domestic violence victim status, gender identity or any other legally protected basis protected by applicable law. Applicants who are interested in applying for a position and require special assistance or a reasonable accommodation due to a disability should contact [email protected] .