Click here to apply: Job Openings (peoplehr.net)

 

Company Overview

Longevity Partners is a multi-disciplinary energy and sustainability consultancy and investment business. It was established in 2015 to support the transition to a low carbon economy in the UK, USA, Europe and worldwide.

Position Overview:

The company is recruiting a Database Engineer who can provide vision & creativity to new data environments that can transform the way Longevity Partners delivers value to its clients. This critical role is an exciting opportunity that will involve building and maintaining the development of a new database ecosystem that can enable information to move seamlessly throughout our company. An ideal candidate will use their extensive knowledge of back-end infrastructure to enable meaningful, human-oriented data products that can power critical decision-making both within Longevity and on behalf our clients. The team is currently managing a wide variety of internal and client-side projects, even though this position will not be responsible for interfacing directly with clients. This position reports to the Associate Director of Data Science + Analytics and is based principally in our offices in Austin, TX, with minimal expectations for travel.

Essential Functions

  • Build and maintain database ecosystems that are high-quality and reliable
  • Design + build both NoSQL + SQL database warehouses
  • Orchestrate data backups + recovery processes
  • Analyze database performance, pain points, and implement improvements to speed + efficiency
  • Ensure data security and protection across both storage and transfers
  • Help develop ETL and data pipeline maps
  • Provide thoughtful + responsive management support for database ecosystems
  • Define, enforce and document database policies, protocols and best-practices.
  • Design + perform tests and evaluations processes to ensure data security, performance, and integrity
  • Assist with monitoring databases, implementing required upgrades and resolving critical issues.

Requirements

  • 5+ years of experience as a Database Administrator or Architect
  • Extensive experience with database standards and developing end-user applications
  • Exceptional problem solving skills.
  • Excellent understanding of conventional SQL, query optimization and NoSQL databases (MongoDB, MariaDB, Cassandra, PostgreSQL, MySQL) as well as emerging tools like Apache Arrow, Arrow Flight, + DuckDB
  • Experience with cloud database management systems like Azure and AWS
  • Experience with time series databases preferred
  • Excellent knowledge of data backup, recovery, security, integrity
  • Experience with database design, documentation and optimization
  • Prior experience using DBA case tools (frontend/backend) and third-party tools
  • Knowledge and experience with Linux, shell, networking tools, and version control
  • Experience working and developing with APIs
  • ETL experience programming in R or Python
  • (Preferred) Experience designing and maintaining APIs or API wrappers
  • (Preferred) BS or graduate degree in a computer-related discipline or relevant certification

(Preferred) Experience or familiarity with Shiny, RStudio Connect, and Quarto

Benefits

  • Employee Health and Dental Benefits that are 100% Paid For by LP
  • Guaranteed 401k Retirement Contributions by Employer
  • Generous PTO Offerings
  • Fun and Relaxed Office Environment
  • Ability to work in a hybrid working environment