Database Analyst

The organization

The Canadian Media Producers Association (CMPA) is Canada’s leading trade association for independent producers, representing more than 400 companies engaged in the development, production and distribution of English-language television programs, feature films and digital media.  The CMPA works on behalf of our members to promote and stimulate the Canadian production industry. Our goal is to ensure the continued success of Canada’s independent production sector and a bright future for Canadian content.

The position

Reporting to the Controller, the Analyst plays an integral role in the management and day-to-day operation of the CMPA’s national CRM database.


1. CMPA database

The Analyst manages CMPA’s organizational database (Microsoft CRM). They are also part of the finance team that ensures the integrity and effectiveness of the financial data and assets of the organization. Specifically, the Analyst will:

  • Identify sources of production data
  • Enter data in an accurate and timely manner
  • Coordinate and liaise with internal staff and external parties to optimize the effectiveness of the database
  • Maintain the technical structure of the database
  • Maintain security to ensure integrity of our database
  • Liaise with external technical consultants to ensure enhancements meet our requirements
  • Prepare analytical reports that reflect financial performance and industry trends
  • Provide training and documentation to staff and members
  • Monitor and support our membership portal
  • Support members using the online remittance form

2. Other duties

The Analyst will work closely with and support the other members of the finance team to meet our goals and objectives

Education, experience and capabilities
  • Minimum 3 – 5 years of experience in a similar position
  • Post-secondary education
  • Works well in a team environment
  • Advanced knowledge of Microsoft CRM databases
  • Advanced knowledge of Microsoft Office (Excel, Word, Outlook)
  • Able to build and maintain positive and effective working relationships with internal and external parties
  • Communicates effectively and concisely, both orally and in writing
  • Adapts well to a fast-paced environment, with shifting priorities and multiple deadlines
  • Strong organizational, judgement and time management skills
  • Detail and results oriented
  • Knowledge of the media sector
  • Financial background
  • English (written and spoken) essential
  • French (written) an asset

Candidates interested in applying for this employment opportunity are asked to submit a resume and covering letter by email to no later than June 14, 2019.  We thank all applicants for their interest; however, only those candidates selected for an interview will be contacted.