Senior Data Specialist

At Moody's, we unite the brightest minds to turn today’s risks into tomorrow’s opportunities. We do this by striving to create an inclusive environment where everyone feels welcome to be who they are—with the freedom to exchange ideas, think innovatively, and listen to each other and customers in meaningful ways. 

If you are excited about this opportunity but do not meet every single requirement, please apply! You still may be a great fit for this role or other open roles. We are seeking candidates who model our values: invest in every relationship, lead with curiosity, champion diverse perspectives, turn inputs into actions, and uphold trust through integrity. 

Skills & Competencies:

• Must have: 5–6 years of hands-on experience with Oracle Database (latest versions preferred) in large-scale enterprise environments.
• Must have: Strong expertise in SQL and PL/SQL programming, including advanced logic and performance-optimized code.
• Must have: Proficiency in Oracle analytical functions, collections, and advanced PL/SQL features.
• Must have: Experience with query tuning using optimizer hints and execution plan analysis.
• Good to have: Working knowledge of Python and HTML for scripting and integration.
• Good to have: Experience with Databricks for data engineering and transformation tasks.

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. As part of a forward-thinking organization, you’ll work alongside talented professionals who are passionate about leveraging data to drive business impact. Our team values continuous learning, cross-functional collaboration, and delivering high-quality solutions that support strategic decision-making.

Moody’s is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, protected veteran status, sexual orientation, gender expression, gender identity or any other characteristic protected by law.

Candidates for Moody's Corporation may be asked to disclose securities holdings pursuant to Moody’s Policy for Securities Trading and the requirements of the position. Employment is contingent upon 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 over the course of an employee’s tenure with Moody’s.