Applications Analyst - Data Conversion

St. Joseph's Healthcare Hamilton; Southwestern Ontario; Hybrid; CAD 60,000 - 80,000; Full time

Job summary

A healthcare organization is seeking an Applications Analyst to support the implementation of Epic's health information system. The role involves leading data conversion activities, collaborating with various stakeholders, and ensuring data integrity throughout the conversion process. Applicants should possess a relevant bachelor's degree and three to five years of experience in data conversion, application analysis, or system integrations. This temporary full-time position is located in Ontario with a focus on enhancing patient care and operational efficiencies.

Qualifications

• Three to five years experience in application analysis, data conversion, or data migration projects.
• Demonstrated experience working on enterprise software implementations or system integrations.
• Experience in documenting data conversion processes and creating data mapping specifications.

Responsibilities

• Lead and execute data conversion activities for new system implementations.
• Collaborate with business analysts to gather data requirements.
• Perform data quality checks and reconciliation to ensure data integrity.

Skills

Data Conversion

Analytical Skills

Report Writing

Communication Skills

Team Collaboration

Education

Bachelor’s degree in Computer Science, Engineering, Business, or relevant clinical field

Tools

Crystal Reports

Microsoft SQL Server

ETL tools

Job description

Position Details

Posting #: 32398

Department: Joseph Brant Hospital Connect - Implement Team

Employee Type: Temporary, Full Time

If Temporary, Number of Weeks: 60

Union: Non-Union

Openings Remaining: 1

Reason for Posting: This position is for an existing vacancy.

Schedule

Work Days: Monday to Friday, Weekends

Time of Day: Days, Evenings, On-Call

Shift: 7.5 hour

Shift Start: Hours are subject to change based on operational requirements.

This position may be scheduled at any of the following sites: Charlton Campus (Hamilton Downtown), Hybrid - On-site/Remote

Application Dates

Opening Date: 07/10/2025

Closing Date: Applications must be received online by 12:00 midnight on the Closing Date

Position Summary

Reporting to the Manager, Business Applications and Integrations, the Applications Analyst performs a variety of duties related to the implementation, development, and day‑to‑day support of "department specific" packaged software and custom computer applications. This includes responsibility for the efficient design, scripting, testing, and maintenance of moderately complex "department specific" applications and liaison with end users to analyze requirements, identify and investigate potential solutions, assess feasibility of solutions considering available technology, budget, and end user requirements, and recommend solutions. The Application Analyst will learn and support a variety of applications across multiple computer platforms, make recommendations for future enhancements, and investigate/correct problems to optimize application use and improve business processes. The Application Analyst will work with users to understand data access/report requests to develop queries and reports and will serve as a liaison between user departments & Information Technology professionals to support and implement changes.

The primary focus for the successful applicant will be Data Conversion.

Project Description

St. Joseph’s Healthcare Hamilton (SJHH) and Joseph Brant Hospital (JBH) are embarking on an exciting digital transformation project to implement Epic’s health information system (HIS) at JBH.

In this partnership, JBH will adopt SJHH’s version of Epic’s health information system (HIS), which is branded Dovetale. Both organizations will support the shared instance of Dovetale following the project’s implementation. The project goals are to enable safer patient care, empower healthcare providers and staff, make care more efficient, and improve the overall patient experience at JBH.

Travel Requirements

The successful candidate will be part of an Integrated Team that will work closely with subject matter experts and leadership at JBH, SJHH, and Epic to carry out the implementation and would be active participants in joint and local committees. While remote work is supported, you will be required to travel to SJHH and JBH locations regularly to complete project activities. For successful candidates hired without Epic certification, you must hold valid travel documentation as you will be expected to travel to the United States to complete your certification requirements whenever required.

Qualifications

• Bachelor’s degree in Computer Science or Engineering or Business, or relevant clinical field.
• Three to five years recent related experience supporting packaged software and custom developed applications (preferably in a healthcare environment).
• Three to five years of recent related experience in application analysis, data conversion, or data migration projects (preferably in a healthcare environment).
• Three to five years of recent related experience working on enterprise software implementations or system integrations (preferably in a healthcare environment).
• Demonstrated skill with report writing tools (i.e., Crystal Reports, Microsoft SQL Reporting Services).
• Demonstrated experience working with a relational database system (i.e., Microsoft SQL Server, Oracle, MySQL).
• Experience with data conversion methodologies, including data mapping, cleansing, validation, and transformation.
• Strong analytical skills with the ability to interpret complex data sets and identify inconsistencies or anomalies.
• Experience in documenting data conversion processes and creating data mapping specifications.
• Demonstrated ability to work in multi-functional teams.
• Demonstrated ability to work independently and complete and deliver work assignments on time.
• Demonstrated effective verbal and written communication skills.
• Demonstrated skills in business process reengineering and process flow/mapping.

Responsibilities

• Lead and execute data conversion activities for new system implementations, upgrades, or migrations.
• Collaborate with business analysts, developers, and stakeholders to gather data requirements and understand legacy and target system structures.
• Design and document data mapping, transformation, and validation rules to ensure accurate and complete data migration.
• Develop and run scripts or use ETL tools to extract, transform, and load (ETL) data from source systems to target applications.
• Perform data quality checks and reconciliation to ensure data integrity throughout the conversion process.
• Troubleshoot and resolve data-related issues, including mismatches, formatting errors, and missing values.
• Create and maintain detailed documentation of data conversion processes, including mapping specifications, test plans, and validation results.
• Participate in project planning, status meetings, and provide regular updates on data conversion progress and risks.
• Ensure compliance with data governance, privacy, and security standards throughout the data conversion lifecycle.
• Provide post-conversion support and assist in resolving any data-related issues after go‑live.
• Work closely with project managers and team members to align data conversion efforts with project timelines and deliverables.
• Primary contact and coordination point for issue resolution in relation to the supported "department specific" applications; responsible for engaging with the application vendors for support, upgrades, and escalation issues.
• Participate as a co-chair of selected Application Support teams for select applications, consisting of end users, members from the Clinical Informatics and Information Services teams and vendors.
• Support various Information Technology and Hospital project initiatives; provides data and configuration changes, system testing, prepares documentation of change specifications and participates in go‑live support.
• Creates and maintains documentation on "department specific" applications and troubleshoots application issues, including changes in scripting, the creation of functional design documents and other relevant documents for end users.
• Reviews and discusses business problems with end users, developing flow charts and functional specifications to translate business requirements into technical requirements.
• Performs "end user" data review and analysis to develop new and improve existing medium‑complexity reports.
• Provides technical guidance for evaluation of software applications primarily departmental.
• Analyzes and reviews enhancements for compatibility, adherence to operating guidelines and performs integration testing.
• Prepares and presents status reports and ad hoc reports, creates test plans, analyzes test cases, identifies issues and escalates them to appropriate teams and assists management in the interpretation of available information.

HOURS OF WORK

Monday-Friday, days. May include evenings, weekends and on-call as required.

Rate Of Pay

$43.4365 (min) - $50.3509 (max)

Equal Opportunity and Accommodation Statement

St. Joseph’s Healthcare Hamilton (SJHH) is an equal opportunity employer and strives for equity, inclusiveness, and diversity in all our programs, practices, facilities, and people. We foster a culture of patient and staff safety where all positions comply and work in conjunction with the Mission, Vision, and Core Values of SJHH. We thank all applicants for their interest, however, only those selected for an interview will be contacted. SJHH is committed to a barrier‑free recruitment and selection process - please inform us should accommodation be required at any point in the recruitment process.