Senior Software Engineer - Data Stores

Remote (USA)
Software Engineering /
Full Time /
Remote
About Insight M

At Insight M, we combine innovative aerospace systems with advanced data science. Unlike traditional aerospace companies, we sell information, not hardware - we operate our sensors cost-effectively at continental scale to produce novel data streams about pressing global problems.
 
First on our list: spotting hard-to-monitor emissions of methane, a potent greenhouse gas that accelerates climate change. Since starting continuous survey operations in 2018, Insight M has removed methane emissions equal to over 72.6 million tonnes of CO2e through our work. To put that in perspective, that’s equivalent to over 15.8 million cars being removed from the roads or shutting down about forty-seven 350 MW coal-fired power plants for a year.
 
We call that a good start.
 
As a team, we love science and engineering, we love getting our hands dirty with hardware and software, and we love seeing our work make a difference in the real world.
 
We’ve created a diverse, collaborative, supportive, and fun environment based on integrity and treating people right. So no matter your sex, gender, sexual identity, gender identity, race, age, beliefs, sexual orientation, or disabilities, we welcome you and would like to work with you. :-)
 
It’s never boring, it’s always challenging, and we’re usually laughing.

A note of encouragement: If you don't meet 100% of the qualifications below, you should still seriously consider applying. Studies show that you can still be considered for a role if you meet just 50% of the role's requirements.

Individuals with a disability are encouraged to contact [interview.accommodations@insightm.com] to request assistance with your application and accommodations in advance of your interview. 

Software Engineering at Insight M

Everything that Insight M does is driven by software, from recording sensor data while flying at 3000', to ephemeral high-scale cloud-native data processing, to computer-aided GIS analysis, to using machine-learning to extract structured information from geopixels.
 
The software engineering team is involved in every step of our process, building the automation that allows Insight M to not only image things that humans have never seen before but to do it reliably, repeatably, inexpensively, and quickly. (Yes, you can have all four).
 
We work primarily in Python, with a smattering of Bash, SQL, Terraform, and Typescript when it makes sense.

We work on single-board-computers, field laptops, in virtualized cloud environments, in containers, inside of web browsers, and even inside lab automation frameworks.
 
We practice compositional engineering, tying together disparate pieces of technology to create novel artifacts that solve real-world problems.
 
We practice continuous integration and deployment, automated testing, and have a lovely monorepo.
 


Senior Software Engineer - Data Stores at Insight M

Responsibilities:

    • Ensure our large PostgreSQL/PostGIS database cluster is operating reliably and efficiently.
    • Ensure application developers and data analysts are well prepared to make effective use of our databases and data stores.
    • Analyze and optimize our data access patterns and storage.
    • Effectively represent the systems perspective in collaborations on managing our data lifecycle.

Must haves:

    • A detailed understanding of how modern SQL and NoSQL databases work and their tradeoffs, including query execution, storage, and communication.
    • A software development background.
    • Knowledge of database security best practices.
    • Experience analyzing and optimizing database schemas, queries, and supporting platforms.
    • Experience with PostgreSQL PostGIS queries and schemas.
    • Experience working with SQL, ORMs, and other means of database access.
    • Experience operating scalable, reliable database management systems in the cloud.
    • Ability to offer other developers expert consultations on database issues as well as directly address database issues yourself.
    • The ability to learn quickly in a self-guided manner - much of what we do is solving new problems by integrating one or more pieces of new technology.
    • A desire to solve real-world problems over working on technical problems in isolation - none of our work fits in neat boxes.  Instead, we have a team that is focused on the impact our work can have on the future of life on the planet and prioritizes real-world progress over problem-focus purity.
    • A belief in modern development practices - we do things like code reviews, unit testing, minimal-viable products, and fast development iteration.  We eschew the zealous practice of any development-process religion, but we do pick and choose techniques that help us write better software

Nice to haves

    • Experience defining database best practices and teaching classes on them.
    • Strong software development skills in Python.
    • Experience building internal user-facing applications.
    • Detailed domain knowledge in geospatial analysis.
    • Experience working in a resource-constrained startup environment.
    • Complementary experience such as: site reliability engineering, systems administration, technical consulting, technical instruction.
    • Familiarity with tools we commonly use, such as: Bazel, Docker, Bash, Ansible, Terraform, CircleCI, NumPy, Jupyter notebooks.
$138,400 - $233,000 a year
Nationwide range
Additionally: bonus + equity + 401k w/match

To avoid bias and create an equitable salary structure, at Insight M, we are intentional about our pay strategy. We base compensation on current position (role and skill level) and location. Since many of our roles are remote, we create a national range for our open positions that is built to cover both low and high-cost-of-living locations. If you live in a low cost of living area, the location-specific range will fall towards the lower end of the nationwide range. If you live in a high-cost-of-living area, the location-specific range will be on the higher end of the nationwide range. 
Life at Insight M

A few important facts about working at Insight M:
 
- We provide health, dental, and vision insurance, including subsidized coverage for dependents. Our 401K plan does matching based on the amount of methane we removed from the atmosphere in a given year.
 
- We think death-march hours are a bad way to run a company. We expect something approximating a 40-hour workweek, but mostly we just care that your work gets done. No, really. (Full disclosure: we occasionally put in some extra hours during crunch periods, but that is the exception, not the norm).
 
- We do not track vacation time, nor do we have set hours to be in the office. Instead, we encourage taking real vacations, mental health days, leaving early to pick up the kids, working from home, time-shifting commutes, staying home when you're sick, ducking out to the gym - we believe work time should be flexible.
 
In this time of the Covid-19 pandemic, we have transitioned to 100% remote work aside from hardware and flight operations and plan to continue having remote positions in perpetuity.
 
(We love it when kids make a cameo in a video call.)