Job Information

Aston Carter Financial Systems Analyst in Richmond, British Columbia


Aston Carter's National Retail client is seeking a Financial Systems Analyst to join their team on a 2 year contract period, with the potential to move permanent. This role will be located in their Richmond office.

This position will be responsible for assisting with the system conversion and maintaining and producing the company financial statements on a monthly and adhoc basis. The Financial Systems Analyst will be tasked with obtaining operational data from the various internal and external sources for analysis by the Financial Analysts or Accounting Managers. As a member of the Accounting team, this position will also perform regularly monthly and adhoc data imports into the Finance SQL server. This position will meet with other Finance users to determine what data and views will need to be uploaded and/or created to facilitate in analysis in order to meet the growing demands of the business.


• Running and maintaining timely monthly and adhoc financial reports.

• Creating or modifying financial reports.

• Extracting data from internal and external sources to facilitate in analysis.

• Performing regular and adhoc data imports into the Finance SQL server.

• Provide adhoc operational reporting from various systems.

• Preparation of working papers for audits.

• Responding to operational or financial data queries from internal clients in a timely manner.

• Responding to other ad-hoc queries and projects.

• Meeting with other Finance users to determine what data and views are required to be updated and/or created to facilitate in analysis in order to meet the demands of the business.


• Ability to design database and data warehouse applications for standard business processes.

• Ability to set up database systems that support the optimal use of enterprise level reporting tools.

• Ability to research, compile data, conduct analysis, and prepare summary reports and recommendations for use in strategic planning.

• Strong analysis, critical thinking, and problem-solving skills

• Demonstrated ability in building pivot tables using Microsoft PowerPivot

• Experience with using PowerQuery to extract and transform data from external sources

• Experience with using PowerMaps

• Experience with Microsoft Excel VBA programming

• Experience with PeopleSoft Financials 8.8 nVision reporting (modifying layouts)

• Have a CPA designation, or have completed the Common Final Examination (CFE) and is working towards in achieving the practical experience requirement.

• Minimum advance/intermediate level ability in SQL

• Experience in working with Microsoft SQL Server Management Studio to create and maintain tables and databases.

• Demonstrated ability to import and export data from various sources into Microsoft SQL Server

• Demonstrated ability to build dashboards using Microsoft PowerBI

• Advance level in using Microsoft Excel


• Good communication skills, both written and verbal.

• Demonstrate good interpersonal skills when dealing with customers, staff & management.

• Strong administrative skills.

• Professional image, reflecting positively on the company.

• Highly organized and able to multitask effectively and work under changing priorities.

• Good communication skills within a team environment.

• Initiative to isolate and solve problems.

• Ability to relate to all levels of personnel.

While we appreciate your interest in this role, only those eligible to work in Canada will be contacted.

À propos d'Aston Carter:

Aston Carter, une division d'Aerotek, est un fournisseur d'envergure mondiale de services de recrutement et de dotation de personnel pour les sociétés à la recherche de professionnels du milieu des affaires hautement spécialisés. Aerotek est une société en exploitation d'Allegis Group, un fournisseur multinational de solutions en matière de talent. Aston Carter s'engage fermement à offrir un service de premier ordre aux clients et aux professionnels du milieu des affaires dans un vaste éventail de disciplines, notamment la comptabilité, la finance, la gouvernance ainsi que la gestion du risque et de la conformité. Avec plus de 60 bureaux en Europe, Asie et Amérique du Nord, Aston Carter offre une expertise locale, régionale et mondiale pour répondre aux besoins uniques de ses clients. Reconnu "best of staffing" par nos clients et le talent que nous recrutons, Aston Carter s'engage à livrer un service hors pair a tous nos partenaires d'affaire.

About Aston Carter:

Aston Carter is a distinguished global provider of recruitment and staffing services to companies requiring highly specialized business professionals. As a Best of Staffing® Client and Talent leader, Aston Carter has an unrivaled commitment to delivering first class service to clients and business professionals across a variety of disciplines, including Accounting and Finance as well as Governance, Risk and Compliance. With more than 60 offices across Europe, Asia Pacific and North America, Aston Carter provides local, regional and global expertise to drive value and meet our customers' unique needs. Aston Carter is a division of Aerotek. Aerotek is an operating company of Allegis Group, a global talent solutions provider.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.