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. 

Job Summary:

We are seeking an experienced Senior Data Specialist to join our team. The ideal candidate will have extensive hands-on experience with the latest Oracle database versions and Databricks, particularly in a large enterprise environment. You will be responsible for designing, developing, optimizing, and maintaining complex SQL and PL/SQL solutions to support business analysis and data transformations.

Key Responsibilities:

• Design and develop advanced PL/SQL packages, procedures, and triggers for high-volume transactional systems.
• Write and optimize complex SQL queries for efficient data retrieval and manipulation.
• Leverage Oracle analytical functions, collections, and advanced features to build high-performance solutions.
• Perform query performance tuning using optimizer hints and execution plan analysis.
• Collaborate with cross-functional teams to support application development and data integration.
• Work within large-scale enterprise database systems, ensuring high availability and data integrity.
• Provide support for database design, schema management, and data modeling activities.
• Document technical specifications, procedures, and best practices.

Required Skills and Qualifications:

• Minimum 5–6 years of hands-on experience with Oracle Database (latest versions preferred).
• Proven experience working in large-scale enterprise database environments.
• Strong expertise in SQL and PL/SQL programming, including the ability to write complex logic and efficient code.
• In-depth understanding of Oracle analytical functions, collections, and advanced PL/SQL features.
• Solid knowledge and hands-on experience in query tuning using optimizer hints.
• Experience with Python and HTML for scripting and integration tasks.
• Experience with DataBricks.
• Excellent verbal and written communication skills.

Preferred Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.

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.