Lead Data Engineer
Contract type :Permanent
Availability :Full time
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.
Currently boasting nearly 150 stores worldwide, Psycho Bunny is on an aggressive growth trajectory throughout the world, catering to confident men who use their bold and elevated style to project the best possible version of themselves. Our collections reflect our uniquely audacious take on timeless staples comprising a suite of the most impeccable menswear known to mankind. Hey, we wouldn't have gone all the way to Peru to source the world's finest Pima cotton if we didn't care so deeply. It comes as no surprise that our customers feel the very same way.
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
Your achievements:
You'll have an entire team in your corner, ensuring that you are seen, heard, respected, and treated the way you want to be treated. That includes access to our employee benefits:
At Psycho Bunny, we believe in the power of face-to-face interaction and the energy of our on-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.
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.
Currently boasting nearly 150 stores worldwide, Psycho Bunny is on an aggressive growth trajectory throughout the world, catering to confident men who use their bold and elevated style to project the best possible version of themselves. Our collections reflect our uniquely audacious take on timeless staples comprising a suite of the most impeccable menswear known to mankind. Hey, we wouldn't have gone all the way to Peru to source the world's finest Pima cotton if we didn't care so deeply. It comes as no surprise that our customers feel the very same way.
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.
- 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.
- 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.
- 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.2. 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.
Your achievements:
- 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.
You'll have an entire team in your corner, ensuring that you are seen, heard, respected, and treated the way you want to be treated. That includes access to our employee benefits:
- 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.
At Psycho Bunny, we believe in the power of face-to-face interaction and the energy of our on-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.