Senior Data Engineer - Data warehousing/Python/AI

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.

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

The salary range is indicative for roles at the same level within DTCC across all US locations. 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.