Job Type: Officer of AdministrationBargaining Unit:Regular/Temporary: RegularEnd Date if Temporary:Hours Per Week: full-timeStandard Work Schedule:Building:Salary Range: $200,000-$300,000The salary of the finalist selected for this role will be set based on a variety of factors, including but not limited to departmental budgets, qualifications, experience, education, licenses, specialty, and training. The above hiring range represents the University's good faith and reasonable estimate of the range of possible compensation at the time of posting.

　　Position Summary

　　BACKGROUND:

　　Columbia University Investment Management Company, LLC, ("IMC") is a wholly-owned subsidiary of Columbia University charged with stewarding Columbia's endowment for the current and future support of operations and with preserving the purchasing power of the endowment over the long-term. Almost all funds are managed externally in a diversified strategy that uses active and passive management techniques across a range of asset classes.

　　The IMC seeks professionals who can contribute materially to the management of the portfolio. The IMC environment is one in which staff members are expected to develop professionally, work collaboratively, and assume greater responsibilities according to ability and impact.

　　POSITION SCOPE:

　　Columbia Investment Management Company is developing a next generation data analytics platform to support our portfolio management and investment selection process. A core component of our platform is the analysis of our portfolio, external investment managers and the ad hoc analysis of market sectors. We are seeking an experienced database developer and architect with deep relational database, data warehouse, cloud database and financial analytics experience to help build our platform. This role reports to the Chief Technology Officer.

　　The Database Architect / Developer will be critical to the design and development of all data storage, retrieval and analytics supporting portfolio management, portfolio analysis and manager selection. The Architect is responsible for new application development, enhancing existing applications as well as ongoing support.

　　Responsibilities

　　Provides hands on development expertise and leadership in product development with functional capabilities in portfolio management and investment selectionTakes a lead role in all phases of application development, including requirements gathering, analysis, design, development, testing, and deploymentEvaluates and selects the appropriate technology to support the analytical and data storage business needs of the IMCCoordinates and prioritizes tasks within the software development lifecycle in conjunction with the entire software team.Serves as database leader who contributes to peer code reviews and helps increase the database skills of the entire teamContributes to the ongoing enhancement of DevOps processes and proceduresLeads development of test plans and provides technical support in all phases of testing and QA.All other duties as assigned.Minimum Qualifications

　　Bachelor's degree in computer science or other relevant disciplineMinimum of five years related experience Other Requirements

　　Expert proficiency with SQL development experience including SQL ServerExperience with cloud-based databases such as Snowflake, Google BigQuery or Amazon RDSExperience with No-SQL stores including search stores preferred.Familiar with data pipelines and data transformationsExperience with AWS & cloud servicesFamiliar with automated testing, DevOps and CI/CDExcellent interpersonal, oral and written communication skills,Familiar with Git/Version ControlMust be detail-oriented with strong analytical skills and organized work habits.Must be able to identify priorities within multiple assignments in a high-pressured, short-deadline environment, and be able to work with diplomacy and efficiency in such an environment.Must be able to demonstrate excellent organizational, analytical, critical thinking, interpersonal, written and oral communication skills. Work well with all levels of employees, be flexible in nature, have sound judgment with an open and collaborative style that encourages teamwork and cooperation beyond the immediate team to the broader organization. Must have a passion for excellent customer service and commitment to exceptional quality.

　　Equal Opportunity Employer / Disability / Veteran

　　Columbia University is committed to the hiring of qualified local residents.

　　Minimum Salary: 31200.00Maximum Salary: 31200.00Salary Unit: Yearly