Data Engineer at Trillium

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.