Senior Data Specialist

At Moody's, you unite with the brightest minds to transform today's risks into tomorrow's opportunities. We create an inclusive environment where everyone feels welcomed to be themselves, exchanging ideas freely, thinking innovatively, and listening to each other and customers in meaningful ways. If you are enthusiastic about this opportunity but don't meet every requirement, please apply! You may still be a great fit for this role or other open positions. We seek candidates who embody our values: investing in every relationship, leading with curiosity, championing diverse perspectives, turning inputs into actions, and upholding trust through integrity. Skills & Competencies: - 5-6 years of hands-on experience with Oracle Database, including the latest versions, in large-scale enterprise environments. - Strong expertise in SQL and PL/SQL programming, encompassing advanced logic and performance-optimized code. - Proficiency in Oracle analytical functions, collections, and advanced PL/SQL features. - Experience with query tuning using optimizer hints and execution plan analysis. - Working knowledge of Python and HTML for scripting and integration is a plus. - Experience with Databricks for data engineering and transformation tasks is a plus. Education: Bachelor's degree in Computer Science, Information Technology, or a related field. Responsibilities: - Design and develop advanced PL/SQL packages, procedures, and triggers for high-volume transactional systems. - Write and optimize complex SQL queries to support efficient data retrieval and transformation. - Utilize Oracle's advanced features to build scalable, high-performance data solutions. - Conduct performance tuning and troubleshoot query inefficiencies using execution plans and optimizer hints. - Collaborate with cross-functional teams to support application development and data integration initiatives. - Ensure data integrity and availability within large-scale enterprise database systems. - Contribute to database design, schema management, and data modeling efforts. - Maintain comprehensive documentation of technical specifications, procedures, and best practices. About the Team: Join a dynamic and collaborative team that thrives on innovation and data excellence. Working alongside talented professionals passionate about leveraging data to drive business impact, you'll be part of a forward-thinking organization. The team values continuous learning, cross-functional collaboration, and delivering high-quality solutions to support strategic decision-making. Candidates for Moody's Corporation may need to disclose securities holdings according to Moodys Policy for Securities Trading and position requirements. Employment is subject to compliance with the Policy, including remediation of positions in those holdings as necessary. For more information on the Securities Trading Program, please refer to the STP Quick Reference guide on ComplianceNet. Please note: STP categories are assigned by the hiring teams and are subject to change during an employee's tenure with Moody's.,