Job Description

Not just a job\xe2\x80\xa6

a community

a partnership

a team

You\xe2\x80\x99ll experience them all at London Drugs. As one of Canada\xe2\x80\x99s most successful retail chains, we know what it takes to build a satisfying career. We are seeking innovative, customer focused people to join our team! Our Finance Department located at our head office in Richmond, BC currently has opportunities for:

Financial Systems Analyst

The Financial Systems Analyst plays a crucial role in maintaining the accuracy and integrity of our financial systems, with a primary focus on financial analysis, reconciliation, data extraction, and expertise in Azure and SQL. This role requires a strong understanding of financial processes, database tables/management and will involve working closely with the Peoplesoft and D365 backend system.

Key responsibilities include:

• Conduct comprehensive financial analysis to identify trends, opportunities, and discrepancies in data related to Sales, Inventory, Payables, from various sources such as Point of Sale, Warehousing and Accounting Systems.
• Utilize SQL queries to extract, transform, and load (ETL) data from various sources to match subsystems and financial records. Ensure that data extraction processes are efficient, accurate, and aligned with business requirements.
• Write and update SQL queries across multiple databases and tables, and optimize for performance and efficiency when extracting, manipulating, and reporting data.
• Proactively monitor subsystem postings to ensure they match the General Ledger (GL). Investigate and resolve any discrepancies that arise, maintaining accurate financial reporting.
• Perform regular reconciliations between different subsystems and financial records to ensure consistency and accuracy of data. Investigate and resolve discrepancies in a timely manner.
• Utilize Peoplesoft and D365 backends for running queries and reconciliations. Collaborate with IT and finance teams to maintain and enhance the integration between financial systems, ensuring data integrity and system reliability.
• Generate clear and concise reports to communicate financial analysis findings, reconciliation outcomes, and data extraction results to stakeholders at various levels of the organization.
• Continuously identify opportunities to streamline financial analysis and related processes, enhance data accuracy, and improve overall financial system efficiency.
• Work closely with inventory management, finance, IT, and other relevant departments to understand their data needs, provide support, and ensure alignment with business goals.

The ideal candidate should have:

• Sharp technical skills, a high degree of discipline, organization, and attention to detail.
• Good communication skills, both written and verbal.
• Demonstrate good interpersonal skills when dealing with customers, staff & management.
• Strong administrative skills.
• Highly organized and able to multitask effectively and work under changing priorities.
• Initiative to isolate and solve problems.
• Excellent problem-solving skills and attention to detail.
• Ability to work independently and collaboratively in a fast-paced environment.
• Strong organizational and time management skills.
• Adaptability and willingness to learn new technologies and tools as needed.

EDUCATION & KNOWLEDGE:

• Bachelor\'s Degree in Finance/Computer Science, or a related field. Master\'s degree or relevant certifications are a plus.
• Strong expertise in SQL for data extraction, manipulation, and reporting.
• Experience with financial analysis, reconciliation, and financial systems management.
• Proficiency in data analysis tools such as Excel, Power BI, or similar platforms.
• Solid understanding of financial principles, processes, and accounting standards.
• Familiarity with Peoplesoft, D365 and Azure systems and ability to run queries and perform reconciliations.

London Drugs offers advancement opportunities through our promote-from-within policies, salaries commensurate with experience, as well as a comprehensive benefits program including:

• Medical, dental, prescription drug and vision coverage for you and your family (Ensuring you and your family are taken care of)
• Employee Discount Program (Sharing our success)
• Employee Recognition Program (Tangible rewards for great work!)
• Company matched RRSPs (Helping you plan for your future)
• Ongoing In-House Training & Education Courses (Lifelong learning)
• Employee Family Assistance Program (Free confidential counseling)
• Community Involvement (Giving back to our communities)

If you are a well organized, self-motivated, individual who has a positive attitude and a commitment to achieving Company objectives, then we have the opportunity for you to excel!

Apply Now!

London Drugs welcomes applications from people with disabilities. Applicants may request reasonable accommodation related to the materials or activities used throughout the selection process.

We are an equal opportunity employer. The above statements are intended to describe the general nature and level of work applicable to this position and are not intended to be an exhaustive list of all responsibilities, duties and skills required. Be advised, London Drugs DOES NOT use third party recruitment services.

London Drugs may collect, use, and/or disclose your personal information (including the information in this application) where it is reasonable for establishing, managing or terminating an employment relationship. This includes the use or disclosure of your personal information to persons inside or external to our organization, for the purpose of checking references or gathering other information to support an assessment of your candidacy.

To protect yourself, do not respond to unsolicited job offers from individuals or e-mail addresses, and never disclose any sensitive details about your identity (including personal or financial) to anyone you do not know or trust or on any unverified website, or website you do not trust.

Flexible work from home options available.

London Drugs