BI Developer & Data Analyst

Montreal, QC, Canada
Contracted
Experienced

BI DEVELOPER & DATA ANALYST (CONTRACT) | LACHINE, QC
Lachine (Montreal), Quebec | 6 Month Contract, Extendable | 2 Openings
Hiring now.
A global energy sector organization is hiring two BI Developer & Data Analyst contractors for its digitalization team in Lachine, Quebec. If you write expert-level SQL and have built on Snowflake, Matillion, AWS and Power BI with SAP data underneath, we want to hear from you.

AT A GLANCE
RoleBI Developer & Data Analyst (Contract)
Openings2
LocationLachine (Montreal), Quebec
Position TypeFull time contract, 6 months, extendable
ScheduleOn site 3 days a week, remote 2 days a week
CompensationCompetitive, based on experience
ExperienceMinimum 3 years full time in Business Intelligence, Data Engineering or Analytics Engineering
Core StackSQL, Snowflake, Matillion, AWS, Power BI, Tableau, SAP ECC or S/4HANA, ASP.NET
ELIGIBILITY REQUIREMENT
  • Must be eligible to access and work with Canadian Export-Controlled Goods, technical data and related systems, in accordance with applicable Canadian regulations and company policies
THE ROLE
You design and build scalable analytics that support manufacturing, engineering and business operations. You develop Snowflake data models, build pipelines in Matillion, integrate SAP data sources, and deliver business-critical dashboards in Power BI. The job takes strong SQL, time with business stakeholders, and the ability to turn complex operational data into insight people can act on.
WHAT YOU'LL DO
  • Design dimensional and analytical data models using star and snowflake schemas
  • Build scalable, reliable data pipelines to support analytics and business intelligence work
  • Develop and optimize advanced SQL queries, views, stored procedures and data models in Snowflake using Matillion
  • Use AWS cloud services for data storage, computation, SQS queues, SNS notifications and Lambda functions
  • Create and maintain interactive dashboards and reports in Tableau and Power BI
  • Model complex SAP transactional data in Snowflake for advanced analytics, reporting and cross-functional business insight
  • Work with business stakeholders to gather reporting requirements, define KPIs and turn business needs into technical builds
  • Use Jira and Confluence within an Agile Scrum framework for sprint planning, backlog grooming, task tracking and technical documentation
  • Develop and maintain ASP.NET applications that support data integration and reporting
  • Support corporate rebranding work
REQUIRED QUALIFICATIONS
  • Minimum 3 years of full time work experience in Business Intelligence, Data Engineering or Analytics Engineering
  • Expert-level SQL development skills with a proven track record of optimizing complex analytical queries
  • Strong experience with Snowflake data warehousing
  • Proficiency in AWS cloud services and data pipeline development
  • Experience with ETL/ELT processes and tools, specifically Matillion
  • Familiarity with data visualization tools such as Tableau and Power BI
  • Hands-on experience analyzing and modeling SAP ECC or S/4HANA data structures, and turning transactional SAP data into business-friendly analytical models
  • Experience with ASP.NET or web application development
  • Excellent collaboration and communication skills, with experience in Agile Scrum environments
PREFERRED QUALIFICATIONS
  • Snowflake certification
  • AWS analytics services
  • Power BI data modeling (DAX)
  • Tableau
  • Python for automation and data processing
  • Git version control
  • Experience in manufacturing or energy industries
  • Knowledge of Machine Learning and LLM models, for the long term
APPLY

Submit your resume and a cover letter detailing your relevant experience with Snowflake, Matillion, SQL and SAP data. Qualified candidates will be contacted quickly.

Share

Apply for this position

Required*
We've received your resume. Click here to update it.
Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

Human Check*