Financial Data Analyst

2 weeks ago

Victoria, Canada The Corporation of The City of Victoria Full time

**Job Description**:
**Competition #23/76**

**Internal/External Posting**

**Closing date: April 4, 2023**

***

**Financial Analyst - ERP System (Continuous)**

**Finance Department**

Victoria is a leading-edge capital city that embraces the future and builds on the past, where human well-being and the environment are priorities and where the community feels valued, heard, and understood.

The City’s Finance department has an exciting opportunity for a Financial Data Analyst to join our team with the goal of providing exceptional service. At the City, we work collaboratively, continually look toward the future, and are committed to a culture that believes in continuous improvement.

The Financial Data Analyst will be an integral part of the Finance Department’s endeavour to continually modernize systems and processes with the goal to improve operational efficiencies. This position also requires technical skills focused on the daily administration of the City’s ERP system (currently Oracle’s JD Edwards) specifically for the Finance Department. You will also serve as a champion for the Finance Team on various ERP integrations with other enterprise systems such as asset management (Cartegraph), financial reporting software (ReportsNow) and others. This individual works with all finance data and reporting and provides technical support to other business areas as required. A strong knowledge of Power Pivot, Power BI, tabular data models, Oracle BI Publisher and the advanced data features of Excel is a must. Experience with SQL scripting is also desirable.

The City is a fantastic employer offering a competitive benefits package, hybrid work from home, municipal pension plan and extended healthcare benefits. This role is also eligible for one day off each pay period (modified work weeks).

If you are passionate about what you do, strive to work in a progressive environment and want to contribute to the digital and process transformation of the City, we want to hear from you

**POSITION FUNCTION**

Coordinate and participate in the on-going maintenance and continuing enhancements and upgrades of the City’s Enterprise Resource System.

**KEY DUTIES**
- Perform month-end and year-end procedures; develop training plans and provide system setup and end user training; represent the department on corporate projects and committees as required.
- Support and troubleshoot issues identified by end users; research issues, log calls with Support and test software fixes (ESU’s) to address issues identified; liaise with Information Systems staff and consultants in issue resolution.
- Develop end user documentation; ensure manual and software processes comply with accounting and auditing requirements develop report specifications, coordinate report development, write and test new reports; make enhancements to and maintain existing reports.
- Maintain and control end user system security by developing security groups and roles and assigning users to the appropriate setup; create and maintain end user menus.
- Perform related duties where qualified.

**INDEPENDENCE**
- Work is generated by annual objectives and end user issue identification.
- Work is reviewed through discussions with supervisor.
- Issues such as major system changes and resource matters are discussed with supervisor with recommendations.

**WORKING CONDITIONS**

**Physical Effort**:

- Sit with arms unsupported while keyboarding. (often)

**Mental Effort**:

- Meet project deadlines. (often)

**Visual/Auditory Effort**:

- Focus on a variety of source data and computer for short periods. (frequent)

**Work Environment**:

- Office.

**KEY SKILLS AND ABILITIES**
- Organize and prioritize work.
- Advanced level operation of current City advanced specialty software.
- Interpret related policies and regulations.
- Provide technical guidance and advice to user departments.
- Research and analyze needs and facilitate meetings and workshops.
- Maintain accurate records.
- Establish and maintain effective working relationships.
- Deal effectively with the public and outside agencies.

**QUALIFICATIONS**

**Formal Education, Training and Occupational Certification**:

- Undergraduate degree in business or related field. (4 years)
- Professional accounting designation (CPA). (2 years)
- Masters Certificate in Business Analysis or Equivalent. (126 hours)
- Project Management Institute Certified Associate in Project Management. (23 hours)

**Experience**:

- 5 years of related experience including accounting experience.
- or an equivalent combination of education and experience.

**OTHER**:
May be requested to substitute in a more senior position.

**Work schedule: Monday - Friday, 35 hour work week**

**$51.42 per hour, Pay Grade 16**

**Job Code #4274**

**This is a CUPE Local 50 Position**

