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:

The Development family is responsible for creating, designing, deploying, and supporting applications, programs, and software solutions. May include research, new development, prototyping, modification, reuse, re-engineering, maintenance, or any other activities related to software products used internally or externally on product platforms supported by the firm. The software development process requires in-depth subject matter expertise in existing and emerging development methodologies, tools, and programming languages. Software Developers work closely with business partners and / or external clients in defining requirements and implementing solutions. The Software Engineering role specializes in planning, documenting technical requirements, designing, developing, and testing all software systems and applications for the firm. Works closely with architects, product managers, project management, and end-users in the development and enhancement of existing software systems and applications, proposing and recommending solutions that solve complex business problems.

The Oracle Analytics Cloud (OAC) & BI Publisher Developer is responsible for designing, building, and maintaining Report Templates, operational reports, and interactive dashboards. Specialization in transforming complex XML data and SQL queries into highly formatted RTF templates to support enterprise business needs. .

Your Primary Responsibilities: 

• Template Development: Design, customize, and maintain pixel-perfect, customer-facing, and statutory documents using BI Publisher's RTF (Rich Text Format) 
• Data Modeling: Create advanced Data Models in BI Publisher utilizing complex SQL queries, PL/SQL, XML, and XSLT to extract and structure data from Oracle Fusion and OAC
• Interactive Analytics: Build and maintain interactive dashboards, analysis, and OAC data visualizations to support executive decision-making
• Report Delivery & Bursting: Configure report bursting (splitting/delivering report data to multiple destinations) and implement automated scheduling, printing, and emailing
• Develop applications in compliance with functional and non-functional requirements
• Construct unit test cases that ensure compliance with functional and non-functional requirements
• Follow design and code standards, contributing to continuous improvement discussions
• Create and maintain system documentation
• Align risk and control processes into day to day responsibilities to monitor and mitigate risk; escalates appropriately
• Contribute to the design of components or individual programs
• Provide production support for applications as needed
• Work with subject matter experts reviewing technical designs and specifications
• Apply different software development methodologies dependent on project needs
• Work with peers to mature ways of working, continuous integration, and continuous delivery
• Aligns risk and control processes into day to day responsibilities to monitor and mitigate risk; escalates appropriately

Qualifications:

• Minimum of 4 years of related experience
• Bachelor's degree preferred or equivalent experience

Talents Needed for Success:

• Performance Tuning: Optimize SQL queries, data models, and report rendering times to handle large-volume datasets efficiently.
• Cross-functional Collaboration: Work closely with business analysts and functional leads to translate business requirements into technical design specifications.
• System Maintenance: Troubleshoot report generation issues, validate data accuracy, and maintain system documentation for audit and compliance purposes. Required Technical Skills
• BI Publisher: Advanced proficiency in creating RTF templates using Microsoft Word and BI Publisher Desktop plugins.
• Database & SQL: Strong proficiency in writing and optimizing SQL and PL/SQL for structured data modeling.
• Oracle Tools: Solid experience with Oracle Analytics Cloud (OAC), Oracle PL/SQL. .

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.