Data Analyst

Medavie; Dartmouth; On-site; CAD 60,000 - 80,000; Full time

Job summary

A health services provider in Nova Scotia is seeking a Data Analyst to manage data and application support within the organization. The role involves collaborating with technology support teams, generating automated reports, and participating in data governance. Candidates should have a degree in a related field, at least two years of experience in database support, and proficiency with SQL, Power BI, and Visual Studio. This is a permanent position with opportunities for professional growth.

Qualifications

• University degree or equivalent in a relevant field required.
• Minimum 2 years database/application support experience required.
• Proficiency with SQL is required.

Responsibilities

• Generate and distribute automated reports and visualizations.
• Conduct quality assurance for reports ensuring accuracy.
• Maintain documentation for queries and reports.

Skills

SQL

Interpersonal skills

Problem solving

Organizational skills

Data analysis

Education

University degree in Computer Science or related field

Training in business intelligence tools

Tools

Power BI

Visual Studio

SQL Server Management Studio

Microsoft Excel

Job description

Position Type: Permanent

Closing date: 2025-10-05

Overview

Emergency Medical Care Inc. (EMC) is a wholly owned subsidiary of Medavie Health Services (MHS) that manages and operates ground ambulance, air medical transport and the medical communications operations in Nova Scotia through a performance-based contract with the provincial government's Emergency Health Services (EHS) Operations division and the Department of Health and Wellness. EMC also operates TeleHealth/811 medical communications for Nova Scotia and Prince Edward Island for the Department of Health.

We access all communities in Nova Scotia in a timely and efficient manner with our fleet of more than 180 ambulances and support vehicles operating out of 60+ stations. We respond to 165,000+ calls annually across the province, actively managed through the EHS Operations Medical Communications Centre, the hub of all emergency (911) and non-emergency (hospital transfers) medical calls. The EHS Operations LifeFlight program provides greater accessibility by responding to patients on scene or through inter-facility transports by our critical care team via helicopter, fixed wing, or ground ambulance. Paramedics in Nova Scotia participate in various programs both urban and rural such as community-based paramedic programs, collaborative emergency centres, and emergency preparedness and special operations, among others. Opportunities await in Nova Scotia; apply to learn more about our service and available positions.

Nature and Scope

The Data Analyst will report to the Data Analytics Supervisor and have reporting responsibility to the Manager of Applications and Data Management. The Data Analyst will be a member of EMC's Data Analytics Team, responsible for data management and application support across the organization and will work closely with EMC/Medavie Health Services Information Technology Support (EMC/MHS ITS). The Data Analyst will also collaborate with Medavie to enable effective collaboration and well-coordinated approaches. The Data Analyst will work with the Data Analytics Team to support the organizational performance reporting framework, from requirements gathering with business owners and users through to execution of data analysis and data visualization. The Data Analyst will participate in Data Governance, represent the Data Analytics Team in projects and working groups, and ensure an understanding of application databases, fields, and relationships with other data sources to provide governance and support. As an EMC employee we are accountable to our patients and coworkers by participating in safety initiatives and fostering a culture focused on patient safety and a healthy, safe, and respectful workplace.

Responsibilities include but are not limited to:

• Generate and distribute automated reports and system performance visualizations using tools including Visual Studio, PowerBI, SQL Server Management Studio, and Excel
• Conduct quality assurance activities to ensure reports are accurate and delivered in a timely fashion
• Create and maintain documentation for queries and reports
• Support development of organizational performance reporting framework and generate KPI scorecards. Assist managers and others in developing reports to measure outcomes meaningful to the organization, government and other stakeholders
• Maintain ETLs (Extract, Transform, Load protocols) between different database environments, including test, production, reporting and data warehouses

Qualifications

• University degree or equivalent in Computer Science, Information Systems, Database Administration or a relevant and adequate combination of training and experience required
• Minimum 2 years database/application support experience required; five or more years preferred
• Training, certification and/or significant experience in databases required
• Proficiency with SQL required
• Training/certification in business intelligence tools such as Visual Studio and Power BI is a strong asset
• Proficiency with SQL Server Reporting Services and SQL Server Integration Services is a strong asset
• Training in Microsoft operating systems and PC-based applications; proficiency with Microsoft Excel pivot charts, VLOOKUP, date functions, and graphs is a strong asset

Knowledge and Skills

• Excellent interpersonal skills with the ability to communicate effectively with end-users, vendors, peers, leadership and IT staff
• Excellent written and oral communication skills
• Strong organizational skills with the ability to prioritize and multi-task effectively
• Adaptable in a rapidly changing environment
• Strong problem solving and analytical skills with the ability to analyze data and make recommendations
• Ability to work independently with minimal supervision and also work well in a team

Our goal is to be a diverse workforce representative of the citizens we serve. We are committed to building an inclusive team that represents a variety of backgrounds, cultures, races, perspectives and skills. We encourage applications from all qualified candidates including women, persons of any sexual orientations and gender identities and/or expressions, Indigenous persons, African Canadians, other racialized groups, and persons with disabilities. Candidates who identify as belonging to these groups are encouraged to voluntarily self-identify.