Skip to Main Content

Database Analyst

Position Details

Position Information

Position Title Database Analyst
Department/Unit Biology
Research Project Ocean Tracking Network
Location Halifax, Nova Scotia, Canada
Posting Number GP33-23
Employee Group Grant-Paid
Position Type Term
Duration of Contract (if applicable) 1 year, with possibility of renewal
Employment Type Full Time
Full-time Equivalency (FTE) 1.0
Salary $60,000 - $70,000 per annum (37.5 hours per week)
About the Organization
The Ocean Tracking Network (OTN, http://oceantrackingnetwork.org/) is a global marine and freshwater monitoring platform that focuses on tracking the movements of aquatic animals in the context of ocean conditions and climate change. Established in 2008, OTN is one of 19 National Research Facilities supported by the Major Science Initiatives (MSI) program of the Canada Foundation for Innovation (CFI).
Job Summary
Reporting to the Database Manager, and under the guidance of the Director of Data Operations, the Database Analyst will play a lead role in expanding the OTN data system to accept satellite telemetry data. The Database Analyst is responsible for creating and maintaining data structures and data ingestion processes purpose-built for satellite data. The Database Analyst serves as an ambassador for OTN and is expected to network and interface with partners around the globe.
Key Responsibilities
  • Design, implement, and extend OTN’s database to accommodate new advances in satellite telemetry and other complementary data products.
  • Identify and execute improvements to database processes, such as designing, implementing, and maintaining data loading processes for the OTN data system; performing data processing, loading, and quality control and resolving technical issues with regards to application code and data quality, input, and export procedures.
  • Design, develop, and maintain OTN data quality procedures to assure accuracy, integrity, and security of the data. Tailor OTN procedures according to best practices for satellite data.
  • Design, generate, and automate the creation of OTN database products, including end-product development from loaded data.
  • Lead and/or assist with workshop delivery and development to train network users, including node managers, students, and early career researchers.
Note
The successful applicant will be eligible for hybrid work (combination of in-person work on campus and remote work) as agreed by all parties based on operational requirements and university guidelines.

Dalhousie’s vaccine mandate has been suspended at this time, and employees no longer need to provide proof of full vaccination. However, health and safety risks to our community will continue to be monitored and a vaccine mandate may be reinstated if necessary.
Required Qualifications
  • Undergraduate degree in computer science, informatics, marine biology, oceanography, or related field with a minimum of 3 years’ experience in data systems, data management, and information technology.
  • Strong familiarity with enterprise relational data systems (PostgreSQL preferred), with experience in database design and optimization of data systems.
  • Skilled with Linux administration and shell scripting.
  • Strong programming skills in Python or similar language, with direct experience with data manipulation and interaction with RDBs, data analysis, and data visualization techniques.
  • Demonstrated experience working with human-generated data and performing quality control measures.
  • Ability to work in a deadline-driven, high-volume environment, with high attention to detail.
  • Strong communication skills with the ability to work effectively as an individual and as part of a collaborative team.
Assets
  • Experience in biology or biological data systems.
  • Experience with geospatial data.
  • Fluency in additional languages, such as French or Spanish.
Additional Information
Dalhousie University supports a healthy and balanced lifestyle. Our total compensation package includes a voluntary RRSP, health and dental plans and an employee and family assistance program.
Application Consideration
We thank all applicants for their interest, however, only candidates selected for an interview will be contacted.
Diversity Statement
Dalhousie University commits to achieving inclusive excellence through continually championing equity, diversity, inclusion, and accessibility. The university encourages applications from Indigenous persons (especially Mi’kmaq), persons of Black/African descent (especially African Nova Scotians), and members of other racialized groups, persons with disabilities, women, persons identifying as members of 2SLGBTQ+ communities, and all candidates who would contribute to the diversity of our community. For more information, please visit www.dal.ca/hiringfordiversity.
Posting Detail Information

Number of Vacancies 1
Open Date 05/18/2023
Close Date 06/09/2023
Open Until Filled No
Special Instructions to Applicant
Quick Link for Direct Access to Posting https://dal.peopleadmin.ca/postings/13521

Documents Needed to Apply

Required Documents
  1. Résumé / Curriculum Vitae (CV)
Optional Documents
  1. Cover Letter