Jobs and Careers
IN
Senior Software Engineer - Data Stores
Insight MRemote (USA), United StatesRemotefull_timeVerifiedPosted 20 Apr 2024
About the role
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
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 t
Apply for this role
Generate a tailored application kit with a matched cover letter, interview prep, and CV highlights — in under 60 seconds.
Apply Now →Generate Application KitFree account required — sign up in 30s