Data Analyst

Position Type:

 *

Closing date:

 *

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. As well, EMC 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, which are 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 even 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.

In addition, 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, to name a few.

There are lots of opportunities waiting for you in Nova Scotia. Apply now 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, which is 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) team. The Data Analyst will also work closely with Medavie, enabling effective collaboration and well-coordinated approaches. The Data Analyst will collaborate with the Data Analytics Team members to support the organizational performance reporting framework. The Data Analyst will work through the performance reporting lifecycle from requirements gathering with business owners and users through to execution of data analysis and data visualization. The Data Analyst will work with the team on Data Governance and represent the Data Analytics Team in projects and working groups. As the data and information contained in these systems is highly confidential, the Data Analyst will be expected to have experience with and understanding of data, system security, and privacy. The Data Analyst will be required to implement auditing and accountability processes. This position will have an in-depth understanding of the application databases, fields, and relationships with other data sources and provide data governance and support to other departments. As an employee of EMC we are accountable to our patients and coworkers by participating in and supporting all safety related initiatives, as well as acting in a manner that fosters a culture that focuses 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 various 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 appropriate documentation for queries and reports
• Support development of organizational performance reporting framework and generate KPI scorecards. Assists managers and others in the development of reports to measure outcomes that are meaningful to the organization, government and other stakeholders
• Maintain ETLs (Extract, Transform, Load protocols) between the different database environments, including test, production, reporting and data warehouses

Qualifications:

• University degree or Equivalent in Computer Science, Information Systems, Database Administration or relevant and adequate combination of training and experience required
• Minimum 2 years database/application support experience required. Five or more years’ database/application support experience 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 considered a strong asset
• Proficiency with SQL Server Reporting Service, SQL Server Integration Services is a strong asset
• Training in Microsoft operating systems and PC-based computer applications Proficiency with Microsoft Excel pivot charts, Vlookup, date functions, and graphs is considered a strong asset.

Knowledge and Skills:

• Excellent interpersonal skills with the ability to effectively communicate with various stakeholders, such as end-users, vendors, peers, various levels of leadership and IT staff
• Excellent written and oral communication skills
• Very strong organization skills with 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 proactively work independently with minimal supervision and works well in a team environment

 *

Our goal is to be a diverse workforce that is 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, persons with disabilities. Candidates who identify as being from any of these groups are encouraged to voluntarily self-identify.