About Us
Mensio Mental Health is based out of Montreal, Canada and is founded by Dr. Benjamin Armstrong. Dr. Armstrong is a Clinical Psychologist (PhD) and is licensed by l'Ordre des psychologues du Québec (OPQ). He is trained in psychometric statistics and data science.
Mensio Mental Health is dedicated to the measurement and practice of clinical psychology. We empower patients to monitor, track and take better control of their mental health. We consult with enterprise mental health providers to design monitoring and tracking systems for group programs and organization-wide initiatives. Our aim is to help our patients and clients make the decisions they need to flourish. We are currently looking for a remote data analyst and engineer who can help us develop products in the Google Ecosystem and bring our mental health initiatives to life.
Responsibilities
Connecting existing questionnaire systems to cloud-based data solutions (i.e., BigQuery).
Developing automation for triggering emailed reports and information to patients and clinicians (using tools like AppScript, cloud functions, or etc.).
Visualization dashboards with controlled access for doctors and patients.
Managing data engineering infrastructure in Google ecosystem using BigQuery and other database tools
Creating SQL views and automation processes
Optimizing digital dashboards for speed and performance
Setting up A to Z data pipelines and digital reporting solutions for new clients including Google cloud user and role management
Requirements
Experience working with Google Cloud, SQL, scripting/automation in the Google ecosystem (e.g., AppScript, cloud functions) and Google Data Studio
Experience working with BigQuery in a data analytics and visualization context
Experience with management of Google Cloud accounts (users, roles, etc.) for new clients unfamiliar with this domain
Experience with custom (community) Data Studio visualizations
Excellent written and verbal communication skills
Experience automating in Google ecosystem with specific experience automatically generating reports
Flask/Plotly or equivalent(e.g. d3) experience would be a big plus
Being familiar with healthcare and mental healthcare specifically would be a big plus
To apply, please attach your resume via email and please include answers to these questions in your application:
Why would you be a good fit for this position?
Please tell us about your experience automating tasks and writing scripts inside the Google ecosystem. We are specifically interested in automatically generating reports when forms are filled out. How would you accomplish this?
What was your most recent rate as an hourly consultant or in a full-time salaried position? Please include BOTH hourly and salary information even if current role was one or the other.
How many years of experience do you have working with SQL, Google BigQuery, Appscript and Google Data Studio(each)?
Do you have any product development experience in the Google Ecosystem?
Job Type: Full-time
Experience:
SQL: 1 year (Required)
Google BigQuery: 1 year (Required)
Google Data Studio: 1 year (Required)
AppScript: 1 year (Required)
Language:
English (Required)