Sql database administrator Jobs in New Westminster, BC

Payroll Systems Processor

Payroll

Burnaby, BC

Under the direction of the Administrator, Payroll Processing, the Payroll Systems Processor performs various processing functions by conducting a series of established procedures for quality control checks to verify and update information on the payroll database systems. The Payroll Systems Processor provides support to users of the payroll systems and performs duties related to the preparation and processing of payroll and leave of absence information such as entering data into electronic payroll systems, processing manual cheques, processing mass employee retroactive or arrears earnings, payroll deductions, leave of absence hours and service and leave plan adjustments. The Payroll Systems Processor responds to internal and external inquiries relevant to the processing of time and payroll data.

What you’ll do

• Performs quality control checks on payroll data prior to pay period cutoff to identify data entry errors in employee data. Updates payroll data or directs required corrections to appropriate support teams for correction prior to pay period end processing.
• Performs extracts (daily and bi-weekly) from multiple timekeeping systems and runs error validation reports. Checks and corrects payroll errors (such as mapping errors) and distributes reports to appropriate Timekeeping, Staffing or Customer Service Teams for timekeeping input, error corrections or follow up.
• Performs comprehensive quality control checks for accuracy on the timekeeping extract data and payroll system data by performing tasks such as running a series of established reports, checking and correcting identified errors by comparing input data to information provided by Human Resources and to established policies, procedures and standards. Generates data reports for time entry system and payroll system data and submits the verified information to the Administrator, Payroll Processing for approval. Uploads approved time entry and payroll system data files to the payroll system as directed. Refers problems and unresolved issues to the Administrator, Payroll Processing.
• Runs, prepares and distributes verified payroll reports for Finance and other related departments for pay periods and generates upload files and cheques within required deadlines. Verifies completion of pay cycle processing and submits verified processing checklist to the Administrator, Payroll Processing for approval and signoff.
• Performs off cycle pay processing as scheduled for employee retroactive or arrears earnings, payroll deductions, benefits leave of absence hours, service and leave plan adjustments based on the input of the Customer Service Teams. Coordinates performance and completion of off cycle processing with Customer Service Advisors and communicates results to the Customer Service Teams. Generates deposit files and cheques for approval by Manager, Payroll Administration.
• Under the direction of the Administrator, Payroll Processing assists with user acceptance testing following test cases of a variety of system changes including improvements to operating procedures, contractual changes and compliance with government agency requirements by running processes in a test database to ensure that the expected results have been achieved. Issues and results of testing are referred to the Administrator, Payroll Processing for analysis and approval for migration to production.
• In coordination with the Administrator, Payroll Processing assists with the development, implementation and deployment of new or revised processes including the documentation and updating of processing procedure documents and manuals as requested. Assists the Administrator, Payroll Processing with ensuring procedure documents are detailed and accurate for submission to Manager, Payroll Administration for approval.
• Generates electronic payroll data files for bank deposits and Canada Savings Bonds for review and approval by the Manager, Payroll Administration and Manager, Payroll Processing. Exports approved data files to external systems within required deadlines.
• Answers inquiries related to payroll information by performing tasks such as confirmation of information on pay period dates, the distribution of cheques and system setups for earnings codes, leave balances, deductions and benefits. Refers unresolved issues to the Manager, Payroll Processing.
• Responds to queries from timekeeping departments on issues such as coding by providing explanations as to how the time entry system is interfaced with the payroll system. Refers unresolved issues to the Administrator, Payroll Processing.
• Assists with orientation of staff on time entry system interfaces payroll system processes and changes resulting from system updates.
• Responds to queries on questions such as data variances relating to payroll processes by performing tasks such as reviewing data on the payroll system to provide background information and communicating information either verbally or through the electronic transfer of relevant database information.
• Performs other related duties assigned.

What you bring

Qualifications

• Grade 12 successful completion of a recognized payroll course and three years' recent related experience or an equivalent combination of education, training and experience.
• Demonstrated knowledge of the historic and ongoing impacts of settler colonialism on Indigenous Peoples in social and health contexts, including supported by significant knowledge of Indigenous-specific mandates, including clear understanding of and commitment to eradicate Indigenous-specific racism and discrimination and embed Indigenous Cultural Safety and Humility.
• Demonstrate comprehensive knowledge of the historic and ongoing impacts of settler colonialism and systemic racism on Indigenous Peoples within social and health contexts. This includes understanding how these factors contribute to current health disparities and barriers to care. Show a clear commitment to identifying, challenging, and eradicating Indigenous-specific racism and all forms of discrimination impacting equity-deserving groups within health care settings. This involves familiarity and understanding Indigenous Cultural Safety and Humility recognizing personal biases, institutional barriers, engaging in anti-racism education and training and advocating for systemic change.
• Demonstrated knowledge and understanding of legislative obligations and provincial commitments within Payroll contexts found in the foundational documents including Truth & Reconciliation Commission’s Calls to Action (2015), In Plain Sight (2020), BC's Declaration on the Rights of Indigenous Peoples Act (2019), United Nations Declaration on the Rights of Indigenous Peoples (UNDRIP), Reclaiming Power and Place Missing and Murdered Indigenous Women & Girls Calls for Justice (2019), the Declaration Act Action Plan and Remembering Keegan: A First Nations Case Study - BC Human Rights Code, BC Anti-racism Act and how they intersect across the health care system.

