SQL Developer

Moody's - Charlotte, NC

Full-time - Mid Level

Charlotte, NC

Administrative and Support Services

About the position

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. The Software Engineer will be a member of the Enterprise Document Management System (EDMS) development team. This role requires a self-motivated, team-oriented individual responsible for the analysis, design, coding, and testing of Java/SQL based applications. Candidates must have hands-on operational experience with Java and SQL programming. We focus on a team consisting of individuals who love to work with each other, trust each other, and help/support each other. We succeed as a team and we fail as a team. If you want to join a team that embraces failure sooner rather than later, then look no further. We are an agile shop, and our focus is to deliver business value on a 2-week sprint interval.

Responsibilities

• Contributes to data and IT projects as a business-minded analyst, performing full lifecycle analysis including data profiling, requirements gathering and documenting, data mappings, process and data design flows, data quality controls input, and testing assistance.
• Establish and maintain a strong understanding of Moody's business processes and data needs of the assigned business project and/or Strategic objective.
• Work with business stakeholders to define, analyze, and document business requirements to help implement solutions consistent with the needs of Rating Groups and other strategic objectives, including use case development as needed for clear understanding by business and development teams.
• Provide support for business and data requirements.
• Ensure the various business applications maintained by Moody's Rating Tech reference the correct data sources, and facilitate consistent data structures and content across the organization.
• SQL skills for data profiling and analysis, and ability to reverse engineer existing databases with minimal assistance.
• Locate and define new process improvement opportunities.
• Perform ad-hoc data/process analysis as needed.
• Application code development using Java, T-SQL/PL/SQL.
• Write complex SQL queries for integration with other applications.
• Modify databases according to requests and perform tests.
• Solve database usage issues and malfunctions.
• Collaborate with the team to improve applications and establish best practices.
• Ensure all database programs meet company and performance requirements.
• Gather user requirements and identify new features.
• Develop technical and training manuals.
• Provide data management support to users.
• Requirement analysis, schema preparation and formulating test strategy.
• Design test cases/scenarios, execute test cases and documenting results.
• Recommend adoption of new technologies features in the application areas for operational excellence.
• Develop and implement appropriate troubleshooting tools/technologies for proactively identifying problems including steps to quickly triage the problem leading to faster time to resolution.
• Implement and maintain Application Code Security as part of CI/CD.
• Participate in Agile scrum teams and contribute to project planning and work prioritization.
• Be a strategic thinker.

Requirements

• Bachelor degree (or equivalent experience) in Engineering or IT-related field.
• Minimum 5 years of hands-on experience in SQL and Java development (spring boot, java, J2EE, Web services etc).
• Hands-on experience of supporting business applications using database technologies like - Oracle, MSSQL and/or PostgreSQL.
• Knowledge of Software Development Life Cycle including agile methodologies.
• Familiar with utilization of source code repository (GitHub/Bitbucket).
• Experience working in Agile environments, JIRA, Confluence.
• Financial Services industry experience a plus.
• Experience with Cloud, DevOps, CI/CD, and Data Reporting tools a plus.
• Ability to coordinate and assist teams to resolve complex analytical and technical issues.
• Excellent communication skills, ability to translate technical concepts to business concepts and vice versa.
• Client focused, proactive, and results oriented.
• Detail oriented - strong analytical skills and ability to process information quickly.

Nice-to-haves

• Experience with Cloud, DevOps, CI/CD, and Data Reporting tools a plus.

Benefits

• Medical insurance
• Dental insurance
• Vision insurance
• Parental leave
• Paid time off
• 401(k) plan with employee and company contribution opportunities
• Life insurance
• Disability insurance
• Accident insurance
• Discounted employee stock purchase plan
• Tuition reimbursement