Senior Data Engineer

About the role

(This role is based in Trepp's NYC office and follows a hybrid work schedule)

The Data Platform Team powers all products at Trepp by using distributed data technologies built on our data lake. The Pipeline Team plays a crucial role in designing and maintaining scalable, performant data pipelines that support all product lines at Trepp.

About this role:

As a member of the Data Platform Pipeline Team, you’ll be using open-source and cloud technologies to build, optimize, and maintain robust data pipelines. You’ll collaborate with multiple product teams and engineering teams to solve complex problems in our financial and analytical products for CRE and Banking.

Responsibilities:

- Design, build, and maintain scalable batch and near real-time data pipelines that power Trepp’s data-driven products.

- Lead complex data engineering projects from planning through delivery, while managing stakeholder expectations and timelines.

- Translate high-level business and product requirements into data models, technical designs, and production-ready implementations.

- Embed data quality, validation, monitoring, and reliability checks into pipelines to ensure trusted production data.

- Develop deep subject matter expertise in internal frameworks and use that expertise to shape roadmaps and prioritize initiatives.

- Break down ambiguous ideas into actionable tasks, project plans, and clear execution milestones.

- Evaluate technical options through research, clearly articulate tradeoffs, and recommend solutions grounded in business and engineering impact.

- Champion data engineering best practices that improve scalability, maintainability, performance, and platform innovation.

- Design and integrate AI-driven workflows, including LLM orchestration, embedding generation, and vector search pipelines, into core data processing systems.

- Architect and operate reliable data ingestion and transformation pipelines using native AWS cloud infrastructure.

Basic Qualifications:

- Bachelor’s Degree

- At least 5 years of experience in application development

- At least 3 years of experience in big data technologies

- Demonstrated experience in dimensional data modeling and relational schema design for enterprise data warehouses and data lakes

- At least 3 years of experience with cloud computing (AWS, Microsoft Azure, Google Cloud)

- Experience with Agile and SDLC, Git workflows, and CI/CD

- Hands-on experience building and deploying data pipelines on AWS core services (S3, EMR, Glue, Lambda, Step Functions)

Preferred Qualifications:

- 5 + years of experience in application development including Python, SQL, Scala, or Java

- 5+ years of experience with Distributed data/computing tools (MapReduce, Hadoop, Hive, EMR, Kafka, Spark)