Match score not available

Business Intelligence (BI) Data Architect - Panavision Vancouver

Remote:

Full Remote

Contract:

Full time

Salary:

75 - 100K yearly

Experience:

Senior (5-10 years)

Work from:

Canada

Offer summary

Qualifications:

5+ years in database administration, Experience with SQL server and Oracle, Expertise in data warehousing, University degree in relevant subject, Proficient in BI and reporting tools.

Key responsabilities:

Design and maintain a distributed database architecture
Architect, build and maintain a data warehouse solution
Implement and optimize ETL processes for accuracy
Conduct forensic analysis of datasets
Develop reports and dashboards for business insights

Panavision

1001 - 5000 Employees

See more Panavision offers

Job description

Your missions

Job Scope:

Panavision has an immediate opening for a Business Intelligence (BI) Data Architect to design, build and maintain a structured data warehouse that supports Panavision’s data analytics, reporting and operations.

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.

Qualified candidates for this position must demonstrate expertise in database architecture, data warehousing, and forensic data analysis as well as implementing data hygiene processes and automated data cleanup. S/he must have an operational, get stuff done attitude, a razor-sharp eye for detail and an aptitude for data management. The successful candidate must be able to leverage their skills to ensure the integrity, performance and security of the data to meet business needs. The role also requires design and maintenance of a distributed enterprise-wide database architecture including maintaining the reporting services for an enterprise level ERM software application.

Key Responsibilities:

Designing and maintaining a distributed enterprise-wide database architecture.
Architect, 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 reporting services, replication, clustering models and data flows.
Conduct forensic analysis of datasets to detect data anomalies and inconsistencies.
Implement and manage automated data cleaning procedures to maintain data integrity and accuracy.
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
Develop manage and test back-ups and recovery plans

Skills/Experience Required:

5+ years of experience in database administration, architecture and data warehousing
Knowledge and understanding of object oriented design
Proven experience with relational databases e.g. SQL server, Oracle…
Experience in forensic data analysis and implementing data hygiene strategies
Proficiency in SQL, database optimization and query performance tuning and stored procedures
Knowledge of BI and reporting tools e.g. PowerBI
Excellent problem-solving and analytical skills
Confident team player that enjoys collaboration
Strong communication and collaboration abilities
Ability to work in a fast-paced, dynamic environment
University degree in relevant subject

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:
$75,000-$100,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.