Sr. Database and Batch Prcoessing Developer

$190,000 - $215,000/Yr

Jennison Associates - New York, NY

Full-time - Senior

New York, NY

Securities, Commodity Contracts, and Other Financial Investments and Related Activities

About the position

The Senior Batch and Database Developer at Jennison Associates is responsible for translating functional designs into technical specifications, ensuring integration with existing systems. This role involves developing and maintaining documentation, performing impact analysis, designing software solutions, and troubleshooting production issues. The position plays a critical role in supporting the Investment Operations Technology group, which leads the technology strategy for the Investment Operations business department.

Responsibilities

• Translate functional design into technical specifications ensuring functionality and integration with existing systems/platforms
• Develop and maintain all documentation pertaining to a programming project that is detailed and accurate
• Perform detailed impact analysis and provide estimates for change requests across one or many complex projects
• Design and implement software solutions that are structured and easily maintained
• Create requests and provide governance to promote code to different environments based on firm standard
• Ensure code is versioned and checked into source control system
• Provide oversight to, as well as create deployment scripts and verify correctness within integration environment
• Troubleshoot production issues, document incidents, and provide timely fixes and drive problem resolution
• Perform creation of unit, functional, integration and performance testing and provide evidence of results.

Requirements

• Bachelor Degree in Computer Science or IT related field
• 15+ years of software development experience using relational databases
• Experience building Data Warehouses / Data Marts including familiarity with data modeling
• Development experience with Oracle version 12 or above
• Experience generating complex result sets using SQL including familiarity with analytic functions
• Experience optimizing/tuning SQL queries including familiarity with generating and interpreting execution plans
• Experience coding stored procedures in PL/SQL / T-SQL including familiarity with exception handling
• Experience in creating Autosys jobs and ETL process
• Strong analytical skills, including a thorough understanding of how to interpret business needs and translate them into application requirements

Nice-to-haves

• Power BI experience
• Snowflake experience

Benefits

• Premier medical benefits
• Paid time off
• Retirement profit sharing plan
• Wellness reimbursement
• Fully paid parental leave
• Family planning support
• Paid membership to concierge primary care
• Supplemental mental wellness benefit providing annual allotment of fully paid therapy sessions and unlimited coaching
• Additional health and wellness benefits
• Life insurance
• Hybrid work model allowing remote work 2 days a week