Skip To Main Content

Business Intelligence BI Data Scientist Developer

  • Panavision
  • Vancouver, BC
  • Full Time

Date Listed: September 30, 2024

Job Scope:

Panavision is seeking a highly skilled and motivated Business Intelligence (BI) Data Scientist/Developer to join our team immediately. In this role you will be responsible for building and maintaining an online web application that serves as the interface to a structured data warehouse supporting Panavision’s advanced data analytics and reporting needs. You will design and implement APIs and processes to replicate and propagate data from various sources, ensuring seamless integration and efficient data integration across platforms.

This is a high impact opportunity with a leading entertainment industry brand with operations across four continents. Come be part of the team that’s innovating the next generation of film and television production services. The ideal candidate will be goal-oriented, innovative, analytic, well organized, collaborative, a strong communicator, and partnership-minded in the development and execution of data and application deliverables.

Qualified candidates for this position must have demonstrated technical skills and experience in designing, developing in C#, and deploying enterprise-level application and data analytics solutions, data scraping, and reporting ideally using Microsoft platforms (SQL Server, SSIS, SSAS, SSRS, and PowerBI). In addition, and as needed, this role will be required to develop expertise in other technologies in support of new business needs and initiatives.

Key Responsibilities:

  • Build and maintain a scalable, high-performance data warehouse solution.
  • Develop data models that support both operational and analytical data requirements
  • Implement and optimize ETL processes to ensure data accuracy and accessibility
  • Experienced in design and development of complex enterprise applications and configuration of server databases
  • Understand and design conceptual and logical data models and data flows
  • Develop high-quality software design, writing high-quality source code to program and complete applications within deadlines
  • Review and debug code, and perform unit and integration testing before launch
  • Install, configure and support Microsoft SQL Server databases and servers ranging from SQL Server 2008 to SQL Server 2019
  • Install, configure and support SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) servers
  • On-going monitoring and maintenance of Microsoft SQL Server databases, including:
    • Ensuring daily backups are made and archived successfully
    • Restoring database backups as needed and requested
    • Monitoring the performance of SQL Server databases and servers
    • Identifying processes impacting performance and identifying tuning opportunities
  • Develop, document, and make recommendations on SQL Server architecture, design, and implementation
  • Develop database stored procedures and functions using T-SQL
  • Develop ETL processes using SQL Server Integration Services (SSIS) and SQL Server Data Quality Services (DQS)
  • Develop SQL Server Analysis Services cubes
  • Develop and manage SQL Server Agent Jobs
  • Ability to communicate and collaborate effectively with IT team members and business users
  • Ability to research, understand, and recommend new technologies
  • Generate recurring (e.g. weekly and monthly) reporting in support of defined business needs
  • Monitor and resolve data quality issues, ensuring timely correction and continuous improvement.
  • Design and implement automated data cleanup routines
  • Develop and maintain custom reports and dashboards to provide business insights
  • Work closely with business stakeholders to understand reporting needs and deliver actionable insights.
  • Ensure all database architectures comply with security, privacy and compliance
  • Implement role-based access controls to protect sensitive information

Skills/Experience Required:

  • In-depth object-oriented structure skills, including strong design patterns knowledge and enterprise integration
  • 7 or more years experience in software development and database management
  • Experience gathering and analyzing system requirements
  • Experience using MS Stack C#, SQL Server
  • Experience in Object-Oriented (OO), MVVM, XAML/WPF, Visual Studio, MS Fakes, Telerik DevCraft, SQL Server and Reporting Services, SharePoint, Team Foundation
  • Analytical thinking and problem-solving capability
  • Experience as a Microsoft SQL Server DBA with demonstrated skills in supporting production databases for mission-critical applications
  • Experience with installing, configuring, upgrading, patching, and migrating Microsoft SQL Server products to new versions and/or new servers
  • Experience tracking, monitoring, and reporting of database jobs and processes
  • Experience with Microsoft SQL Server database capacity planning and performance tuning in complex environments
  • Experience working as a member of application development teams developing, supporting, and tuning complex SQL queries and T-SQL stored procedures and functions
  • Experience designing, evaluating, and recommending database architectures
  • Experience building and deploying SSIS packages, SSRS reports, SSAS cubes, and SQL Agent Jobs
  • Knowledge of data mining
  • Proficient with PowerBI or similar platforms such as SSRS, Tableau, etc.
  • Proficiency in MS Excel
  • Degree in a relevant subject (e.g. computer science) or relevant industry experience, Master’s Degree preferred.

Work Environment and Physical Demands:

This job operates in a professional office environment.  The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. While performing the duties of this job, the employee is regularly required to talk and hear. The employee frequently is required to stand; walk; use hands and reach with hands and arms.  The employee may also be required to lift product or equipment weighing up to 50 lbs.

Position Type/Expected Hours of Work/Travel:

This position works standard business hours but may require long hours and some weekend work. Some out-of-province / country and overnight travel may be expected. This job currently adopted a hybrid work-from-home policy- which is subject to review and potential change from time to time. 

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice. 

Salary Range:

$105,000-$140,000 CAD

It is the policy of Panavision to provide equal employment opportunities without regard to race, color, religion, sex, national origin, age, disability, marital status, veteran status, sexual orientation, genetic information or any other protected characteristic under applicable-Employment Standards Act. .