Senior Data Engineer - Data warehousing/Python/AI

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.

• 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.
• Experience with cloud-based data platforms and modern analytics technologies.
• Exposure to AI, Generative AI, Agentic AI, Large Language Models (LLMs), and AI-enabled engineering tools.
• Experience using Microsoft Copilot, GitHub Copilot, Kiro, or similar AI productivity tools.
• Understanding of intelligent automation and AI-driven workflow design.

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

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., With over 50 years of experience, DTCC is the premier post-trade market infrastructure for the global financial services industry. From 20 locations around the world, DTCC, through its subsidiaries, automates, centralizes, and standardizes the processing of financial transactions, mitigating risk, increasing transparency, enhancing performance and driving efficiency for thousands of broker/dealers, custodian banks and asset managers. Industry owned and governed, the firm innovates purposefully, simplifying the complexities of clearing, settlement, asset servicing, transaction processing, trade reporting and data services across asset classes, bringing enhanced resilience and soundness to existing financial markets while advancing the digital asset ecosystem. In 2024, DTCC’s subsidiaries processed securities transactions valued at U.S. $3.7 quadrillion and its depository subsidiary provided custody and asset servicing for securities issues from over 150 countries and territories valued at U.S. $99 trillion. DTCC’s Global Trade Repository service, through locally registered, licensed, or approved trade repositories, processes more than 25 billion messages annually. To learn more, please visit us at www.dtcc.com or connect with us on LinkedIn, X, YouTube, Facebook and Instagram.

DTCC proudly supports Flexible Work Arrangements favoring openness and gives people freedom to do their jobs well, by encouraging diverse opinions and emphasizing teamwork. When you join our team, you’ll have an opportunity to make meaningful contributions at a company that is recognized as a thought leader in both the financial services and technology industries. A DTCC career is more than a good way to earn a living. It’s the chance to make a difference at a company that’s truly one of a kind.

Learn more about Clearance and Settlement by clicking here.

Serves as a dedicated technology resource for advancing DTCC’s business opportunities and providing industry thought leadership for leveraging new technology. The goal of this new department is to partner internally with IT, our business and regulatory divisions and externally with clients, regulators, and fintech vendors, to help build new platforms and business models to advance DTCC’s mission to support the financial markets.