Developer, Snowflake

IMAX is not your everyday entertainment experience. With over 50 years of history as a global innovator in entertainment technology, our employees and their careers have constantly gone beyond the ordinary at IMAX. We combine proprietary technology with industry-leading knowledge and relationships with top studios and filmmakers to create theatrical experiences that take audiences beyond the edge of their seats to a world they never imagined. IMAX has revolutionized the way people experience movies and continues to push the boundaries of entertainment experiences beyond blockbusters and into exciting new directions.

Come explore IMAX - where innovation, creativity and passion come together. Get inspired, get involved, and ignite your future with IMAX!

Job Description:

We are seeking a skilled and experienced Snowflake Developer to manage and optimize our Snowflake data warehouse running on AWS. The ideal candidate will have a deep understanding of Snowflake architecture, AWS ecosystem, and modern data lake and data warehousing principles. Proficiency in Python for scripting, data transformation, and integration tasks is essential. You will play a critical role in ensuring our data infrastructure is efficient, secure, and scalable, while also supporting analytics and business intelligence initiatives.

What you'll be doing:

• Design, implement, and maintain Snowflake data models, schemas, and databases to support business needs.

• Develop and optimize Snowflake objects such as tables, views, stages, and stored procedures.

• Manage Snowflake user roles, permissions, and security policies to ensure data governance and compliance.

• Monitor and fine-tune Snowflake performance, including query optimization, clustering, and resource utilization.

• Collaborate with the DevOps and Cloud teams to manage Snowflake instances hosted on AWS.

• Implement data pipelines for ingesting, transforming, and loading data into Snowflake using AWS services such as S3, Lambda, Glue, and Step Functions.

• Design and maintain data lake architectures integrated with Snowflake.

• Ensure cost-effective use of AWS resources and recommend optimizations as needed.

• Write Python scripts for ETL/ELT processes, data validation, and orchestration.

• Automate repetitive tasks such as data ingestion, backups, and monitoring.

• Build reusable data transformation functions and frameworks.

• Work closely with data engineers, analysts, and business stakeholders to understand requirements and deliver solutions.

• Provide technical support for data queries and troubleshoot issues in Snowflake or AWS integrations.

• Document solutions, processes, and best practices for Snowflake administration and development.

What we're looking for:

• Bachelor's degree in Computer Science, Information Technology, or a related field.

• 3+ years of experience working as a Snowflake developer/administrator or in a similar role.

• Proficient in Snowflake features, including Snowpipe, Streams, Tasks, Time Travel, and Data Sharing.

• Strong understanding of AWS services like S3, EC2, IAM, Lambda, Glue, and Redshift.

• Experience with data lake and data warehousing concepts and implementation.

• Solid Python programming skills for scripting, data transformation, and API interactions.

• Familiarity with SQL and its advanced features, such as window functions and performance tuning.

• Power BI experience is an asset.

• Experience with orchestration tools like Apache Airflow or AWS Step Functions.

• Knowledge of data governance and compliance frameworks (e.g., GDPR, HIPAA).

• Exposure to data visualization tools such as Tableau, Power BI, or Looker.

• Familiarity with CI/CD pipelines and version control tools like Git.

• Strong problem-solving and analytical skills.

• Excellent communication and teamwork abilities.

• Self-motivated and capable of managing multiple priorities effectively.

• Hands-on experience with Snowflake on AWS is mandatory.

At IMAX, you will be part of a culture built on respect - we are committed to creating a welcoming and diverse atmosphere across our organization.

For consideration, please apply online. We thank all applicants for their interest in IMAX but only those selected for an interview will be contacted.

IMAX will consider for employment all qualified applicants, including those with criminal histories, or arrest or conviction records, in a manner consistent with applicable state and local laws, including the City of Los Angeles' Fair Change Initiative For Hiring Ordinance, the Los Angeles County Fair Chance Ordinance for Employers, and the California Fair Chance Act, where applicable.