Business Intelligence Data Architect

This is a Full Time Job

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-state / 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:

US: $80,000 - $145,000 / CDN: $75,000 - $100,000

Salary ranges vary based on location, experience, and skills of qualified candidates.

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.