Senior Data Analyst - SQL Lead

Ontario (ON)  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Keywords

Description

Plexxus provides leading edge business support solutions to Ontario's health care sector. It is owned by 11 member hospitals: Holland Bloorview Kids Rehab, Lakeridge Health, Mount Sinai Hospital, North York General Hospital, Rouge Valley Health System, St. Joseph's Health Centre, The Scarborough Hospital, Sunnybrook Health Sciences Centre, Toronto East General Hospital, University Health Network (with Toronto Rehab) and Women's College Hospital.

Plexxus is a not-for-profit shared service organization with a mandate to provide supply chain as well as transactional finance, human resources and payroll services to member healthcare organizations. Plexxus is now positioned to enable efficiencies by implementing SAP financial and supply chain software applications at Plexxus and our member hospitals. The implementation of an SAP platform across our member hospitals will enable us to also provide additional transactional services in the areas of finance, human resources and payroll services. The Plexxus objectives are to improve service levels and maximize non-clinical efficiencies, resulting in savings for members that can be reinvested in direct patient care. Plexxus embodies values that reflect a commitment to excellence. These include : A focus on results while delivering value, acting with integrity and respect, inspiring our people, being flexible and responsive, and finding innovative solutions for our customers.

We are recruiting a Senior Data Analyst to work at our project office in downtown Toronto with a cross functional team tasked to complete the work over the next 12 months.

Accountabilities:

Develop in SQL (SQL Server 2007) the data conversion programs in order to consolidate and load the data from various Legacy systems into SAP

Act as subject matter expert in the area of SQL tools as it relates to programs and tools for extraction, cleansing, consolidation and loading of data

Correspond with Hospitals and Plexxus Operations in providing guidance and resolving concerns or issues as they relate to data extraction, cleansing, consolidation and loading

Develop tools and report in order to support the teams responsible to perform detailed review and analysis of all data elements to ensure that they correspond with various business standards, rules and constraints

Research market, to identify best practices as it relates to data management

Complete work activities as assigned in a timely fashion

Participate and assist in the establishment of data management and governance practices

Mentor/coach, and provide guidance to junior members of the team

Qualifications:

Minimum five (5) years hands on experience in an analytical role or data role in a SAP environment

Minimum five (5) years hands on experience on SQL programming and conception

Data conversion and loading experience in SAP or other ERP an asset

Advanced MS Excel skills required

Proven ability to understand business operating and financial processes and align them to data requirements

Previous experience working in a Finance or Supply Chain environment

Demonstrated understanding of master data conversion strategy and requirements

Strong detail orientation

Proven team leader

Excellent analytical and trending skills

Self-starter, highly motivated, works well without constant supervision

Excellent verbal and written communication skills; solid presentation skills

Healthcare experience an asset.

Interested candidates please apply by Resume to Plexxus Human Resources. While Plexxus thanks all applicants, we advise only those who qualify for an interview will be contacted.

At Plexxus, we are committed to diversity and equitable opportunity for all individuals.
Start date
immediate
Duration
12 months
From
Generic Network
Published at
03.11.2011
Project ID:
263549
Contract type
Freelance
To apply to this project you must log in.
Register