Lead Data Engineer

PSYCHO BUNNY; Montreal; On-site; CAD 80,000 - 120,000; Full time

Job summary

A premium clothing brand in Montreal is seeking a skilled Data Engineer to drive their data strategy. The role involves building and maintaining data infrastructure for advanced analytics while ensuring data quality and security. Candidates should have significant experience with Snowflake, Python, and data integration tools. Benefits include comprehensive group insurance, generous vacation time, and flexible working options.

Benefits

Group Insurance coverage

Generous RRSP/DPSP match

Employee Assistance Program

On-site gym

Casual dress code

Subsidized cafeteria meals

Three weeks of vacation

Wellness days

Birthday off

Discount on clothing

Qualifications

• 6 to 8 years of experience in a related field.
• Extensive experience with Snowflake capabilities.
• Proficiency in Python, SQL, Java or Scala.

Responsibilities

• Build and maintain data infrastructure for advanced analytics.
• Ensure data quality and integrity across the organization.
• Manage loading and transformation of data effectively.

Skills

Data Integration

Python

SQL

Kafka

AWS

Snowflake

Education

Diploma in Computer Science, Data Engineering, or a related field

Tools

Snowflake

Apache Airflow

Fivetran

Matillion

Job description

WHO WE ARE

Headquartered in Montreal, Psycho Bunny is a premium global clothing brand known for its unparalleled quality, colorful styles and an unforgettable iconic logo featuring a quirky, stylized bunny. Founded in 2004, it initially gained popularity for its premium polo shirts but has since expanded to include a full range of apparel and accessories for men, women, and children. The brand emphasizes a playful and irreverent approach to classic fashion, blending a casual aesthetic with striking designs.

WHY JOIN THE TEAM?

In 2024, we set out to create a whole new way to express the brand. Introducing The Bold Standard. The very essence of Psycho Bunny. The pure DNA of the brand itself. Born out of our relentless commitment to consummate quality, striking design, and a thoroughly audacious, adventurous lifestyle. It's a state of mind, an attitude, an ethos, a mantra, a rallying cry, a veritable religion, plus one thoroughly iconic Bunny logo.

What's more, after our highly successful first volley into tennis, Psycho Bunny is proud to announce we are now the Official Athletic Apparel Partner of Tennis Canada. As a fervent tennis-loving brand, we will continue to celebrate our passion for premium quality, striking aesthetics, and audacious living throughout the tennis world, steering the sport in a bold new direction. We couldn't be more proud of our partnership. Call it game, set, and a perfect match.

WHAT IS THE ROLE?

The Data Engineer reports to the Director of Data and Analytics and plays a critical role in driving the company's data strategy by building and maintaining the data infrastructure necessary for advanced analytics and business intelligence. You will ensure the seamless integration, management, and security of data across the organization. Your work will empower stakeholders with the insights they need to make data-driven decisions that impact business operations and overall strategy.

HOW WILL YOU DO IT?

Data Pipeline Management

• Partner with business unit leaders to understand all data needs and requirements, ensuring alignment with business objectives.
• Design, develop, and maintain reliable data pipelines that efficiently process large volumes of data according to evolving business needs.
• Implement systems and practices to ensure data is accessible and usable for business intelligence tools, data analytics teams, and other stakeholders.
• Manage the loading and transformation of data through both technical processes and business logic.
• Produce strategic data that adds value and contributes to the organization's growth and competitiveness.

Data Quality and Integrity

• Establish and enforce data quality standards, methodologies, and systems to ensure data accuracy and reliability.

  Monitor data ingestion and processing, resolving any discrepancies and ensuring smooth data flows.

• Collaborate with data source providers, Psycho Bunny vendors and internal stakeholders to address data quality issues effectively.
• Catalog and document the data sources needed to implement self-service analytics across the organization.
• Process Improvement: Continually improve ongoing reporting and analysis processes and practices to enhance data quality and efficiency.

Data Governance

• Establish and adhere to data governance policies and standards.
• Ensure all data management practices comply with industry and government regulations and company policies.
• Maintain comprehensive documentation of data processes, ensuring transparency and accessibility for stakeholders.

Database Design

• Design and implement scalable database architectures using Snowflake, tailored to meet the company's growing data needs.
• Lead the design and implementation of scalable, cloud-based data pipelines using Snowflake.
• Develop robust data models for managing retail datasets such as inventory, sales, customer behavior, and supply chain.
• Optimize Snowflake configurations for performance and cost-efficiency.
• Pipeline Development
• Build, monitor, and maintain ETL/ELT pipelines to process large volumes of retail data from multiple sources (e.g., POS systems, e-commerce platforms, CRM, and ERP systems).
• Leverage tools like dbt, Apache Airflow, Astronomer for orchestration and transformation.
• Develop and maintain data models that support efficient querying and reporting across various business domains.
• Optimize database performance through indexing, partitioning, and other database management techniques.
• Tune data pipelines for low latency and high availability to meet the dynamic needs of the retail business.
• Implement strategies for efficient handling of high-velocity data (real-time inventory, demand forecasting, customer preferences, customer 360).
• Stay updated with the latest Snowflake features, retail analytics trends, and data engineering best practices.
• Design and implement frameworks for data quality, governance, and lineage tracking.

Data Security and Privacy

• Implement and maintain robust security measures to protect sensitive data from unauthorized access and breaches.
• Ensure data practices align with privacy regulations such as GDPR, CCPA, or other relevant policies to your industry.
• Manage data access controls, ensuring that only authorized users have access to sensitive information.

WHO YOU ARE

• 6 to 8 years of experience in a related field
• Diploma in Computer Science, Data Engineering, or a related field
• Extensive experience with Snowflake, including Snowflake-specific capabilities like virtual warehouses, zero-copy cloning, and Snowpipe.
• Proficiency in Python, SQL, and Java or Scala for large-scale data processing.
• Hands‑on experience with Kafka, Spark, or similar tools for streaming and batch processing.
• Advanced knowledge of AWS, Azure, or GCP; experience with integrating Snowflake into cloud ecosystems such AWS.
• Data Integration: Proficiency with ETL/ELT tools like Fivetran, Matillion, or Informatica.
• Strong project management skills to deliver on complex, multi‑stakeholder data projects.
• Excellent communication skills to collaborate with both technical and non-technical stakeholders.

WHAT WE OFFER

• Group Insurance coverage, including health, dental, vision, life, and long-term disability.
• Psycho Bunny offers all Canadian employees the possibility to participate in a group RRSP/DPSP plan, which includes a very generous match from Psycho Bunny!
• An Employee / Family Assistance Program (EFAP).
• Casual dress code.
• Company events and social hours.
• On‑site gym.
• On‑site cafeteria / bistro with subsidized meals, including breakfast and lunch.
• Three (3) weeks of vacation.
• Six (6) wellness days.
• Your birthday off, on us.
• On‑site parking, including electric car chargers.

Last but not least, let us not forget the swag you can get with an amazing employee discount!

At Psycho Bunny, we believe in the power of face‑to‑face interaction and the energy of our in‑site work environment. We also recognize the importance of flexibility in today's dynamic world. Employees have the option to work remotely on occasions when personal or professional circumstances require it while still maintaining our strong culture of in‑person collaboration and innovation.

We thank all applicants; however, only those selected for an interview will be contacted.