Software Engineer - OAC & BI Publisher Developer

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