Data Engineer

New York City, NY - USA

Monthly Salary: $ 105000 - 140000

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Job Summary

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. Youll 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 Trilliums analytics team can focus on delivering insightsconfident that the data underneath is clean reliable and automated.

This is not just a maintenance role its a chance to help define the firms enterprise data environment. Youll 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.

Youll 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 Trilliums 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

Bachelors or Masters 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 partnershipcomfortable 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 $105000 - $140000 additional bonus if applicable. Actual compensation is based on a number of factors including but not limited to the candidates 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

$105000$140000 USD

Trillium is an Equal Opportunity 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 .