Deloitte Specialist Senior/Specialist Master, Database Developer, Securitization in New York, New York
Deloitte is one of the leading professional services organizations in the United States, specializing in audit, tax, consulting and financial advisory services with clients in more than 20 industries. We provide powerful business solutions to some of the world s most well-known and respected companies, including more than 75 percent of the Fortune 100.At Deloitte, you can have a rewarding career on every level. In addition to challenging and meaningful work, you ll have the chance to give back to your community, make a positive impact on the environment, participate in a range of diversity and inclusion initiatives, and find the support, coaching, and training it takes to advance your career. Our commitment to individual choice lets you customize aspects of your career path, your educational opportunities and your benefits. And our culture of innovation means your ideas on how to improve our business and your clients will be heard.Deloitte is one of the leading professional services organizations in the United States specializing inaudit,tax,consulting, andfinancial advisory serviceswith clients in more than 20 industries. We provide powerful business solutions to some of the world's most well-known and respected companies, including more than 75 percent of the Fortune 100. At Deloitte, you can have a rewarding career on every level. In addition to challenging and meaningful work, you'll have the chance to give back to your community, make a positive impact on the environment, participate in a range of diversity and inclusion initiatives, and get the support, coaching, and training it takes to advance your career. Our commitment to individual choice lets you customize everything from your career path to your educational opportunities to your benefits. And our culture of innovation means your ideas on how to improve our business and your clients' will be heard. Visitwww.deloitte.com/us/careersto learn more about our culture, benefits, and opportunities. Deloitte & Touche LLP, which provides audit and advisory services, helps clients understand the complexity of issues such as performance, privacy, risk, controls, and data analysis. Financial Risk, Transactions & RestructuringTheFinancial Risk, Transactions & Restructuring (FRTR) market offering provides products and services that support the complex life cycle of structured financial products.The Financial Technologies group within FRTR designs, licenses and supports a variety of commercial applications serving the securitization, mutual fund and asset management markets. Our service offerings include operational and process assessments, and quantitative solutions to support the issuance and ongoing administration of all types of financial instruments including complex derivatives, securities, commodities and other investment products. Our core capabilities include transaction related due diligence, analytics and cash flow modeling, structural and document review and post-closing compliance. We license a full range of proprietary technology solutions, customized to the needs of market participants. Finally, we provide advisory services to financial institutions, governmental agencies, finance companies, and commercial entities that participate in the Structured Products market.Required Qualifications: 3-5 years of database development (tables, indexes, triggers, stored procedures/functions) for both SQL Server and Oracle In depth knowledge of T-SQL and PL/SQL including the recent language and database features added in the latest versions of SQL Server and Oracle Experience with query tuning and optimization Ability to effectively manage their work while dealing with multiple deadlines Experience working with large databases (millions of rows per table) Experience troubleshooting performance problems from both database and hardware standpoint Financial industry experience Excellent communication skills (both written and oral) including ability to effectively communicate with business stakeholders Optional Qualifications: Knowledge of .NET (specifically C#) development Knowledge of structured finance Experience with NoSQL databases Experience with data warehouse development Knowledge of Crystal Reports/SSRS Knowledge of basic financial accounting terminology and calculations (such as):o Principalo Interesto Accrualso Amortizationo Net Present Valueo IRRo Cash flows,o Write-offso Repurchaseso RecoveriesResponsibilities: Work closely with business users to develop and support set of stored procedures and user defined functions used to perform variety of business calculations using either Oracle or SQL Server databases Troubleshoot performance and data issues both on local environments as well as once code is deployed to the client Be available to support clients during deployment of our code to production environment (might include off-work hours including late nights and weekends) Provide leadership around implementing best practices for database development Work with clients to help with performance issues as data volumes and system use cases evolve Work with developers to conduct code reviews for database artifacts to make sure that best practices are being followed
As used in this document, Deloitte means Deloitte LLP and its subsidiaries. Please see www.deloitte.com/us/about for a detailed description of the legal structure of Deloitte LLP and its subsidiaries. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or protected veteran status, or any other legally protected basis, in accordance with applicable law.
Disclaimer: If you are not reviewing this job posting on our Careers site (careers.deloitte.com) or one of our approved job boards we cannot guarantee the validity of this posting. For a list of our current postings, please visit us at careers.deloitte.com.