Groupe Dynamite Inc. (GDI) is a Montréal-based, privately held house of integrated omni-channel brands, designing and distributing accessible, trend-forward fashion for women since 1975.

Our mission of "Empowering YOU to be YOU, one outfit at a time" is brought to life through the GARAGE and DYNAMITE banners and represents the consumer-centric core of GDI's long-standing success as a leading retailer in North America.

Today, GDI operates nearly 300 stores across Canada and the United States, as well as shoppable brand experiences at Garageclothing.com and Dynamiteclothing.com.

Job Summary:

As an Analytics Engineer II, you will play a critical role in bridging the gap between data engineering and business analytics. You will be responsible for designing, building, and maintaining robust data models and analytics-ready datasets that empower the organization to make data-driven decisions. Leveraging your expertise in data modelling, transformation, and governance, you will ensure high data quality, consistency, and accessibility for analytics and reporting across GDI. You will collaborate closely with data engineers, data scientists, business analysts, and cross-functional business stakeholders to support key initiatives.

Responsibilities:

• Own and lead the design and implementation of scalable, maintainable, and reliable data models using dbt and SQL, transforming complex raw data into clean, business-ready datasets that directly support strategic decision-making;

• Partner proactively with business stakeholders and business analysts to deeply understand evolving data requirements and independently translate business objectives into robust technical solutions;

• Establish and enforce data quality checks, version control standards, and documentation frameworks to ensure long-term trust, consistency, and transparency in critical data assets across the organization;

• Lead the development and enhancement of ETL/ELT pipelines to ingest, transform, and deliver data from diverse internal and external sources, managing transitions across technology platforms (e.g., SQL Server to Snowflake) with minimal disruption;

• Drive the performance optimization of data models and queries for scalability, cost efficiency, and operational excellence across platforms such as Snowflake, BigQuery, and Azure;

• Champion self-service analytics by designing and delivering intuitive, well-documented semantic layers and/or curated datasets in Sigma that empower cross-functional teams—including digital marketing, finance, and sales operations—to access and leverage reliable data independently;

• Maintain and evolve comprehensive documentation of data models, transformation logic, and enterprise-wide data definitions to foster cross-team knowledge sharing and support a data-literate culture;

• Act as a thought leader by continuously monitoring emerging technologies, evaluating new tools, and identifying opportunities to advance data capabilities in alignment with business priorities.

Qualifications:

• Bachelor’s degree in Computer Science, Information Systems, Statistics, Mathematics, or a related field;

• 3+ years of experience in data analytics, data engineering, or analytics engineering roles;

• Expertise in SQL and data modelling concepts (schemas, CTEs, macros, etc.);

• Hands-on experience with dbt (data build tool) for data transformations and modelling;

• Proficiency with Snowflake and Big Query;

• Experience with BI tools such as Power BI and Sigma;

• Strong understanding of ETL/ELT development, data integration, and API data ingestion;

• Excellent problem-solving and critical-thinking skills, with a strong attention to detail and passion for data quality;

• Strong communication skills, with the ability to collaborate effectively with both technical and non-technical stakeholders;

• Experience with version control (e.g., Git) and CI/CD processes for data pipeline management;

• Experience in retail or E-commerce industries is an asset.

At GDI, you will be part of a growing organization that understands the importance of investing in people and offers you:

• A comprehensive compensation package that includes performance-driven bonuses;
• A group retirement savings program with employer matching;
  Flexible group insurance with personalized coverage that meets your needs;An
• discount at Garage and Dynamite;
• Exclusive private sample sales;
• A flexible vacation policy;
• And more!

GDI has been repeatedly voted one of Montréal’s Top Employers and one of Canada’s Top Employers for Young People.

Our promise…
No day will be like the last—we aim to be better today than we were yesterday. We are committed to employment equity.

Candidates that are retained will be called for an interview.

#LI-NM1