Senior Data Engineer - Data warehousing/Python/AI

Are you ready to make an impact at DTCC?

Do you want to work on innovative projects, collaborate with a dynamic and supportive team, and receive investment in your professional development? At DTCC, we are at the forefront of innovation in the financial markets. We are committed to helping our employees grow and succeed. We believe that you have the skills and drive to make a real impact. We foster a thriving internal community and are committed to creating a workplace that looks like the world that we serve.

The Information Technology group delivers secure, reliable technology solutions that enable DTCC to be the trusted infrastructure of the global capital markets. The team delivers high-quality information through activities that include development of essential, building infrastructure capabilities to meet client needs and implementing data standards and governance.

Pay and Benefits: 

• 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).

The Impact You Will Have in This Role

As a Senior Software Engineer within Enterprise Cloud Services, you will design, build, and support enterprise data platforms that power analytics, regulatory reporting, business intelligence, and operational decision-making across the organization.

You will partner with business stakeholders, architects, and engineering teams to deliver scalable, high-performing data solutions while driving innovation through data architecture, automation, advanced analytics, and emerging AI technologies.

Your Primary Responsibilities:

• Design, develop, and support enterprise data solutions across OLTP, data warehousing, reporting, and analytics platforms. 
• Partner with business and technology stakeholders to identify, prioritize, and deliver data-driven solutions that support strategic business objectives. 
• Develop and optimize database objects, including tables, views, stored procedures, and functions. 
• Create conceptual, logical, and physical data models supporting enterprise data initiatives and ECS Trade Repository platforms. 
• Develop and automate data processing workflows using Python, Perl, and Shell scripting. 
• Provide Level 3 production support, including incident triage, troubleshooting, root cause analysis, and issue resolution. 
• Improve data quality, platform performance, reliability, and operational efficiency through automation and continuous improvement initiatives. 
• Collaborate across architecture, engineering, and business teams to ensure solutions are scalable, secure, and aligned with enterprise standards. 
• Leverage AI, Generative AI, Agentic AI, Microsoft Copilot, GitHub Copilot, Kiro, and LLM-based tools to enhance development, automation, analytics, and knowledge discovery. 
• Incorporate risk and control practices into day-to-day responsibilities, proactively identifying and mitigating operational risk.

Qualifications

• Bachelor’s degree preferred or equivalent practical experience. 
• 6–8+ years of hands-on experience in software engineering, data engineering, database engineering, or enterprise data platform development.

Talent Needed for Success

• Strong experience with data warehousing, OLTP systems, business intelligence, and enterprise data solutions. 
• Advanced SQL development skills, including stored procedures, functions, views, performance tuning, and query optimization. 
• Hands-on experience with conceptual, logical, and physical data modeling. 
• Experience developing automation and data processing solutions using Python and Shell scripting. 
• Experience supporting production applications, including incident management, troubleshooting, and root cause analysis. 
• Strong understanding of data architecture, database design, data quality, and enterprise data management. 
• Ability to effectively partner with business stakeholders, architects, and engineering teams to deliver scalable technology solutions.

Preferred Skills 

• Experience within financial services, capital markets, trade repositories, regulatory reporting, or other highly regulated industries. 
• Knowledge of data governance, metadata management, data lineage, and data quality frameworks.