Job summary

Posted on
17.02.2021

Category
Information Technology Jobs; Finance Jobs

Job type
Long Term Contract

Career level
Experienced

Education Level
Bachelor's Degree

Years of Experience
5 and more

Ref ID
1060624320

Apply

Back to all jobs

SQL Analyst-Programmer

Company: Intelli5 Location: Montreal

Job description

One of our clients from the financial investment industry is currently looking for a SQL Programmer-Analyst to join their team.

Description of tasks and responsibilities

The Integration and Data Services team is looking for a Business Intelligence Specialist to help develop and support analytical solutions. The mandate is to take charge of the following activities:

- Model and integrate data respecting the defined architecture and best practices;

- With a very high level of expertise in structured data interrogation, develops in agile and interactive mode, with business lines, analytical solutions that meet their needs;

- Work closely with the business bus support team (ESB) to strengthen the management, use and improvement of master data "Master data management";

- Documents ongoing development activities and their progress.

Job requirements

- More than 5 years of relevant experience in business intelligence projects using Microsoft SQL, SSAS and SSIS technology;

- Advanced Transact-SQL development;

- Optimization of SQL Server performance:

- Interpret the different stages of the execution plan to optimize the indexes and / or the query;

- Good knowledge of table storage and SQL indexes (index optimization, clustered vs non-clustered indexes, columnstore indexes, filtered indexes, partitioning of tables and indexes).

- Advanced ETL development with SSIS; C # development for SSIS (Script Tasks and Script Components);

- SSAS Multidimensional: Data modeling and MDX development (intermediate / advanced);

- SSAS Tabular: Modeling of datasets and DAX development (intermediate / advanced);

- Automation of tasks with Power Shell;

- Knowledge of source code management and familiarity with release pipelines with Azure Devops, Git and TFS;

- Experience using statistical tools such as Python or R is an asset;

- Experience with the world of financial investment is an asset;

- Demonstrate great autonomy as well as a sense of initiative to move issues forward;

- Ability to communicate effectively, both orally and in writing;

- Ability to work within the framework of agile methodologies;

- Ability to work in a team;

- Bachelor's degree in IT or other relevant discipline.

Apply

Similar jobs

Azure Data Engineer
  • 15.12.2021
  • Information Technology Jobs
  • Montreal
Long Term Contract
Senior Change Management Advisor
  • 15.12.2021
  • Other Jobs, Information Technology Jobs
  • Montreal
Long Term Contract
HR Business Analyst
  • 10.12.2021
  • Information Technology Jobs, Human Resources
  • Montreal
Long Term Contract
Team Lead - Project Office
  • 10.12.2021
  • Information Technology Jobs
  • Montreal
Long Term Contract
Enterprise Architect
  • 09.12.2021
  • Information Technology Jobs
  • Montreal
Long Term Contract
Business Analyst
  • 30.11.2021
  • Information Technology Jobs
  • Montreal
Long Term Contract
Hybrid Office Analyst
  • 17.11.2021
  • Information Technology Jobs
  • Montreal
Long Term Contract
Data Analyst - Digital Products
  • 17.11.2021
  • Information Technology Jobs
  • Montreal
Long Term Contract
Solution Architect
  • 10.11.2021
  • Information Technology Jobs
  • Montreal
Long Term Contract
Power BI Architect
  • 10.11.2021
  • Information Technology Jobs
  • Montreal
Long Term Contract
Back to top