Sr. Database and Batch Prcoessing Developer

Job TitleSenior Batch and Database DeveloperWho We AreJennison Associates is a global investment management firm with over $200 billion in Assets under Management spanning across a range of various equity and fixed income investment strategies. Jennison was founded in 1969 on the principle that doing what’s best for clients will always be right for the business. Grounded in our firm values of integrity, collaboration and client focus, the mission across all areas of our firm is to deliver superior long-term investment returns and excellence in client service. This singular focus is embedded in our culture and reflected in the way we invest, the service we provide to our clients, and the people we hire. We recognize that each employee plays a key part in achieving our mission, regardless of their role or title. As a result, we continually strive to make Jennison a fulfilling and rewarding place to work for all employees. Our FunctionThe Investment Operations business department supports all aspects of the trade life cycle. The department is sub-divided into multiple groups: performance, trade support equity, trade support fixed income, etc. The Investment Operations Technology group is within Application Development and support this business department and lead the technology strategy to support all groups within this department. Your ImpactYour responsibilities will include, but are not limited to the following: Responsible for translating 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.Your Required SkillsYour required skills must include: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 i.e modelling dataDevelopment experience with Oracle version 12 or aboveExperience generating complex result sets using SQL including familiarity with i.e. analytic functionsExperience optimizing/tuning SQL queries including familiarity with i.e. generating and interpreting execution plans i.e. query processing, including selecting the optimal join execution methodologyExperience coding stored procedures in PL/SQL / T-SQL including familiarity with i.e. 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Power BI experience a plusSnowflake experience a plusWhat We OfferJennison offers a generous benefits package including but not limited to: premier medical benefits, paid time off, a retirement profit sharing plan, wellness reimbursement, fully paid parental leave, family planning support, paid membership to concierge primary care, supplemental mental wellness benefit provides annual allotment of fully paid therapy sessions and unlimited coaching, additional health and wellness benefits, and life insurance. Our hybrid work model provides employees with the flexibility to work remotely 2 days a week. The base salary range for this role is $190,000 - $215,000. Individual salaries for this role may vary based on various factors including but not limited to, years of experience, range in corporate level, candidate skills, and geographic location. Eligibility to participate in a discretionary annual incentive program is subject to rules governing the program, whereby an award, if any, depends on various factors including but not limited to, individual and organizational performance. Jennison is committed to treating all applicants and employees fairly and to providing equal opportunity in compliance with applicable federal, state and local laws. Jennison does not and will not discriminate against any employee or applicant for employment on the basis of race, religion, ancestry, color, gender, gender identity, pregnancy, age, physical or mental disability, national origin, marital status, sexual orientation, citizenship status, covered-veteran or military status, genetic information, and/or any other factor protected by law.

Minimum Salary: 190,000 Maximum Salary: 215,000 Salary Unit: Yearly