Core Competencies

• Brings an understanding of the Indigenous specific racism and the broader systemic racism that exists in the colonial health care structure, and has demonstrated initiatives in breaking down barriers and ensuring a safe environment ensuring a sense of belonging to all and informed by Indigenous Cultural Safety.
• Awareness of social, economic, political and historical realities of settler colonialism on Indigenous Peoples and familiarity with addressing Indigenous-specific anti-racism, anti-racism and Indigenous Cultural Safety and foundational documents and legislative commitments (the Declaration Act, the Declaration Action Plan, TRC, IPS, Remembering Keegan, etc.).

Skills & Knowledge

• Ability to deal with others effectively
• Ability to communicate effectively both verbally and in writing
• Physical ability to carry out the duties of the position
• Ability to organize work
• Ability to operate related equipment
• Demonstrates a commitment to beginning and/or continuing their personal learning journey related to Indigenous-specific racism and dismantling systems of oppression, as well as addressing racism more broadly. Shows willingness to articulate and share their learning experiences to contribute to a culture of motivation and inspiration among peers.
• Demonstrates foundational knowledge of the social, economic, and political realities of settler-colonialism and its impacts on Indigenous peoples and equity-deserving groups within social and health contexts. Understands the impact of social determinants of health-on-health outcomes. Shows a commitment to learning about and upholding legislative obligations and provincial commitments outlined in foundational documents such as the Truth & Reconciliation Commission’s Calls to Action (2015), In Plain Sight (2020), BC's Declaration on the Rights of Indigenous Peoples Act (2019), United Nations Declaration on the Rights of Indigenous Peoples (UNDRIP), Reclaiming Power and Place: Missing and Murdered Indigenous Women & Girls Calls for Justice (2019), the Declaration Act Action Plan, Remembering Keegan: A First Nations Case Study, the BC Human Rights Code, Anti-Racism Data Act, and the Distinctions Based Approach.

What we bring

Every PHSA employee enables the best possible patient care for our patients and their families. Whether you are providing direct care, conducting research, or making it possible for others to do their work, you impact the lives of British Columbians today and in the future. That’s why we’re focused on your care too – offering health, wellness, development programs to support you – at work and at home.

• Join one of BC’s largest employers with province-wide programs, services and operations – offering vast opportunities for growth, development, and recognition programs that honour the commitment and contribution of all employees.
• Access to professional development opportunities through our in-house training programs, including +2,000 courses, such as our San’yas Indigenous Cultural Safety Training course, or Core Linx for Leadership roles.
• Enjoy a comprehensive benefits package, including municipal pension plan, and psychological health & safety programs and holistic wellness resources.
• Annual statutory holidays (13) with generous vacation entitlement and accruement.
• PHSA is a remote work friendly employer, welcoming flexible work options to support our people (eligibility may vary, depending on position).
• Access to WorkPerks, a premium discount program offering a wide range of local and national discounts on electronics, entertainment, dining, travel, wellness, apparel, and more.

What we do

The Provincial Health Services Authority () plans, manages and evaluates specialized health services with the BC health authorities to provide equitable and cost-effective health care for people throughout the province. Our values reflect our commitment to excellence and include: Respect people – Be compassionate – Dare to innovate – Create equity – Be courageous.

Learn more about PHSA and our programs:

PHSA is committed to anti-racism and equity in our hiring and employment practices. With learning and compassion, we are addressing existing inequities and barriers throughout our systems. PHSA is seeking to create a diverse workforce and to establish an inclusive and culturally safe environment. We invite applications and enquiries from all people, particularly those belonging to the historically, systemically, and/or persistently excluded groups identified under the Human Rights Code.

One of PHSA’s North Star priorities is to eradicate Indigenous-specific racism, which includes ongoing commitments to Indigenous recruitment and employee experience as well as dismantling barriers to health care employment at every level. We welcome Indigenous individuals to apply and/or contact the Sanya’k̓ula Team (Indigenous Recruitment & Employee Experience) for support at .

Indigenous-specific anti-racism initiatives are rooted in addressing the unique forms of discrimination, historical and ongoing injustices, and exclusion faced by Indigenous peoples. These initiatives align with an Indigenous rights-based approach, recognizing the inherent rights and title of BC First Nations and self-determination of all First Nations, Inuit and Métis communities. PHSA is mandated to uphold legislative obligations and provincial commitments found in the foundational documents including the Truth & Reconciliation Commission’s Calls to Action (2015), In Plain Sight (2020), BC's Declaration on the Rights of Indigenous Peoples Act (2019), United Nations Declaration on the Rights of Indigenous Peoples (UNDRIP), Reclaiming Power and Place Missing and Murdered Indigenous Women & Girls Calls for Justice (2019), the Declaration Act Action Plan and Remembering Keegan: A First Nations Case Study.