Permanent
Montreal, Canada
Posted 3 weeks ago

MAYA2087

MAYA HTT is the largest simulation company in Canada and a world leading developer of mechanical engineering simulation software and Datacenter Infrastructure Management solutions. Constantly pushing the boundaries, MAYA is at the forefront of the next level cutting edge technologies such as AI, machine learning, IoT and Industry 4.0 innovations.

Reporting to the Director of Finance & Administration, and supporting the data manipulation and reporting needs of the finance and sales teams, the SQL-BI Developer contributes to business growth by developing business intelligence solutions. His previous experience enables him to develop and enhance applications working with MS SQL Server, MS Access as well as REST API based solutions.

What to expect as the main responsibilities:

  • Work directly with applications’ owners and oversee end to end solution implementation
  • Support and improve existing database solutions and reporting
  • Understand the business issues and data challenges of the organization
  • Gather application requirements and translate into SQL Server programming
  • Support existing Sales and Royalties Databases (MS Access front-end app, MSSQL back-end) and data cube (SSAS). Excel data exchange with existing databases.
  • Design and maintain reports custom reports using SQL Reporting Server
  • Plan and conduct database unit and system tests; assess results and apply corrective actions
  • Support and maintain multiple Windows Service applications related to:
    • Salesforce (Automated Data gathering service, Quote Generator, Cloud data backup, APEX)
    • Exchange rates imports
    • JIRA automated services via REST API
    • Sharepoint and SQL database integration via REST API
  • Documents the code and activities on which you are working on
  • Maintaining task-related environments to ensure a constant level of service

Required skills:

BI Development

  • Designing, developing and maintaining reporting and business intelligence solutions using SSRS and SSAS, DAX query language and MDX queries
  • Crafting and executing queries upon request for data
  • Presenting information through reports and visualization

Database Management

  • Strong knowledge of Microsoft SQL database, Microsoft development tools (SSRS, SSAS, SSIS and Visual Studio) and programming language T-SQL
  • Significant experience with Microsoft Access
  • Ability to write performant SQL code and to optimize existing code
  • Establish the needs of users, and monitor user access and security
  • Consider both back-end organization of data & front-end accessibility for end-users
  • Debug store procedures and creation of new ones if needed
  • Monitoring/Managing SQL server jobs and create new ones if needed

Programming

  • .NET programming (C#, C++, VB) with entity framework on Visual Studio integrated development environment
  • Integrate new code with existing Databases
  • Produce spreadsheets with parsed data
  • Multi-threaded programing
  • Knowledge of XML structures

Preferred skills:

  • Experience working with Data Warehouse solutions, and with reporting and analytic presentation tools and technologies such as Tableau or PowerBI
  • Programming knowledge on VB.NET and JAVA

Minimum Requirements:

  • Bachelor degree in computer science, engineering, or equivalent related project experience
  • At least 5 years of experience in SQL database programming
  • Solid computer science fundamentals such as algorithms, data structures and programming skills
  • The ability to manage tasks from start to finish with the aim of a job well done
  • Ability to work both independently and within a close team
  • Ability to interact with and manage multiple internal customers
  • Effectively communicates with stakeholders to identify needs and evaluate alternative solutions
  • Ability and willingness to multi-task, work under pressure and with minimal supervision
  • Fluent in English, written and spoken. French is an asset.

Why join MAYA?

  • Permanent position, competitive base salary, bonuses and annual performance reviews
  • Fully paid by the employer medical, dental, life, short/long term disabilities insurance
  • Lots of things to learn through skilled sparring partners
  • Accessible via public transit, 4 minutes’ walk from Vendome metro & train station
  • Become a key member of a dynamic and award winning company that is a recognized worldwide industry leader

Job Features

Job CategoryAdministration

Apply Online

A valid email address is required.
A valid phone number is required.

Subscribe To Newsletter

You have Successfully Subscribed!

Pin It on Pinterest