BI Developer and Data Analyst (Snowflake)

Location: Montreal, Quebec, Canada

Company

hirify.global develops energy technologies and data-driven solutions supporting manufacturing, engineering, and energy transformation across a global organization.

What you will do

• Design dimensional and analytical data models using star and snowflake schemas.
• Build scalable data pipelines and optimize SQL queries, views, stored procedures, and Snowflake models using Matillion.
• Use AWS services including SQS, SNS, and Lambda for data storage and computation.
• Create and maintain interactive Power BI and Tableau dashboards for operational reporting and decision-making.
• Model SAP ECC and SAP S/4HANA transactional data in Snowflake and maintain ASP.NET applications supporting data integration and reporting.
• Gather stakeholder requirements, define KPIs, and deliver solutions in an Agile Scrum environment with Jira and Confluence.

Requirements

• At least three years of full-time experience in business intelligence, data engineering, or analytics engineering.
• Advanced SQL development skills and experience with Snowflake data warehousing, ETL/ELT, Matillion, AWS, and scalable data pipelines.
• Practical experience analyzing and modeling SAP ECC or SAP S/4HANA data.
• Experience with Power BI and/or Tableau.
• Strong communication, collaboration, stakeholder engagement, and Agile Scrum experience.

Nice to have

• Knowledge of DAX, ASP.NET, Python, Git, machine learning, or large language models.
• Experience in manufacturing or the energy industry.

Culture & Benefits

• Flexible work environment with flex hours, telecommuting, and digital workspaces.
• Career growth and development opportunities.
• Flexible benefits and savings programs, competitive total rewards, and profit sharing.
• Vacation entitlement with the option to buy additional vacation and parental leave.
• Supportive, collaborative, and inclusive work culture focused on work-life balance and social responsibility.