Specialist Data Analysis
5 days ago
DATABASE SPECIALIST Working with our clients means concretely contributing to their development and supporting more than 12 brands and more than 70 clinics across Canada and the United States.
The Database Specialist manages, maintains, and optimizes the company's databases, including SQL Server and DynamoDB. This role involves administering SQL servers, writing stored procedures, and utilizing Microsoft tools such as SSIS, SSRS, and Power BI for data management and visualization. The specialist will also model and manage NoSQL data in DynamoDB, integrating it with other AWS services and BI tools. This person will work closely with the Senior Director of Technology and the Director of Business Systems to meet the company's data needs.
You have flexible hours because we recognize the need to balance work with life.
You get 3 weeks of vacation, 4 personal days for unforeseen events, 3 additional days during the Holiday season and every Friday afternoon off paid in July and August.
You have a group RRSP with an employer contribution and an annual performance bonus.
This position offers the flexibility of hybrid work, allowing employees to work from their home.
Hold a Bachelor's Degree in Computer Science, Mathematics, or a related field.
Have at least 3-5 years of experience in SQL Server and DynamoDB.
Possess excellent communication skills in French and English (oral and written).
Translate business requirements into technical specifications.
Microsoft SQL Server: Manage backup, restoration, and disaster recovery, including replication and Always On Availability Groups.
Design relational database schemas (tables, indexes, relationships).
Apply data normalization and denormalization.
Write and optimize SQL queries, stored procedures, user-defined functions, and triggers.
Use SQL Server Management Studio (SSMS) and SQL Server Data Tools (SSDT).
Develop ETL processes using SQL Server Integration Services (SSIS).
Create reports with SQL Server Reporting Services (SSRS).
Monitor and optimize database performance, manage indexes, and troubleshoot slow queries.
Amazon DynamoDB: Design model NoSQL data for DynamoDB, including schema design and performance optimization.
Use DynamoDB Query Language (DQL) and understand read/write operations via the AWS API.
Integrate DynamoDB with AWS services like Lambda, S3, Kinesis, and Glue for data extraction and processing.
Script with Python or Node.Js to interact with DynamoDB and automate tasks.
Manage DynamoDB performance, configure read/write capacities, and optimize queries for cost management.
Utilize BI and reporting tools that connect to DynamoDB. Experience with Amazon QuickSight is considered an asset.
SPÉCIALISTE EN BASE DE DONNÉES
Travailler avec nos clients, c'est contribuer concrètement à leur développement et soutenir plus de 12 marques et plus de 70 cliniques à travers le Canada et les États-Unis.
Le spécialiste des bases de données gère, entretient et optimise les bases de données de l'entreprise, notamment SQL Server et DynamoDB. Ce rôle implique l'administration des serveurs SQL, l'écriture de procédures stockées et l'utilisation d'outils Microsoft tels que SSIS, SSRS et Power BI pour la gestion et la visualisation des données. Le spécialiste modélisera et gérera également des données NoSQL dans DynamoDB, en les intégrant à d'autres services AWS et outils de BI. Cette personne travaillera en étroite collaboration avec le directeur principal de la technologie et le directeur des systèmes d'entreprise pour répondre aux besoins de l'entreprise en matière de données.
Notre client est certifié Great Place to Work® en raison de son engagement à créer une culture de soutien et d'inclusion pour chaque membre de l'équipe.
Un horaire flexible, car nous tenons compte de l’importance d’un bon équilibre entre le travail et la vie personnelle
3 semaines de vacances, 4 journées personnelles pour les imprévus, 3 congés durant le temps des Fêtes en dehors des jours fériés et tous les vendredis après-midi de congé payés en juillet et août
La flexibilité du télétravail hybride à partir de la maison
Avoir au moins 3 à 5 ans d'expérience en SQL Server et DynamoDB.
Posséder d'excellentes compétences en communication en français et en anglais (oral et écrit).
Traduire les exigences commerciales en spécifications techniques.
Microsoft SQL Server : Gérer la sauvegarde, la restauration et la reprise après sinistre, y compris la réplication et les groupes de disponibilité Always On.
Concevoir des schémas de bases de données relationnelles (tables, index, relations).
Appliquer la normalisation et la dénormalisation des données.
Écrire et optimiser des requêtes SQL, des procédures stockées, des fonctions définies par l'utilisateur et des déclencheurs.
Utiliser SQL Server Management Studio (SSMS) et SQL Server Data Tools (SSDT).
Développer des processus ETL à l'aide de SQL Server Integration Services (SSIS).
Créer des rapports avec SQL Server Reporting Services (SSRS).
Surveiller et optimiser les performances des bases de données, gérer les index et résoudre les problèmes de lenteur des requêtes.
Amazon DynamoDB : Concevoir des modèles de données NoSQL pour DynamoDB, y compris la conception de schémas et l'optimisation des performances.
Intégrer DynamoDB avec les services AWS comme Lambda, S3, Kinesis et Glue pour l'extraction et le traitement des données.
Script avec Python ou Node.Js pour interagir avec DynamoDB et automatiser des tâches.
Gérer les performances de DynamoDB, configurer les capacités de lecture/écriture et optimiser les requêtes pour la gestion des coûts.
Utiliser des outils de BI et de reporting qui se connectent à DynamoDB.
-
Business Analysis Advisor
1 week ago
Montréal, Canada NTT DATA Full time**Req ID**: 210446 We are currently seeking a Business Analysis Advisor to join our team in Montreal, Quebec (CA-QC), Canada (CA). **SUMMARY OF SKILLS** **Business Analysis Skills**: - Requirement Gathering and Elicitation Skills - Webservices/SOA Architecture - Business Case development. - Definition of as-is/to-be (CMO/FMO) business models - Unified...
-
Ai Data Specialist
1 month ago
Montréal, QC, Canada amaris Full timeJob description Join a dynamic and innovative organization dedicated to harnessing the power of data to support artificial intelligence initiatives. As an AI Data Specialist, you will play a key role in managing, analyzing, and optimizing data to drive AI-based projects and solutions. The AI Data Specialist will be responsible for managing, analyzing, and...
-
Ai Data Specialist
1 month ago
Montréal, QC, Canada Amaris Consulting Full time**Who are we? **:**Amaris Consulting** is an independent technology consulting firm providing guidance and solutions to businesses. With more than 1,000 clients across the globe, we have been rolling out solutions in major projects for over a decade - this is made possible by an international team of 7,600 people spread across 5 continents and more than 60...
-
Specialist, Web Analysis
4 months ago
Montréal, QC, Canada Via Rail Canada Full time-Reference Number: 28961_082024 Status: Permanent - Full time Job Category: Communications/ Marketing City: MONTREAL Province: Quebec Annual Salary / Hourly Rate: 67 859 - 83 826 Number of positions to be filled: 1 Application Deadline: 2024-10-03 Description: Did you know that VIA Rail is carrying out ambitious projects to modernize its services...
-
Manager, Financial Reporting
16 hours ago
Montréal, Canada Estruxture Data Centers Full time**_Manager, Financial Reporting & Analysis_**_** La version française suit la version anglaise **_ **We host the data. We provide the connections. We protect the information.** eStruxture is more than a data center: it's THE largest Canadian data center platform. It's 15 locations across the country, over 760,000 square feet of space, over 130MW of power...
-
Manager, Construction Reporting
1 week ago
Montréal, Canada Estruxture Data Centers Full timeLa version française suit la version anglaise **_ **We host the data. We provide the connections. We protect the information.** eStruxture is more than a data center: it's THE largest Canadian data center platform. It's 15 locations across the country, over 760,000 square feet of space, over 130MW of power and access to over 1,400 network and cloud...
-
Accounts Payable Specialist, Na
5 months ago
Montréal, QC, Canada Vantage Data Centers Full timeAbout Vantage Data Centers Vantage is committed to being a workplace of inclusion, equity, respect and acceptance. We celebrate diversity and intentionally seek out opportunities to learn from one another’s experience. Vantage Data Centers powers, cools, protects and connects the technology of the world’s well-known hyperscalers, cloud providers and...
-
Specialist, Operational Data
2 days ago
Montréal, Canada Business Development Bank of Canada Full timeNo other bank is doing what we do. At BDC, we help Canada and its entrepreneurs create a prosperous, inclusive and green economy. Our mission is to help Canadian businesses thrive by providing financing, capital and advisory services. We’re devoted to Canadian entrepreneurs. We’re also dedicated to our employees. Adaptable. Inspiring. Different....
-
Data Maintenance Specialist Iii can
5 months ago
Montréal, QC, Canada 22nd Century Technologies, Inc. Full time**Duration**: 12 Months - Specialist - Data Steward - Montreal - in office 2-3 days per week - Bilingual - ENG & FR (Spanish an asset) - Strong excel data manipulation skills - Very strong attention to detail - SAP experience We are looking for a Data Analyst to support on data cleansing and issue-resolution. This role is a great opportunity for a...
-
Stakeholder Insights and Data Specialist
1 month ago
Montréal, QC, Canada Novartis Full time**Summary**: Location: Montreal/Toronto, #LI-Hybrid About the role: We are looking for a passionate, proactive and highly motivated individual who wants to have an impact as part of a global innovative medicines company. As the Stakeholder Insights and Data Specialist, you will be responsible for supporting the Communications and Patient Advocacy team in...
-
Information System Security Specialist(Cissp, Sscp
5 months ago
Montréal, QC, Canada NTT DATA Full timeWe are currently seeking a **Information System Security Specialist(CISSP, SSCP, and CISM) - Onsite Hybrid** to join our team in Montreal, Quebec (CA-QC), Canada (CA). **Job Responsibilities Include**: - Conducting remote/in-person interviews with system owners/vendors to get all the required information for assessment and to identify any gaps. - Reviewing...
-
Business Partner, Data Analysis
7 months ago
Montréal, Canada Vosker Full timeCompany Description **VOSKER**, North America's leader in remote area surveillance. Every day, we are proud to help our customers keep an eye on what really matters to them by developing solar-powered, cell-connected cameras on our exclusive platform. But beyond the product, working in IT at VOSKER means receiving and analyzing millions of images per day, a...
-
Payroll Specialist, Na
5 months ago
Montréal, QC, Canada Vantage Data Centers Full timeÀ PROPOS DE VANTAGE DATA CENTERS Vantage s’engage à être un lieu de travail d’inclusion, d’équité, de respect et d’acceptation. Nous célébrons la diversité et cherchons intentionnellement des occasions d’apprendre des expériences de chacun. Vantage Data Centers alimente, refroidit, protège et connecte la technologie des plus grands...
-
Analyst, Data Valorization
2 months ago
Montréal, QC, Canada Desjardins Full timeAs a data analyst, you collect, process, analyze and use data that comes through different channels. You extract, describe, analyze and interpret the data needed to make informed business decisions. You lead stakeholders in projects for designing analytical solutions adapted to a wide range of business needs and in complex strategic data collection,...
-
Analyst, Data Valorization
4 months ago
Montréal, QC, Canada Desjardins Full timeAs a data valorization analyst, you collect, process, analyze and use data that comes through different channels. You extract, describe, analyze and interpret the data needed to make informed business decisions. You lead stakeholders in projects for designing analytical solutions adapted to a wide range of business needs and in complex strategic data...
-
Analyst, Data Valorization
1 month ago
Montréal, QC, Canada Desjardins Full timeAnalyze and identify user needs and work on complex mandates to collect, process and analyze data, taking into account the specifics of their operationalization and ensuring coordination during the rollout.- Develop and improve reports and tools for interpreting operationally and conceptually complex data to influence the sector's strategic decision-making.-...
-
Analyst, Data Valorization
3 months ago
Montréal, QC, Canada Desjardins Full timeAnalyze and identify user needs and work on complex mandates to collect, process and analyze data, taking into account the specifics of their operationalization and ensuring coordination during the rollout- Develop and improve reports and tools for interpreting operationally and conceptually complex data to influence the sector's strategic decision-making-...
-
Analyst, Data Valorization
4 months ago
Montréal, QC, Canada Desjardins Full timeAnalyze and identify user needs and work on complex mandates to collect, process and analyze data, taking into account the specifics of their operationalization and ensuring coordination during the rollout- Develop and improve reports and tools for interpreting operationally and conceptually complex data to influence the sector's strategic decision-making-...
-
Director Management Insights, Analysis
2 months ago
Montréal, QC, Canada Sun Life Full timeYou are as unique as your background, experience and point of view. Here, you’ll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, you'll...
-
Aero Engines Specialist
4 months ago
Montréal, QC, Canada Database Technology Full time**Job Role: Aero Engines Specialist - Engine Programs & Accessories** **Location: Montreal, QC-Canada** **Pls share skill matrix with submission**: - Yrs of exp in Aero Engine experience - Yrs of exp in stakeholder management. - Yrs of exp in LRU reliability data. **Must have Key skill - Aero Engine experience, LRU (Line replaceable Unit) specialist,...