Modo has a lot of data, and we’re looking for someone to wrangle it!

If you enjoy writing a perfect SQL query, you’ve got a deep respect for data security, you know your way around configuring & tuning a PostgreSQL database, and you’re interested in helping us grow our data pipelines & visualizations over the next few years – we’d love to hear from you!

We’re seeking a data-lover who can manage our entire data stack, from database configuration to SQL reports.

WHO WE’RE LOOKING FOR – A BIT ABOUT YOU!

As our Database Report Writer & Administrator, you’ll help fulfill Modo’s promise of an exceptional carsharing experience by keeping our databases fast & secure, cleaning the data inside them, and delivering not just data but information that drives our policy and geographic decision-making.

Modo strives to build a team that reflects the diversity of the communities we serve – including diversity in thought and experience – leading to more innovation. We are open to candidates from any of our operating regions in British Columbia.

Here’s a run-down of what you’ll be doing:

Extracting data – probably about 70% of the job

Custom queries: We back up our decisions with data, but every new decision needs a different way of looking at the world. As the person who knows our databases best, you’ll write and run custom SQL queries for Modo’s Leadership Team.
User-accessible reports: We maintain a suite of standard reports for both staff and enterprise members. You’ll maintain them, performing updates and bug fixes as needed, and recommending which old queries to deprecate.
Periodic reports: Weekly or annually or anything in between, we take snapshots to check how we’re doing. You’ll make sure these reports run on schedule, and get the information to the people who need it.

Managing the database – probably about 30% of the job

Configuration and recovery: You’ll make sure our database clusters are configured correctly, and work with our IT team to make sure that they have the server resources they need. You’ll also oversee recovery if things ever go so badly that we need to recover our database from backup (but let’s hope that only comes up in practice runs).
Database tuning: You’ll monitor performance and recommend improvements, whether that looks like writing new indexes, requesting system environment changes from the IT team, or reporting slow queries to the Software team.

What about data pipelines and visualization? —Well, we want more of them, and we hope that over time, this role will grow to include them. Right now there’s quite a backlog of reports, so you may not do much pipeline or visualization work to start with, but you should be interested in learning more.

QUALIFICATIONS, SKILLS, AND EXPERIENCE

We’ll be honest, you’re unlikely to get the job unless your education or experience gives you most of the following:

fluency in SQL
at least 2 years of experience managing a relational database cluster (PostgreSQL preferred)
some experience with pl/pgsql

We’d also love to know how you demonstrate these attributes that are just as important to succeed as part of our team:

a technical mindset with exceptional accuracy, precision, and attention to detail;
great communication skills – in particular the ability to distill complex information into salient points;
strong analytical skills, with the ability to collect, organize, and analyze complex data sets;
strong personal initiative and willingness to get involved with your team;
the utmost professionalism and attention to confidentiality;
some lived experience that gives you a different perspective from the way things are “always done”

Because this role directly manages our members’ personal data, any successful candidate must also pass a criminal record check.

AND NOW, A BIT ABOUT MODO!

Modo is a co-op founded on social purpose: we transform communities by connecting people with places in a way that’s affordable, convenient, inclusive, and sustainable. Driven by people – not profit – Modo was the first carshare to open shop in BC back in 1997. Our promise is to provide an exceptional carsharing experience.

Modo is a leader in the ever-changing shared mobility space, and our brand is well-recognized and respected. Our employees share a passion for social impact; it’s what draws us together to do our best.

Modo operates on the shared territories of many First Nations. Unceded because most Indigenous Peoples in this province never entered into Treaty with the Canadian government and shared because Indigenous lands are not divided by borders. Our main office is located on the unceded and shared ancestral lands of the xʷməθkʷəy̓əm (Musqueam), Sḵwx̱wú7mesh (Squamish), and Sel̓íl̓witulh (Tsleil-Waututh) Nations.

We and our members live and work on these lands and our cars move across them. We appreciate and respect the long-standing tradition of Indigenous Peoples in caring for the land. We recognize the harm caused to the environment – land, air, and water – through the use of vehicles and commit to reducing that harm as a core part of our Purpose.

WHAT WE OFFER OUR EMPLOYEES

The best thing about working at Modo is our people. Everyone feels strongly connected to Modo’s purpose, and we respect one another and foster a sense of belonging. This is an exciting time for Modo, and this position is an opportunity to make your mark in an exciting industry.

You’ll have the continued support of a close-knit team who are committed to your success.

Modo’s offered salary range for this role is $65,000 to $68,000 per year, plus eligibility to participate in any bonus programs that the co-op makes available each year. Modo also invests in your training and development, and we offer attractive health and wellness benefits – including a comprehensive extended health and dental plan from day 1, generous sick days, a monthly health and fitness benefit, and a discount on Modo usage!

We are currently screening for applicants within any of our British Columbia operating regions, including the Okanagan, Nanaimo, Squamish, Greater Victoria, and Metro Vancouver. Our work culture is dynamic and flexible between office-based work and remote. Modo will provide you with a laptop for access to all required systems.

HOW TO APPLY AND WHAT TO EXPECT

We encourage you – yes, you! – to apply, even if you feel you don’t meet all the requirements on our wish list. We value intelligence and creativity and know that some skills can be learned on the job.

Please send your resume and a short cover letter to ‘jobs@modo.coop’ explaining why you think you’d be a great fit for our data systems. As part of your application, please include two SQL code samples, with comments where appropriate:

A SELECT query, containing at least two types of table join and at least one aggregate function
A CREATE FUNCTION query for a volatile pl/pgsql function that returns multiple rows

(Why do we ask for a cover letter and two SQL samples? Mainly to confirm that you’ve actually read this far. You’d be amazed how many tech resumes are sent automatically, on behalf of people who don’t even know they’ve applied! Following these instructions will immediately put you in the top 5% of applicants.)

APPLY NOW

We appreciate and respect your effort in reaching out to us and will do our best to keep you informed throughout the recruitment process.

As an employer committed to equity, diversity, and inclusion, Modo especially welcomes applications from folks identifying with historically, persistently, and/or systemically underrepresented groups – if that speaks to you, you’re invited to let us know when you apply. If you require any accommodation for any reason, please let us know when you email us with your resume, cover letter, and code samples.

We wish you the best with your application and can’t wait to learn more about you!

Trip Calculator

How much will it cost?

What kind of vehicle do you need?