Match score not available

Unlock Premium Benefits Today!
🚀 Elevate your career with priority access.
Stand out to top recruiters with Jobgether Priority Access:
  • ✅ Top Match: We help you identify job offers where you're a perfect fit.
  • ✅ Exclusive Referral Service: Connect directly with recruiters as a Jobgether Certified Premium User.
  • ✅ Personalized Feedback: Receive feedback and expert guidance on applications, and have your profile manually reviewed.

Start Your Free Trial Now!

Start my free trial

Business Intelligence (BI) Data Scientist / Developer - Panavision Vancouver

Remote: 
Full Remote
Contract: 
Full time
Salary: 
105 - 140K yearly
Experience: 
Senior (5-10 years)
Work from: 
Canada

Offer summary

Qualifications:

7+ years in software development, Experience with C# and SQL Server, Proficient in PowerBI or similar tools, Relevant degree, Master's preferred, Strong knowledge of enterprise integration.

Key responsabilities:

  • Build and maintain a data warehouse solution
  • Develop data models for operational and analytical needs
  • Implement and optimize ETL processes
  • Design high-quality source code and conduct testing
  • Monitor and resolve data quality issues
Panavision logo
Panavision
1001 - 5000 Employees
About Panavision
Panavision is the world-class provider of end-to-end solutions that power the creative vision of filmmakers. Panavision’s comprehensive offerings include unparalleled optics, proprietary camera and lighting systems, and state-of-the-art post production services. Driven by a passion for collaborative innovation, Panavision provides the content creation industry with the highest standard of quality and service. Panavision’s portfolio includes the renowned brands Light Iron, Panalux, LEE Filters, Direct Digital and Island Studios. For more information and locations worldwide, visit Panavision.com.
See more Panavision offers

Job description

Logo Jobgether

Your missions

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. .

Required profile

Experience

Level of experience: Senior (5-10 years)
Spoken language(s):
Check out the description to know which languages are mandatory.

Hard Skills

Data IntegrationPower BITelerikData MiningTeamForgeSQL (Programming Language)Data WarehousingC# (Programming Language)Tableau (Business Intelligence Software)Data ModelingMicrosoft SharePointDatabase ManagementSoftware DevelopmentSsrs 2012Object-Oriented Programming (OOP)Microsoft SQL Servers

Soft Skills

  • Time Management
  • Analytical Thinking
  • Collaboration
  • Problem Solving
  • Microsoft Excel
  • Communication
Are you interested?

Data Scientist Related jobs

See more Data Scientist jobs
Sign in or sign up with Google or LinkedIn