Intermediate Data Scientist to support building a Talent Review Management Tool in Google AppSh[...]

S I Systems; Ottawa, Regina, Montreal; On-site; CAD 80,000 - 100,000; Full time

Job summary

An innovative firm seeks an Intermediate Data Scientist to develop a cutting-edge Talent Review Management Tool using AppSheet for the financial sector. This role involves automating talent management processes, integrating data from Google Sheets and SQL databases, and ensuring user-friendly interface design. The ideal candidate will leverage their expertise in AppSheet and data science to streamline operations and enhance data analysis capabilities. Join a dynamic team that values creativity and technical prowess, and make a significant impact in talent management within the organization.

Qualifications

• 3+ years of experience as a Data Scientist.
• Strong understanding of AppSheet's automation capabilities.
• Experience with API integration and SQL databases.

Responsibilities

• Develop a Talent Review Management Tool using AppSheet.
• Ensure data integrity and automatic updates.
• Implement role-level security and manage user access.

Skills

Data Science

AppSheet Automation

API Integration

Role-Level Security

User Interface Design

AppScript Knowledge

Job description

Intermediate Data Scientist to support building a Talent Review Management Tool in Google AppSheets for a Financial client

Job Type: Contract

Positions to fill: 1

Job End Date: Jul 31, 2025

Pay Rate: Hourly: Negotiable

Job ID: 145287

Our client is looking for an Intermediate Data Scientist to support building a Talent Review Management Tool in Google AppSheets in the Financial Industry.

Overview:

You will build a robust and user-friendly Talent Review Management Tool. This tool will streamline our talent management processes and provide comprehensive data analysis capabilities for our business units.

Must Have's:

• 3+ years of experience as a Data Scientist
• AppSheet Automation and Workflow Expertise : The developer needs a strong understanding of AppSheet's automation capabilities to convert and migrate existing AppScript logic.
• API Integration with Google Sheets and SQL Databases : Experience connecting AppSheet to both Google Sheets and SQL databases, including setting up data refreshes, is essential.
• Role-Level Security Implementation : The developer must be proficient in designing and implementing role-level security within AppSheet.
• User Interface Design in AppSheet : The ability to create user-friendly interfaces for data input and modification is necessary for the talent rating tool.
• Knowledge of AppScript : Familiarity with AppScript is important to understand and migrate existing logic into AppSheet.

Responsibilities:

• Develop and implement a Talent Review Management Tool using AppSheet, based on specified data and technical requirements listed below. i) The tool should allow for individual workbooks for leaders across multiple organizational levels with hierarchical roll-up of talent review data. ii) An AppScript that fulfills several of the technical requirements has been written. It is expected that the AppSheet will convert and migrate existing AppScript logic to AppSheet automation and scripts. iii)The tools should be ready in 8 weeks, including testing and soft launching.
• Ensure data integrity and automatic data updates based on organizational changes. i) Integrate AppSheet with Google Sheets and SQL databases, including weekly data refresh from SQL. ii) The AppSheet should allow for asynchronous and continuous updates, where certain areas within the organization will run Talent Reviews at different times, and where leaders may update the talent ratings as needed
• Implement role-level security and manage user access permissions.
• Design and build user interfaces within AppSheet for efficient data input and modification.
• Provide ongoing support and troubleshooting for the Talent Review Management Tool.
• Ability to extract the collected information on an ongoing basis for dashboard creation and updates