Data Engineering Senior Associate

• Competitive compensation, including base pay and annual incentive
• Comprehensive health and life insurance and well-being benefits, based on location
• Pension / Retirement benefits
• Paid Time Off and Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being.
• DTCC offers a flexible/hybrid model of 3 days onsite and 2 days remote (onsite Tuesdays, Wednesdays and a third day unique to each team or employee).

.

• Develop and optimize data models following

principles to support analytics, reporting, and downstream data consumption.

• Implement and manage

tables, ensuring efficient data storage, partitioning, lifecycle management, and performance optimization.

• Build and maintain complex

to orchestrate large-scale batch and data processing workflows with high reliability and observability.

• Develop advanced SQL transformations and data quality frameworks to ensure data accuracy, consistency, and governance across platforms.
• Optimize

workloads by monitoring query performance, warehouse sizing, clustering strategies, and credit consumption to improve cost efficiency.

• Collaborate with data architects, platform teams, and business stakeholders to translate data requirements into scalable technical solutions.
• Develop reusable

, macros, tests, and documentation while promoting data engineering best practices.

• Utilize

for large-scale data processing and transformation activities where distributed computing is required.

• Implement infrastructure-as-code solutions using

to automate provisioning and management of cloud data platform resources.

• Support CI/CD implementation for data engineering solutions using Git-based workflows, automated testing, and deployment pipelines.
• Leverage

and AI-powered capabilities to enable intelligent data processing, enrichment, and analytical use cases.

• Containerize and deploy data engineering applications using

and modern DevOps practices.

• Conduct performance tuning, troubleshooting, and root cause analysis across data pipelines, orchestration workflows, and storage layers.
• Ensure adherence to data governance, security, compliance, and operational standards across enterprise data platforms.
• Mentor junior team members and contribute to architecture reviews, code reviews, and engineering best practices.

Preferred Skills & Expertise • Strong hands-on experience in

.

• Expertise in

, star/snowflake schemas, and Medallion Architecture.

• Experience with

table optimization, compaction, partition evolution, and query performance tuning.

• Knowledge of data orchestration, monitoring, lineage, and observability frameworks.
• Familiarity with cloud-native data platforms, CI/CD pipelines, DevOps practices, and Infrastructure as Code.
• Strong analytical, problem-solving, and stakeholder management skills.

Senior Associate Expectations • Own medium-to-large data engineering initiatives with minimal supervision.

• Drive technical design discussions and recommend scalable architecture solutions.
• Balance performance, cost, reliability, and maintainability across data platform implementations.
• Participate in production support and continuously improve platform stability and operational excellence.

Actual salary is determined based on the role, location, individual experience, skills, and other considerations. We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.