Description:

Insight M is seeking a Software Engineer specializing in Data Stores at a Senior to Staff Level, with remote work options available in the USA or in Sunnyvale, CA.
The company focuses on innovative aerospace systems combined with advanced data science, primarily selling information rather than hardware.
Insight M has successfully removed methane emissions equivalent to over 250 million tonnes of CO2e since 2018, contributing significantly to climate change mitigation.
The software engineering team is integral to the company's operations, working with various technologies including Python, Bash, SQL, Terraform, and Typescript.
Responsibilities include ensuring the reliability and efficiency of a large PostgreSQL/PostGIS database cluster, optimizing data access patterns, and designing new data storage and analytics solutions.

Requirements:

Candidates must have a detailed understanding of modern SQL and NoSQL databases, including their tradeoffs related to query execution, storage, and communication.
A software development background, preferably in Python, is required.
Knowledge of database security best practices is essential.
Experience in analyzing and optimizing database schemas, queries, and supporting platforms is necessary.
Proficiency with PostgreSQL PostGIS queries and schemas is required.
Candidates should have experience with SQL, ORMs, and other database access methods.
Experience operating scalable, reliable database management systems in the cloud is needed.
The ability to provide expert consultations on database issues and address them directly is required.
Candidates must demonstrate a quick learning ability in a self-guided manner and a desire to solve real-world problems.
A belief in modern development practices, including code reviews and unit testing, is essential.

Insight M offers health, dental, and vision insurance, including subsidized coverage for dependents, with HSA and FSA options.
The company provides a 401K plan, short-term and long-term disability insurance, life insurance, and an Employee Assistance Program.
Employees are expected to maintain a work-life balance with a typical 40-hour workweek, and the company does not track vacation time or set office hours.
Insight M encourages flexible work arrangements, allowing employees to take mental health days, work from home, and adjust their schedules as needed.
The company has transitioned to 100% remote work and plans to continue offering remote positions indefinitely.