Database Architect/Developer-Hybrid Schedule
- Requisition no: 540725
- Work type: Full Time
- Location: Other NYC Locations
- School/Department: IMC
- Grade: Grade 14
- Categories: Information Technology, Finance/Accounting
- Job Type: Officer of Administration
- Bargaining Unit:
- Regular/Temporary: Regular
- End Date if Temporary:
- Hours Per Week: full-time
- Standard Work Schedule:
- Building:
- Salary Range: $200,000-$300,000
The 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 selection
- Takes a lead role in all phases of application development, including requirements gathering, analysis, design, development, testing, and deployment
- Evaluates and selects the appropriate technology to support the analytical and data storage business needs of the IMC
- Coordinates 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 team
- Contributes to the ongoing enhancement of DevOps processes and procedures
- Leads 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 discipline
- Minimum of five years related experience
Other Requirements
- Expert proficiency with SQL development experience including SQL Server
- Experience with cloud-based databases such as Snowflake, Google BigQuery or Amazon RDS
- Experience with No-SQL stores including search stores preferred.
- Familiar with data pipelines and data transformations
- Experience with AWS & cloud services
- Familiar with automated testing, DevOps and CI/CD
- Excellent interpersonal, oral and written communication skills,
- Familiar with Git/Version Control
- Must 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.