Full Time
New York
Posted 3 years ago

Moody’s is a global integrated risk assessment firm that empowers organizations to make better decisions

AVP – Sr Database Developer

Moody’s (NYSE: MCO) is a global integrated risk assessment firm that empowers organizations to make better decisions. Our data, analytical solutions and insights help decision-makers identify opportunities and manage the risks of doing business with others. We believe that greater transparency, more informed decisions, and fair access to information open the door to shared progress. With over 11,000 employees in more than 40 countries, Moody’s combines international presence with local expertise and over a century of experience in financial markets. Learn more at moodys.com.

Moody’s Investors Service is among the world’s most respected and widely utilized sources for credit ratings and research. Our opinions and analysis on a broad range of credit obligors and obligations are valued around the world for their insight and rigor. At MIS, our workplace culture supports our mission to be the Agency of Choice for our customers, employees and future employees. Our Culture focuses on Excellence and embodies behavioral qualities such as Integrity, Responsiveness, Collaboration, Respect and Passion. Our people are our core asset and we look beyond outcomes to ensure that behaviors and interactions matter.

Department

MIS Tech

Job Description

Senior Database Developer

This associate will provide expert database design, development, and maintenance skills primarily using SQL Server 2017 and Sisense in support of the Structured Finance Group.

DUTIES AND RESPONSIBILITIES:

Work with analysts to determine database needs and design and implement databases and associated data loading processes
Create SSRS reports and Sisense dashboards to enable analysts to dynamically analyze and visualize data
Create SQL queries, stored procedures, and SSIS packages to load, scrub, cleanse, modify data
Optimize and tune SQL statements and databases
Troubleshoot and resolve database issues
Define, test, and execute data validation routines
Database backup jobs and basic DBA tasks
Write documentation
Perform code reviews

Qualifications

QUALIFICATIONS:

Requirements

B.S. in Computer Science, Mathematics, or Engineering
5+ years of experience working as a database developer and/or DBA using SQL Server 2012 and higher
Clear understanding of logical and physical database design and data normalization concepts
Expertise in creation and management of databases, tables, views, and stored procedures
High level of proficiency with SSIS
High level of proficiency with SSRS
Ability to do algebra and simple statistics
Proven troubleshooting and problem resolution skills
Excellent problem solving skills with the ability to analyze complex tasks and propose viable solutions for both strategic and tactical development initiatives
Ability to work well in individual, team and high pressure situations
Very good oral and written communications skills
Proficiency with Microsoft Office suite including Word, Excel, and Outlook
Understanding of Microsoft Excel formulas

Pluses

Knowledge of Mortgage Backed and/or Asset Backed Securities loan-level data
Sisense
JIRA
Alteryx
Bitbucket or Github
Experience working in an Agile/Scrum environment
PostgreSQL
Excel/VBA
Access/VBA
VBA.net
C#.net
Sybase ASE
Python
R
Javascript
REST API and Web service

Moody’s is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, sex, gender, age, religion, national origin, citizen status, marital status, physical or mental disability, military or veteran status, sexual orientation, gender identity, gender expression, genetic information, or any other characteristic protected by law. Moody’s also provides reasonable accommodation to qualified individuals with disabilities in accordance with applicable laws. If you need to inquire about a reasonable accommodation, or need assistance with completing the application process, please email accommodations@moodys.com. This contact information is for accommodation requests only, and cannot be used to inquire about the status of applications.

For San Francisco positions, qualified applicants with criminal histories will be considered for employment consistent with the requirements of the San Francisco Fair Chance Ordinance. For New York City positions, qualified applicants with criminal histories will be considered for employment consistent with the requirements of the New York City Fair Chance Act. For all other applicants, qualified applicants with criminal histories will be considered for employment consistent with the requirements of applicable law.

Click here to view our full EEO policy statement. Click here for more information on your EEO rights under the law. Click here to view our Pay Transparency Nondiscrimination statement.

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.