At the City of Victoria, we are committed to recruiting a diverse workforce that represents the community we serve. Indigenous applicants, people of colour, all genders

  • Financial Analyst

    6 days ago

    Victoria, Canada BC Assessment Full time

    BC Assessment is currently looking for a Financial Analyst to join our Accounting and Reporting team! This permanent opportunity is based out of our Uptown Victoria, BC office location. Organization Overview BC Assessment is a Provincial Crown Corporation that develops and maintains real property assessments throughout British Columbia in addition to...

  • Data Analyst

    4 weeks ago

    Victoria, Canada Island Health Full time

    **Job Description**: In accordance with the Vision, Purpose, and Values, and strategic direction of the Vancouver Island Health Authority, patient safety is a priority and a responsibility shared by everyone at VIHA; as such, the requirement to continuously improve quality and safety is inherent in all aspects of this position. The Data Analyst reports to...

  • Financial Systems Analyst

    6 days ago

    Victoria, Canada Capital Regional District Full time

    **Financial Systems Analyst**: - The Capital Regional District (CRD) is the_ **_regional government_**: - for 13 municipalities and three electoral areas on_ **_southern Vancouver Island and the surrounding Gulf Islands_** **_,_**: - serving more than 432,000 people. _ - Our _ **_administrative boundaries_**: - span the Traditional Territories of many...

  • Financial Analyst

    4 weeks ago

    Victoria, Canada PBC Solutions Full time

    **Who is PBC Solutions?** PBC Solutions Ltd. is a wholly owned subsidiary of PBC Health Benefits Society (operating as Pacific Blue Cross). Our mandate is to design, transform, and deliver the benefits and claims administration services offered by governments and other large organizations along with our consortium partners Advanced Solutions (which is our...

  • Financial Analyst, Financial Controls

    3 weeks ago

    Victoria, Canada Island Health Full time

    **Job Description**: In accordance with the Vision, Purpose, and Values, and strategic direction of the Vancouver Island Health Authority (Island Health) patient and staff safety is a priority and a responsibility shared by everyone; as such, the requirement to continuously improve quality and safety is inherent in all aspects of this position. Reporting to...

  • Financial Analyst

    3 days ago

    Victoria, Canada BC Transit Full time

    We acknowledge with respect that BC Transit delivers our mission on the ancestral territories of Indigenous Peoples across British Columbia, and their historical relationships with the land continue to this day. In Victoria, where our Corporate Office is located, our people are privileged to live and work on the unceded traditional territories of the...

  • Financial Analyst, Local Services

    4 weeks ago

    Victoria, Canada Capital Regional District Full time

    **Financial Analyst, Local Services**: - The Capital Regional District (CRD) is the _**_regional government_**_ for 13 municipalities and three electoral areas on _**_southern Vancouver Island and the surrounding Gulf Islands_**_, serving more than 432,000 people._ - Our _**_administrative boundaries_**_ span the Traditional Territories of many _**_First...

  • Budget Analyst

    4 weeks ago

    Victoria, Canada Royal Roads University Full time

    Under the general direction of the Manager, Financial Planning, the Budget Analyst is responsible for the delivery and management of budget information for assigned budget areas and supporting the overall financial planning and budgeting process. The Budget Analyst works with assigned clients to prepare regular forecasts, analyzes financial data for...

  • Data Analyst

    4 weeks ago

    Victoria, Canada Terra Archaeology Full time

    **About the Company**: Terra Archaeology Limited (Terra) provides professional archaeological consulting services throughout British Columbia. Our work is conducted at the request of First Nations, federal and provincial government agencies and ministries, private sector corporations, and private landowners. Terra Archaeology Limited seeks a full-time Data...

  • Senior Financial Analyst

    2 days ago

    Victoria, Canada BC Ferries Full time

    Job Description SENIOR FINANCIAL ANALYST Victoria The Opportunity The Accounting & Reporting department is part of BC Ferries’ Finance Division and is responsible for producing external financial reporting in a timely and accurate manner as well as providing accounting expertise to senior management in the decision-making process. Senior Financial...

  • Senior Financial Analyst

    3 days ago

    Victoria, Canada BC Ferries Full time

    Job Description SENIOR FINANCIAL ANALYST Victoria The Opportunity The Accounting & Reporting department is part of BC Ferries’ Finance Division and is responsible for producing external financial reporting in a timely and accurate manner as well as providing accounting expertise to senior management in the decision-making process. ...

  • Senior Financial Analyst

    4 days ago

    Victoria, Canada BC Ferries Full time

    Job Description SENIOR FINANCIAL ANALYST Victoria The Opportunity The Accounting & Reporting department is part of BC Ferries’ Finance Division and is responsible for producing external financial reporting in a timely and accurate manner as well as providing accounting expertise to senior management in the decision-making process. Senior Financial...

  • Senior Financial Analyst

    4 days ago

    Victoria, Canada BC Ferries Full time

    Job Description SENIOR FINANCIAL ANALYST Victoria The Opportunity The Accounting & Reporting department is part of BC Ferries’ Finance Division and is responsible for producing external financial reporting in a timely and accurate manner as well as providing accounting expertise to senior management in the decision-making process. Senior Financial...

  • Senior Financial Analyst

    3 days ago

    Victoria, Canada BC Ferries Full time

    Job Description SENIOR FINANCIAL ANALYST Victoria The Opportunity The Accounting & Reporting department is part of BC Ferries’ Finance Division and is responsible for producing external financial reporting in a timely and accurate manner as well as providing accounting expertise to senior management in the decision-making process. Senior Financial...

  • Fo 18r

    6 days ago

    Victoria, Canada BC Public Service Full time

    Posting Title- FO 18R - Financial Analyst- Position Classification- Financial Officer R18- Union- N/A- Work Options- Hybrid- Location- Victoria, BC V9B 6X2 CA (Primary)- Salary Range- $64,123.59 - $72,674.35 annually- Close Date- 5/27/2024- Job Type- Regular Full Time- Temporary End Date- Ministry/Organization- BC Public Service -> Attorney General- Ministry...

  • Financial Analyst

    3 days ago

    Victoria, Canada BC Transit Full time

    We acknowledge with respect that BC Transit delivers our mission on the ancestral territories of Indigenous Peoples across British Columbia, and their historical relationships with the land continue to this day.   In Victoria, where our Corporate Office is located, our people are privileged to live and work on the unceded traditional territories of the...

  • Financial Analyst, Financial Reporting

    4 weeks ago

    Victoria, Canada Island Health Full time

    **Job Description**: In accordance with the Vision, Purpose, and Values, and strategic direction of the Vancouver Island Health Authority (Island Health) patient and staff safety is a priority and a responsibility shared by everyone; as such, the requirement to continuously improve quality and safety is inherent in all aspects of this position. Reporting to...

  • Fo 21r

    4 weeks ago

    Victoria, Canada BC Public Service Full time

    Posting Title- FO 21R - Financial Analyst- Position Classification- Financial Officer R21- Union- N/A- Work Options- Location- Victoria, BC V9B 6X2 CA (Primary)- Salary Range- $ 37.09 - $42.17 hourly- Close Date- 2/5/2024- Job Type- Temporary (Auxiliary)- Temporary End Date- 3/31/2025- Ministry/Organization- BC Public Service -> Elections BC- Ministry Branch...

  • Admn o 21r

    4 weeks ago

    Victoria, Canada BC Public Service Full time

    Posting Title- ADMN O 21R - Data Analyst- Position Classification- Administrative Officer R21- Union- N/A- Location- Victoria, BC V9B 6X2 CA (Primary)- Salary Range- Applicants internal to the BC Public Service - $34.74 - $39.50 per hour Applicants external to the BC Public Service - hired under the Election Act as Project Officer - $34.74 per hour- Close...

  • Fo 18r

    7 days ago

    Victoria, Canada BC Public Service Full time

    Posting Title- FO 18R - Financial Analyst (CRB)- Position Classification- Financial Officer R18- Union- GEU- Work Options- Location- Victoria, BC V9B 6X2 CA (Primary)- Salary Range- $62,255.85 - $70,557.73 annually- Close Date- 8/18/2023- Job Type- Temporary (Auxiliary)- Temporary End Date- Ministry/Organization- BC Public Service -> Royal BC Museum-...