Toronto
International Film Festival
The Toronto International Film Festival (TIFF) is a charitable, not for profit,
cultural organization whose mission is to transform the way people see the
world. Its vision is to lead the world in creative and cultural disc
overy
through the moving image.
Job Description
TIFF, a
vibrant not-for-profit arts organization, is hiring for the full time position
of: Business Analyst, SQL/Financial Reporting
vibrant not-for-profit arts organization, is hiring for the full time position
of: Business Analyst, SQL/Financial Reporting
TIFF is dedicated to presenting the best of international and
Canadian cinema to film lovers in our home TIFF Bell Lightbox. Our aim is
to become a creative, community and global leader, and one of the world’s
premiere organizations in the discovery and understanding of film. We are
seeking a highly motivated individual who wants to be a part of our ever
growing team, and be part of Toronto’s cultural history.
Canadian cinema to film lovers in our home TIFF Bell Lightbox. Our aim is
to become a creative, community and global leader, and one of the world’s
premiere organizations in the discovery and understanding of film. We are
seeking a highly motivated individual who wants to be a part of our ever
growing team, and be part of Toronto’s cultural history.
Reporting to the Senior Manager, Financial Analysis, the
Business Analyst, SQL/Financial Reporting would have an understanding of
accounting processes and should also possess advanced knowledge of SQL and
Excel. They will be responsible for gathering requirements for Finance
projects, preparing and analyzing reporting data from a number of our application
systems and providing reports and solutions for our leadership team.
Business Analyst, SQL/Financial Reporting would have an understanding of
accounting processes and should also possess advanced knowledge of SQL and
Excel. They will be responsible for gathering requirements for Finance
projects, preparing and analyzing reporting data from a number of our application
systems and providing reports and solutions for our leadership team.
Responsibilities:
§ Elicit reporting requirements using document analysis, use
cases, business analysis, task and workflow analysis
cases, business analysis, task and workflow analysis
§ Critically evaluate information gathered from multiple
sources to distinguish user requests from the true underlying current needs;
flexibility to ensure changing and future needs are also met
sources to distinguish user requests from the true underlying current needs;
flexibility to ensure changing and future needs are also met
§ Facilitate discussions between technical and business
groups to establish shared goals and metrics
groups to establish shared goals and metrics
§ Prepare custom reports using SQL and advanced Excel
functions from a variety of sources/systems for internal stakeholders
functions from a variety of sources/systems for internal stakeholders
§ Present recommendations and solutions based on findings to
challenges in our application environments
challenges in our application environments
Requirements:
Minimum Requirements:
§ Advanced proficiency in SQL server and extensive
experience writing SQL queries
experience writing SQL queries
§ Advanced Microsoft Excel skills (VBA, Macros, Pivot
Tables)
Tables)
§ Proven experience in the definition, documentation end
reporting of program scope and objectives
reporting of program scope and objectives
§ Superior interpersonal, relationship building and
communications skills, tact and judgment
communications skills, tact and judgment
§ Ability to learn quickly and adapt to constantly changing
priorities
priorities
§ Experience with Project Management software and Critical
Paths
Paths
§ Excellent critical thinking and problem
solving/trouble-shooting skills
solving/trouble-shooting skills
§ Adaptable to a flexible work schedule including some
evenings and weekends
evenings and weekends
§ Experience working with accounting software packages and
knowledge of accounting business processes an asset
knowledge of accounting business processes an asset
§ Experience with Salesforce and applications built for
Salesforce an asset
Salesforce an asset
*You may be asked to undergo professional testing to verify
requirements*
requirements*
How to Apply:
Please
submit cover letter, resumé and the names and phone numbers of 3 references
attached as a PDF or Word document (we do not accept Cloud hosting or File
Sharing programs), by 5pm on April
3, 2015 BY EMAIL ONLY
submit cover letter, resumé and the names and phone numbers of 3 references
attached as a PDF or Word document (we do not accept Cloud hosting or File
Sharing programs), by 5pm on April
3, 2015 BY EMAIL ONLY
TIFF
Email: careers@tiff.net *Please
note Business Analyst, SQL/Financial
Reporting in the subject line*
Email: careers@tiff.net *Please
note Business Analyst, SQL/Financial
Reporting in the subject line*
Please note in your cover
letter where you saw this job posting.
letter where you saw this job posting.
We
thank everyone who applies for their interest, but only candidates selected for
an interview are contacted. No
telephone or walk-in inquiries please. All applications
are considered confidential.
thank everyone who applies for their interest, but only candidates selected for
an interview are contacted. No
telephone or walk-in inquiries please. All applications
are considered confidential.
TIFF is an equal opportunity employer.
TIFF is a charitable, not-for-profit cultural organization whose
mission is to transform the way people see the world, through film. Its
vision is to lead the world in creative and cultural discovery through the
moving image.
mission is to transform the way people see the world, through film. Its
vision is to lead the world in creative and cultural discovery through the
moving image.
